Help: reference info from master spreadsheet to individual forms
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 |
Help: reference info from master spreadsheet to individual forms
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 |
All times are GMT +1. The time now is 10:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com