View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Working with multiple worksheets at the same time.

Hi Greg

Don't have the sheets Grouped.
In cell D31 of Sheet 2 enter
=Sheet1!D362

--
Regards
Roger Govier

"Greg M" <Greg wrote in message
...
How do I change the date in one worksheet, and at the sametime it changes
the
date in another worksheet? I have grouped the worksheet that I want to
edit
data on but, for example when I enter the date in cell D362 in one
worksheet,
it will enter the same date in cell D362 of the other worksheet. I don't
want that. I would like the date to be changed in cell D31. How do I do
this?