Hello, experts! I could really use your help!
I consider myself an excel expert (can do pivot tables, formulas, vlookups in my sleep) but have never had to use macros or VBA and desperately have a situation where I need to now.
I have a master sheet of data with LOTS of rows where column A is someone's name: (ex.)
Name date dollars
Jack 4/1/90 $5
Jill 2/1/79 $1
John 3/6/00 $10
I have a second sheet which is a template of a form that I need to create for every name on the list: (ex.)
Form For
Jack
Date: 4/1/90
Dollars: $5
In the template, I have the name coming into the spreadsheet with a formula that says ='Master sheet'!A:A
The rest of the data in the template uses vlookups keying off of that name.
SO, what kind of loop statement could I create in VBA that would copy the template worksheet, and loop through each row of the master spreadsheet to create a worksheet for each person?
THANK YOU THANK YOU THANK YOU!!!!
I consider myself an excel expert (can do pivot tables, formulas, vlookups in my sleep) but have never had to use macros or VBA and desperately have a situation where I need to now.
I have a master sheet of data with LOTS of rows where column A is someone's name: (ex.)
Name date dollars
Jack 4/1/90 $5
Jill 2/1/79 $1
John 3/6/00 $10
I have a second sheet which is a template of a form that I need to create for every name on the list: (ex.)
Form For
Jack
Date: 4/1/90
Dollars: $5
In the template, I have the name coming into the spreadsheet with a formula that says ='Master sheet'!A:A
The rest of the data in the template uses vlookups keying off of that name.
SO, what kind of loop statement could I create in VBA that would copy the template worksheet, and loop through each row of the master spreadsheet to create a worksheet for each person?
THANK YOU THANK YOU THANK YOU!!!!
