Summaryt Report

F

Fritz

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?
 
D

Dave Thomas

This formula checks for data in both cells on sheet 1 or no data in either
cell and generates an error if so. If only one of the two cells has data, it
copies the data to sheet2.
The cells on sheet1 are A1 AND A2

=IF(OR(AND(Sheet1!A1="",Sheet1!A2=""),AND(Sheet1!A1<>"",Sheet1!A2<>"")),"Houston,
we have a problem",IF(Sheet1!A1<>"",Sheet1!A1,Sheet1!A2))
 
M

Michael M

hi Fritz
If Sheet1 and Sheet2 are identical, I would use an IF(OR funtion.

Something like =IF(OR(Sheet1!A1>0,Sheet2!A1>0),"Someting","Nothing")

HTH
Michael M
 
M

Michael M

Hi Dave
I think the OP was looking for a comparison of Sheets1 & 2, not 2 cells in
the one sheet !
Unless I'M wrong. !!

Michael
 
D

Dave Thomas

This formula checks for data in cell A1 on both sheet1 and sheet2 or no data
in either
cell and generates an error if so. If only one of the two cells has data, it
copies the data to sheet3.

The formula entered on some cell on Sheet3 is:

=IF(OR(AND(Sheet1!A1="",Sheet2!A1=""),AND(Sheet1!A1<>"",Sheet2!A1<>"")),"Houston,
we have a problem",IF(Sheet1!A1<>"",Sheet1!A1,Sheet2!A1))
 
M

Michael M

Dave
I'm glad I emphasised the "Unless I'm wrong" part of my post.
Regards
Michael
 
H

HERZHIS

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
 
Top