Here is a doozy!
I am being asked if there is a method to automatically combine 200 spreadhseets. They are all the same spreadsheet. They are copies sent out to collect data. The spreadsheets come back weekly. They can be named whatever I want. Is there a way to build a macro or software I can buy or services I can buy to build something that will with as few key strokes as possible combine all of these spreadsheets into one? They all need to be on the same page so that I can save them as a CSV file. Thats my ultimate goal is to get all of them into one CSV file so that I can import them into a SQL server database.
Thanks
I am being asked if there is a method to automatically combine 200 spreadhseets. They are all the same spreadsheet. They are copies sent out to collect data. The spreadsheets come back weekly. They can be named whatever I want. Is there a way to build a macro or software I can buy or services I can buy to build something that will with as few key strokes as possible combine all of these spreadsheets into one? They all need to be on the same page so that I can save them as a CSV file. Thats my ultimate goal is to get all of them into one CSV file so that I can import them into a SQL server database.
Thanks