Combine multiple worksheets into one - macro

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

Guest

I have a workbook with 12 worksheets. Each worksheet contains the same data (columns) but for different areas. I want to combine (copy and paste) all of these rows of data into one worksheet. I would like to write a macro to do this because i work with this data frequently. The problem is that the amount of data (rows) in each worksheet will vary every time so i can't give a specifc number of cells for the program to select and copy from each worksheet. Any ideas?
 
Hi
see your response in Excel.misc
P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany

ydarb said:
I have a workbook with 12 worksheets. Each worksheet contains the
Click to expand...
same data (columns) but for different areas. I want to combine (copy
and paste) all of these rows of data into one worksheet. I would like
to write a macro to do this because i work with this data frequently.
The problem is that the amount of data (rows) in each worksheet will
vary every time so i can't give a specifc number of cells for the
program to select and copy from each worksheet. Any ideas?
 
You must log in or register to reply here.

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 multiple worksheets in one Workbook into one big worksheet 6
Combining Multilple Worksheets Into One 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2013 Merge Data 2
MS Excel VBA Worksheets group tables in one table. 1
Need Macro... 8
Macro to combine worksheets 10
macro for combining worksheets 2

Back
Top