macro to extract info and paste to a new sheet
 

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

macro to extract info and paste to a new sheet
 

Try this Brad
http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Brad K." wrote in message ...
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