I have a master spreadsheet with 45 rows of data, with each row containing
information about a single employee. Each employee will have a separate
worksheet formatted as a form, and I will pull information from the master
spreadsheet via cell references (there are 25 cell references from the master
spreadsheet per employee form). Once I have the first employee form created,
is there a way to incrementally change my cell reference by 1 each time I
create a new form (spreadsheet)?
--
Tia, Training Manager

I'd suggest making sure the first column for each employee row is a unique
identifier (EmployeeID or the like). In each your basic 'form' worksheet,
use a MATCH() function to determine which row of data you need, keying on the
unique identifier. All of your formulas would then reference the row and
column numbers to pull in the appropriate data.

As a matter of fact, simply by using this procedure, you would need nothing
more than your 'master' sheet and a single 'form' where the form is updated
simply by changing the unique identifier.

Finally, although you can use Excel for this type of effort, it really is
better done in a database.


"Tia" wrote:

I have a master spreadsheet with 45 rows of data, with each row containing
information about a single employee. Each employee will have a separate
worksheet formatted as a form, and I will pull information from the master
spreadsheet via cell references (there are 25 cell references from the master
spreadsheet per employee form). Once I have the first employee form created,
is there a way to incrementally change my cell reference by 1 each time I
create a new form (spreadsheet)?
--
Tia, Training Manager