Hi Experts,
I have a template which runs on macro. This template is used to prepare n save as file, where i have to manually enter Emp ID one by one and RUN the code to save file separately.
Is thier a possibilty to load Emp ID from Sheet 1 (Column A of Database TABLE) to Sheet 2 (Column A2 of Template) one by one and RUN the code automatically (probably Call Macro). In a month, this activity will be repeated for 500-600 Cases.
Note: Database is a Excel table named "tblDB". Template is not a excel table.
Regards,
Harish S
I have a template which runs on macro. This template is used to prepare n save as file, where i have to manually enter Emp ID one by one and RUN the code to save file separately.
Is thier a possibilty to load Emp ID from Sheet 1 (Column A of Database TABLE) to Sheet 2 (Column A2 of Template) one by one and RUN the code automatically (probably Call Macro). In a month, this activity will be repeated for 500-600 Cases.
Note: Database is a Excel table named "tblDB". Template is not a excel table.
Regards,
Harish S