Hello everyone,
I am having the below requirement for developing a macro.
1) I have a standard template that will be circulated to ~100 users. Will be receiving the filled template from users every week.
2) I will keep collate all the received files in a folder. (Lets say folder name = Week-1 Data)
3) I have a Master record excel which has most of the fields present in standard template. (eg: Field project name will be present in template as well as master).
4) I need a macro to perform the following actions:
a) A collate button : When i click this it should open a file select window and i should be able to select multiple excel files, which will be the filled template.
b) In filled template two cells have client name and project name. The macro should copy the sheet "Master Template", rename it (Name = concatenate (client name,project name in filled template)).
c) Copy the respective data from filled template to Master record.
d) If data already present in the fields it should fill the next week data.
This loop to continue for all selected files.
e) Next week another update will come and the macro should find the respective sheet and fill in the data.
Request your assistance in this. Let me know if there are any questions.
Thanks in advance,
Deepak
I am having the below requirement for developing a macro.
1) I have a standard template that will be circulated to ~100 users. Will be receiving the filled template from users every week.
2) I will keep collate all the received files in a folder. (Lets say folder name = Week-1 Data)
3) I have a Master record excel which has most of the fields present in standard template. (eg: Field project name will be present in template as well as master).
4) I need a macro to perform the following actions:
a) A collate button : When i click this it should open a file select window and i should be able to select multiple excel files, which will be the filled template.
b) In filled template two cells have client name and project name. The macro should copy the sheet "Master Template", rename it (Name = concatenate (client name,project name in filled template)).
c) Copy the respective data from filled template to Master record.
d) If data already present in the fields it should fill the next week data.
This loop to continue for all selected files.
e) Next week another update will come and the macro should find the respective sheet and fill in the data.
Request your assistance in this. Let me know if there are any questions.
Thanks in advance,
Deepak
