I have a workbook and in it are 2 sheets. The first sheet is a form and the second sheet is a list of user information (First Name, Last Name, Amount, Rate).
On sheet one I can fill in the first records information from sheet 2 with =+Sheet2!B2 for Last Name etc.
My question is I have 2k records on sheet 2 and I want to make a new excel document for each record on sheet 2.
For example I have record one is John Smith so I want to create an excel doc with his information, then record 2 is John Doe so create an excel doc with his information filled in.
Does this make sense? Is it possible?
On sheet one I can fill in the first records information from sheet 2 with =+Sheet2!B2 for Last Name etc.
My question is I have 2k records on sheet 2 and I want to make a new excel document for each record on sheet 2.
For example I have record one is John Smith so I want to create an excel doc with his information, then record 2 is John Doe so create an excel doc with his information filled in.
Does this make sense? Is it possible?