Summaryt Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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))
 
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
 
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
 
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))
 
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
 
Back
Top