Hello,

I NEED HELP

I need a macro that creates a new spreadsheet for a range of cells. Also i need the created spreadsheets to have data already in it. The data is a checklist. For every checklist I wanted 3 cells referenced from the original spreadsheet.

Is this even possible?

For example...

Name Date of Birth Customer Numer
Alex 8/1/1965 789123
Nick 4/2/1973 987421
Steve 6/30/1985 85632
Ted 1/5/1988 976218


I would like each spreadsheet to have the name in a certain cell... the date of birth on another cell... and the customer number in another cell.

On the new spreadsheets I would like a checklist of various things as if it were a questionairre.

1) Mothers Maiden Name
2) Favorite Animal
3) ____________
4) etc.

Can anyone help me with this please?