Wanna make some dough? I have appx 2500 spreadsheets that I need to pull some data from into one fancy spreadsheet (database?). Sound simple? It isn't. This data needs to be sorted and summed and the sort/sum isn't straightforward. In fact, I can't figure out a way to make it work in a macro. Also, each spreadsheet has it's date in it's file name, but not in the actual file and keeping the date with the data is critical.
I have done it by hand and it takes me about 90 seconds to do each spreadsheet. So, manually it would take 60+ hours to do. PM me and tell me that there's a way to do this fast and guarantee the accuracy of the sort and calcs and we'll talk $.
I have done it by hand and it takes me about 90 seconds to do each spreadsheet. So, manually it would take 60+ hours to do. PM me and tell me that there's a way to do this fast and guarantee the accuracy of the sort and calcs and we'll talk $.