VBA Copying

[excelblackbelt]

Hello:

I have a question for the board around programming a simple copy macro.

I have a set of 25 worksheets that have one row of data in Row 2 about 20 columns wide. I want to compile those 25 worksheets into 1 master worksheet, so by the end of the macro I will have 25 entries copied from each worksheet out of row 2 through column 20 on one master worksheet.

I tried to use the standard Macrorecord button, but the Macro will not go to the next line when I open the next worksheet. I am not sure if I should put all the worksheets into one workbook and program a macro, or should I build a simple macro and open each worksheet individually and compile it that way on to one worksheet.

Thanks you guys!

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc793964.aspx