C
Christina
I just need someone to tell me if I'm crazy to even think about trying to
figure this out or if I should just try to get a "real" programmer to do it.
Here's the problem:
5 workbooks for 1 company (call the company P1).
300 companies (P1-P300, 1500 files total).
Files are consistantly named P1_this_data, P1_that_data then P2_this_data,
P2_that_data(output from STATA in xls or cvs format).
Created a "template" where data for P1 is pulled in.
Need to pull in data into the same template from P2, then P3, etc.
Right now I know I can open the "template", open the next company's files,
do a search and replace (P1 with P2, etc.) and then save as.
For this many files...that's a lot of manual work, no?
Would like to automate:
Opening the next set of files, doing the search and replace doing the save
as and renaming.
Sorry to be so ignorant...is this even possilbe?
Thanks for any help.
figure this out or if I should just try to get a "real" programmer to do it.
Here's the problem:
5 workbooks for 1 company (call the company P1).
300 companies (P1-P300, 1500 files total).
Files are consistantly named P1_this_data, P1_that_data then P2_this_data,
P2_that_data(output from STATA in xls or cvs format).
Created a "template" where data for P1 is pulled in.
Need to pull in data into the same template from P2, then P3, etc.
Right now I know I can open the "template", open the next company's files,
do a search and replace (P1 with P2, etc.) and then save as.
For this many files...that's a lot of manual work, no?
Would like to automate:
Opening the next set of files, doing the search and replace doing the save
as and renaming.
Sorry to be so ignorant...is this even possilbe?
Thanks for any help.