Change Cell Value One by One and Call Macro Automatically

[harishs]

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