Combine three worksheets

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

Guest

I have three worksheets in different workbooks with identical format but different data. I need to combine the three sheets, maintain formatting and be able to sort the combined worksheet. The "combine" needs to be automatic by simply opening the combined workbook

Can anyone help?
 
Hi
not quite sure HOW you want to combine them?
- add the values for each cell?
- put parts of the worksheets below each ofther

For the summing procedure enter the following in cell A1
='path\[book1.xls]sheet1'!A1 + 'path\[book2.xls]sheet1'!A1 +
'path\[book2.xls]sheet1'!A1
and copy this for all cells
 
I am combing all rows/cols and this does NOT involve any math functions. I would like the "combined" worksheet to update automatically when someone opens it. I've tried using the "=" and select the cells in the source worksheet...but empty cells appear as "0". rather than blank

Any help is appreciate

Jerry

----- Frank Kabel wrote: ----

H
not quite sure HOW you want to combine them
- add the values for each cell
- put parts of the worksheets below each ofthe

For the summing procedure enter the following in cell A
='path\[book1.xls]sheet1'!A1 + 'path\[book2.xls]sheet1'!A1
'path\[book2.xls]sheet1'!A
and copy this for all cell


-
Regard
Frank Kabe
Frankfurt, German


JerryB wrote
 
Frank

I want to put all rows from the three workbooks into one master combined worksheet and then sort the combined worksheet. While retaining all org formatting and eliminating the "0" which seems to appear when a cell in the source worksheet is blank

Th

Jerry

----- Frank Kabel wrote: ----

H
not quite sure HOW you want to combine them
- add the values for each cell
- put parts of the worksheets below each ofthe

For the summing procedure enter the following in cell A
='path\[book1.xls]sheet1'!A1 + 'path\[book2.xls]sheet1'!A1
'path\[book2.xls]sheet1'!A
and copy this for all cell


-
Regard
Frank Kabe
Frankfurt, German


JerryB wrote
 
Hi
to get rid of the zero use a formula like
=IF('path\[book1.xls]sheet1'!a1="","",'path\[book1.xls]sheet1'!a1)

be careful sorting these formulas. This could lead to unexpected
results!


--
Regards
Frank Kabel
Frankfurt, Germany

Frank,

I want to put all rows from the three workbooks into one master
combined worksheet and then sort the combined worksheet. While
retaining all org formatting and eliminating the "0" which seems to
appear when a cell in the source worksheet is blank.

Thx

JerryB

----- Frank Kabel wrote: -----

Hi
not quite sure HOW you want to combine them?
- add the values for each cell?
- put parts of the worksheets below each ofther

For the summing procedure enter the following in cell A1
='path\[book1.xls]sheet1'!A1 + 'path\[book2.xls]sheet1'!A1 +
'path\[book2.xls]sheet1'!A1
and copy this for all cells


--
Regards
Frank Kabel
Frankfurt, Germany

I have three worksheets in different workbooks with identical
Click to expand...
format > but different data. I need to combine the three sheets,
maintain > formatting and be able to sort the combined
worksheet. The "combine" > needs to be automatic by simply
opening the combined workbook. >> Can anyone help?
Click to expand...
 
Back
Top