Weezer
09-30-2010, 08:38 AM
Hello everybody hope somebody here can help me with my macro problem.
I'm trying to build a macro that looks into a specific folder (example C:\Files)
and looks into every excel file that is in there & copy pastes data from specific worksheets in each workbook. The worksheets all have the same sheet names & I only need 14 sheets from a 20 sheet workbook.
Since the Worksheets have uniform names across all files. I can specify all the worksheets that I need the files from or put a range from "the specific worksheet name" to "a specific worksheet name". In these worksheets that I am copy pasting data into a fresh workbook I want only a Range of data from each worksheet. This is from Column A - Column K until Rows 474. So this is Row A6 to Row K6 (horizontal Range) all the way down to Row 474.
I need some serious help on this, I hope you guys can work your magic
Thanks!
I'm trying to build a macro that looks into a specific folder (example C:\Files)
and looks into every excel file that is in there & copy pastes data from specific worksheets in each workbook. The worksheets all have the same sheet names & I only need 14 sheets from a 20 sheet workbook.
Since the Worksheets have uniform names across all files. I can specify all the worksheets that I need the files from or put a range from "the specific worksheet name" to "a specific worksheet name". In these worksheets that I am copy pasting data into a fresh workbook I want only a Range of data from each worksheet. This is from Column A - Column K until Rows 474. So this is Row A6 to Row K6 (horizontal Range) all the way down to Row 474.
I need some serious help on this, I hope you guys can work your magic
Thanks!