How can I consolidate three worksheets into one?
 

These are three data sheets, and not all cells have information in them. I
am trying to make them into one worksheet to make it easier to use. I have a
header row and the first column is the same on all three worksheets with
facility identifying information. Can I compare the data in the header
column and merge the three sheets together that way?

How can I consolidate three worksheets into one?
 

Hello,

in a 4th sheet you can use the function "consolidate" (under data). and you
can shoose to consolidate you 3 worksheets.

hope it's usefull
flo


"Denise" wrote:

These are three data sheets, and not all cells have information in them. I
am trying to make them into one worksheet to make it easier to use. I have a
header row and the first column is the same on all three worksheets with
facility identifying information. Can I compare the data in the header
column and merge the three sheets together that way?