macro to extract info and paste to a new sheet

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

Guest

I need to write a macro for the following:
I have a workbook that will have anywhere from 1 to 30 sheets that will have
data in them. Each sheet will have a variable number of rows but if there is
data, it will be in columns A:S. The first row of data will be 12. Not all
cells will contain data however column C will always have a value (if there
is data in other cells for that row).
I want to be able to automate copying the data from each of these numbered
sheets into a new sheet called "Master".

Any help is appreciated.
Thanks,
Brad K
 
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

Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Compile Data from Different Sheets 2
Find Specific Rows in Range and Create New Tab 18
Macro for checking data in a cell against another cell andcopying/pasting data 8
Macro for Consolidation of Info from Different Tabs 1
Create if partial match then copy and paste data from one cell to another 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Mid column sum formulas with varied ranges to sum 17

Back
Top