Macro to create different workbook for each row

[vijanand1279]

Hi ,

I am looking for a macro to create different workbook for each row available in Master tab. The new workbook should be created with the sample tab "Form Page" and should fill all the details from Master tab through vlookup.

I am attaching the file which contains Form_page sample, Master Tab and the country code tab.

Please help!

[vijanand1279]

Could someone help on this macro.

[tigeravatar]

vijanand1279,

This should get you started in the right direction:

Please Login or Register  to view this content.

[vijanand1279]

Hi Tiger,

The company code data is not changing on every file that is created. The company code details are added in the seperate tab.

Could you check and help.

Regard,
Vijay

[tigeravatar]

What I've provided is meant to be a starting point. You should be able to get the rest of it working from there. Once you've had a go and its not working right, post back with your progress and I'll take another look at it.

[vijanand1279]

I tried to pull the details based on country code with the help of vlookup. I am not able to do that.

[vijanand1279]

could you help me on this.