Greetings,

Is there anyway to place the value/contents of a cell (A1) on the
active sheet into a cell (AA1) on an inactive sheet? Example: The
contents of cell A1 on sheet 1 is a date. There are 19 other sheets
with a date in A1, each date is different. I need the date from the
sheet that I am on to sow up in cell AA1 on a sheet called Data. A
formula on Data is looking to A1 on the active sheet to give a
response to the active sheet from the list property of sheet 1. What
I have was designed for only one sheet working with one Data sheet.
If anyone has any ideas or samples of other possibilities, PLEASE
reply, this is driving me up a wall!!!!

TIA

-Minitman

In Data put in this formula

=INDIRECT(RIGHT(CELL("filename"),LEN(CELL("Filename"))-FIND("]",CELL("filena
me")))&"!A1")

After a calculate, this will return the value from A1 in the active sheet.
This only works if the workbook has been saved at least once so it has an
actual filename.

--
Regards,
Tom Ogilvy


"Minitman" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
> Greetings,
>
> Is there anyway to place the value/contents of a cell (A1) on the
> active sheet into a cell (AA1) on an inactive sheet? Example: The
> contents of cell A1 on sheet 1 is a date. There are 19 other sheets
> with a date in A1, each date is different. I need the date from the
> sheet that I am on to sow up in cell AA1 on a sheet called Data. A
> formula on Data is looking to A1 on the active sheet to give a
> response to the active sheet from the list property of sheet 1. What
> I have was designed for only one sheet working with one Data sheet.
> If anyone has any ideas or samples of other possibilities, PLEASE
> reply, this is driving me up a wall!!!!
>
> TIA
>
> -Minitman