Is this possible?
If i create say 500 spreadsheets in excel with information in specific
places. Is it possible to run something to pull all this info and do a summary of the information? I am guessing excel will struggle with the amount of data so maybe MS Access would be a better choice? if so would it be possible in access? and how difficult is this? |
Is this possible?
Hi Ernest
Try this See http://www.rondebruin.nl/copy3.htm Or create formulas http://www.rondebruin.nl/summary2.htm Note: you only have 65536 rows -- Regards Ron de Bruin http://www.rondebruin.nl "Ernest Lai" wrote in message ... If i create say 500 spreadsheets in excel with information in specific places. Is it possible to run something to pull all this info and do a summary of the information? I am guessing excel will struggle with the amount of data so maybe MS Access would be a better choice? if so would it be possible in access? and how difficult is this? |
All times are GMT +1. The time now is 06:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com