New spreadsheet for each cell (list) with references

[tanyataco]

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?

[tlafferty]

I need a bit more information first:
1) Will the new sheet be in the original workbook or will it be in a new workbook?
2) Should the information "referrenced" in the original workbook be linked or just copied over?

[royUK]

I doubt very much if you need separate sheets or a macro. Attach an example workbook

[tanyataco]

tlefferty:

Thank you for responding. The new sheet can be in the same workbook. AND the information (name, bday, and customer num) can be copied over.