|
I would use VBA for that in a heartbeat. That way if you ever change where the files are located, or change the layout of the worksheet, you could just edit the VBA function instead of having to completely redo all 60,000 entries on the sheet. The way I would recommend is making a button on the page called something like "load data", and then write a VBA function that runs when the button is clicked. and the function itself would just need to have a couple loops, as long as the files and folders have consistent namings. If you have zero programming experience it will probably take you a while, but it's probably going to take you a few days just to make the spreadsheet by hand anyway.
|
# ¿ Jan 5, 2011 01:29 |
|
|
# ¿ May 8, 2024 10:19 |