riles21
01-19-2007, 11:44 PM
I have workbooks that all have the same exact layout. Is there anyway to run a macro that will:
1) Prompt user to select workbooks within a folder (not a specific one - I believe this is the GetOpenFilename command)
2) Copy a range of values (for example A4 and C5:C28) from each worksheet within each workbook.
3) Paste the copied range (A4 from first workbook would go in B1 with the range C5:C28 from first workbook would go in B2:B25). Information from second worksheet/workbook would go in C1 AND C2:C25. Information from third worksheet/workbook would go in D1 AND D2:D25, etc etc until there are no more workbooks or worksheets.
Essentially this is a summary worksheet...
1) Prompt user to select workbooks within a folder (not a specific one - I believe this is the GetOpenFilename command)
2) Copy a range of values (for example A4 and C5:C28) from each worksheet within each workbook.
3) Paste the copied range (A4 from first workbook would go in B1 with the range C5:C28 from first workbook would go in B2:B25). Information from second worksheet/workbook would go in C1 AND C2:C25. Information from third worksheet/workbook would go in D1 AND D2:D25, etc etc until there are no more workbooks or worksheets.
Essentially this is a summary worksheet...