Combining Multiple Worksheets

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

Guest

Is there anyway to combine worksheets (which have identicle column headings)
into one worksheet? Also, what if these worksheets are in different
workbooks?
 
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.
 
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 Tab>Move or Copy>Select Destination Workbook from the
dropdown and the position within that Workbook where you want the data
to go.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
how do i combine excel worksheets 1
How do I combine data (not consolidate) from separate tabs to one? 2
Combing Info. from multiple worksheets 2
Collate Worksheets into single workbook 3
Combine 3 of 6 worksheets 1
Merge data from different worksheets 3

Back
Top