Forum Discussion
Writing updated info across several worksheets
Excel 2010: Am creating a worksheet for a coworker who enters equipment calibration dates and other details for all the calibrated equipment in our labs. He currently has one workbook with multiple ...
Hello,
I'm not sure I fully understand the data architecture, but to me it seems to be backwards, or the wrong way around.
A logical architecture would be to have a list of equipment in one sheet, with equipment ID, calibration date, and all the details pertaining to that equipment. Any changes to any piece of equipment will only ever be made in that one table.
Then on another sheets, if you need to refer to equipment, enter the equipment ID and use VLookup to pull the desire equipment data from the equipment table.
With this approach, any change made in the equipment table will immediately be reflected in the other sheets that reference the table data.
Does that make sense?