I thought I would join you all on this, like Fritz I have a similar workbook;
however, I have 2 sheets identical information that need to be merged into a
summary, the 2 sheets are for 2 different people/cities to enter similar info
to Fritz and the Summary sheet is for my manager to review both so we could
do some analysis after the data is merged and not have to copy paste
everytime they enter more data
--
Thanks again, Herz and His


"Teethless mama" wrote:

=IF(Sheet1!A1="",Sheet2!A1,Sheet1!A1)


"Fritz" wrote:

I have 3 worksheets in one workbook.
Either sheet 1, or sheet 2 will have data in it but not both.
The third worksheet is a summary report that I want to draw certain cell
contents into ie. Unit #, Serial Number, Make, Model etc.

Sounds like an "either/or" function. Or should I use an "If then" function?