ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining Multiple Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/144825-combining-multiple-worksheets.html)

Sarah

Combining Multiple Worksheets
 
Is there anyway to combine worksheets (which have identicle column headings)
into one worksheet? Also, what if these worksheets are in different
workbooks?

Barb Reinhardt

Combining Multiple Worksheets
 
You should be able to find something here that works.

http://www.rondebruin.nl/tips.htm

HTH,
Barb Reinhardt

"Sarah" wrote:

Is there anyway to combine worksheets (which have identicle column headings)
into one worksheet? Also, what if these worksheets are in different
workbooks?


Bob I

Combining Multiple Worksheets
 
Copy, Paste.

Sarah wrote:

Is there anyway to combine worksheets (which have identicle column headings)
into one worksheet? Also, what if these worksheets are in different
workbooks?



Sarah

Combining Multiple Worksheets
 
Is there anyway to do so without using VBE or macros? I am currently trying
to teach myself this fuction of excel and I think these directions are a bit
over my head.

"Barb Reinhardt" wrote:

You should be able to find something here that works.

http://www.rondebruin.nl/tips.htm

HTH,
Barb Reinhardt

"Sarah" wrote:

Is there anyway to combine worksheets (which have identicle column headings)
into one worksheet? Also, what if these worksheets are in different
workbooks?


Roger Govier

Combining Multiple Worksheets
 
Hi Sarah

If you don't want the VBA route, then as Bob posted use Copy and Paste.
With your Source workbook open and the destination workbook open.
Choose which sheet is to your Destination Sheet.
Mark the range of data from any other sheet (presumably from row 2
onward if you have a header in Row 1, then right click Copy
Move to your detonation sheet, place the cursor in the first column
below the last row of data, right click and Paste.
Repeat the procedure till you have completed for all sheets required

If you just want to move sheet from one workbook to another, then Right
click on the sheet TabMove or CopySelect Destination Workbook from the
dropdown and the position within that Workbook where you want the data
to go.

--
Regards

Roger Govier


"Sarah" wrote in message
...
Is there anyway to do so without using VBE or macros? I am currently
trying
to teach myself this fuction of excel and I think these directions are
a bit
over my head.

"Barb Reinhardt" wrote:

You should be able to find something here that works.

http://www.rondebruin.nl/tips.htm

HTH,
Barb Reinhardt

"Sarah" wrote:

Is there anyway to combine worksheets (which have identicle column
headings)
into one worksheet? Also, what if these worksheets are in
different
workbooks?





All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com