mruff
asked on
Copy a range from 1..n excel sheets to one destination sheet
Dear Experts,
I want to copy from 1..n excel sheets, all in the same folder named: WVS_2015_02_01.xls .. WVS_2015_02_28.xls from sheet 'MyData' the content of cell range E31-E51 to a destination excel result 'MyResult.xls', Sheet 'Consolidated':
range E31-E51 from WVS_2015_02_01.xls to MyResult.xls sheet Consolidated, cells A1-A24
range E31-E51 from WVS_2015_02_02.xls to MyResult.xls sheet Consolidated cells A25-A48 and so on until the content of that last WVS_2015_02_28.xls is copied to MyResult.xls sheet Consolidated
Or in other words, each range from E31-E51 from all WVS_2015_02_xy.xls being appended to MyResult.xls sheet Consolidated Column A1..A672
Many thanks for your support
Best Regards
Martin
Many thanks, Best Regards
Martin
I want to copy from 1..n excel sheets, all in the same folder named: WVS_2015_02_01.xls .. WVS_2015_02_28.xls from sheet 'MyData' the content of cell range E31-E51 to a destination excel result 'MyResult.xls', Sheet 'Consolidated':
range E31-E51 from WVS_2015_02_01.xls to MyResult.xls sheet Consolidated, cells A1-A24
range E31-E51 from WVS_2015_02_02.xls to MyResult.xls sheet Consolidated cells A25-A48 and so on until the content of that last WVS_2015_02_28.xls is copied to MyResult.xls sheet Consolidated
Or in other words, each range from E31-E51 from all WVS_2015_02_xy.xls being appended to MyResult.xls sheet Consolidated Column A1..A672
Many thanks for your support
Best Regards
Martin
Many thanks, Best Regards
Martin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect, works perfectly
Many thanks!
Best Regards
Martin