View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default transfer cell value from 1 sheet to another without copy/paste?

Either set the other sheets to have formulas to reference the original
sheet:
='Sheet 1'!A1

Or select all the sheets at the same time (Use Shift and/or Ctrl) and then
type your value.

--
Best Regards,

Luke M
"sbmiller" wrote in message
...
I need to enter a value 1 time and have it appear on additional sheets,
without copying and pasting to other sheets. Please help. I'm trying to