Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|