I have a workbook with 5 worksheets. If a date is typed in a merged cell (2
cells) on worksheet one, I want the date to automatically be placed on
worksheet 5 in another merged cell (3 cells).

On the other worksheet(s), just put a formula to reference the
worksheet with the date.

for example, if the date is in cell A1 on Sheet1 then in cell A1 (or
whatever cell you choose) on Sheet2 put the following formula: =Sheet1!
a1.


If you only want the date to appear when a value is entered (i.e. the
cell is not blank) use this formula: =if(isblank(sheet1!a1),"",sheet1!
a1)



On Jul 17, 9:38*am, Taz22i wrote:
I have a workbook with 5 worksheets. *If a date is typed in a merged cell (2
cells) on worksheet one, I want the date to automatically be placed on
worksheet 5 in another merged cell (3 cells). *

In the target cell (ie, the one on worksheet 5), put the formula

=Sheet1!A1

Where Sheet1 is the name of worksheet one, and A1 is the cell where you
enter the date.

Regards,
Fred.

"Taz22i" wrote in message
...
I have a workbook with 5 worksheets. If a date is typed in a merged cell
(2
cells) on worksheet one, I want the date to automatically be placed on
worksheet 5 in another merged cell (3 cells).