To grab the contents of a cell on another sheet just start where you want the
duplicate to appear with an equal, go to the sheet that has the cell you want
and click on the cell. Then hit ENTER. It will take you back to your
starting point with the duplicate entry.

Hope this helps
Teeder

"Colonel Flagg" wrote:

i have a spreadsheet(s) that gives me a total for other sheets. done this
many times, the one thing i haven't done is generate a sheet that will
DUPLICATE a cell from another sheet exactly, without a "sum", etc.

i thought lookup would do it:

=LOOKUP("TEXT",'151a'!I1:J1)

that returns an N/A.

what i am looking to do is, have the exact same contents (it's a DATE)
that's in sheet 151a, cells i6:j1 be placed in the report sheet.

ideas?


/CF