Help: reference info from master spreadsheet to individual forms


G

Guest

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)?
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top