Summaryt Report
 

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?

Summaryt Report
 

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!A 1<"",Sheet1!A2<"")),"Houston,
we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet1!A2))

"Fritz" wrote in message
...
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?

Summaryt Report
 

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

Something like =IF(OR(Sheet1!A10,Sheet2!A10),"Someting","Nothin g")

HTH
Michael M


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

Summaryt Report
 

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

"Dave Thomas" wrote:

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!A 1<"",Sheet1!A2<"")),"Houston,
we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet1!A2))

"Fritz" wrote in message
...
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?

Summaryt Report Corrected for data in A1 on Sheet1 and Sheet2 - result on Sheet3
 

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!A 1<"",Sheet2!A1<"")),"Houston,
we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet2!A1))

"Fritz" wrote in message
...
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?

Summaryt Report Corrected for data in A1 on Sheet1 and Sheet2
 

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

"Dave Thomas" wrote:

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!A 1<"",Sheet2!A1<"")),"Houston,
we have a problem",IF(Sheet1!A1<"",Sheet1!A1,Sheet2!A1))

"Fritz" wrote in message
...
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?

Summaryt Report
 

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

Summaryt Report
 

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?