Posted by Ron Binder on January 24, 2002 8:03 AM
I have several Excel spreadsheets that I need to consolidate into one spreadsheet each week. The individual spreadsheets vary in length depending on how much information the user's input each week. Today, I select the range to copy from each individual spreadsheet and copy it to the consolidated spreadsheet. I would like to run a Macro that automatically selects the 'used' range (rows 3 to the last used row) & columns (A to M) and excludes the header rows (1 & 2). Does anyone have a Macro or VB code that can do this? Would appreciate any suggestions you might have. Many thanks.