Macros in XL 2010 for Auto Generate Form

Hello Guys,

This is my first time on this website.

I am always having a big list of providers which I use to make forms which is becoming very difficult as it is increase the business. I am looking for VBA Macros where I can generate forms based on my list on other worksheet.

VBA should fill all the information on Worksheet (Cont. Signoff Form) which is available on list on worksheet (Signoff List).

If Column D values in worksheet (Signoff List) match with Regions on Worksheet (Cont. Signoff Form) row number 11 & 13. It should color the box with black.

Same exercise will be done with classification which is row number 18 & 20. If Column F values in worksheet (Signoff List) match with Classification on Worksheet (Cont. Signoff Form) row number 18 & 20. It should color the box with black.

Copy of sample is attached to understand what is requesting from experts.

Hi Abdur_rahman,
no macros, only the VlookUp and conditional formatting. Try to choose a different value from the list of Provider names.

Thanks for your response. But the list keep on changing this is only a sample. This is the reason i prefer VBA macros which will generate each and every form separately with number like 1, 2, 3, etc...

If you can help me in this issue i will really thankful to you.

Can anyone help me please.

Thanks nilem this solution is more than enough for me.