Consolidate many sheets into one sheet with multiple rows
You can try this macro Todd
http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "ToddEZ" wrote in message ... I am trying to consolidate various cell values from an unspecified number of sheets into "sheet 1" with the data for each sheet seperated by row. For Example: For Sheets 2-?, I need cells A1, B13, and the last populated cell from column C. I would like the data to display in sheet1!(A2:C2) for the cells pulled from sheet 2, sheet1!(A3:C3) for the cells pulled from sheet 3...and so on. Anyone know the best way to accomplish this? |
All times are GMT +1. The time now is 04:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com