Working with multiple worksheets at the same time.
Thanks that worked, but I just realized something.
I will be adding more data in sheet 1, so the cell won't always be D362.
It may be D374 as I keep adding data to this sheet, but the Cell D31 in the
other worksheet should always be the same. Is there a way to handle this?
"Warren Easton" wrote:
Hi Greg,
If your first worksheet = Sheet1 then type the following into Cell D31 on
your second worksheet.
='Sheet1'!D362
--
Regards
Warren
Excel Novice
Addiewell, Scotland.
If this helps please click the Yes button.
"Greg M" wrote:
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?
|