A fellow Excel user sends out a template monthly to various organizations. Each org sends back the excel file with fields filled in with their data. She wants to know how to have all the org's data add to each other in a master file.
A fellow Excel user sends out a template monthly to various organizations. Each org sends back the excel file with fields filled in with their data. She wants to know how to have all the org's data add to each other in a master file.
Hi Dave and welcome to the forum,
The easy answer is that s/he needs to open the file and copy into the windows clipboard and paste the datat at the bottom of the master file data.
If you want to automate this process then a VBA Macro can be written to assist in this process. It all depends on how many "org" files are being merged. If it was more than 20 a month and done each month, then a Macro may make sense. If it were less than 5 per month, I'd opt for a short training session.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks