Forum Discussion
Writing updated info across several worksheets
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?
I will post a scrubbed version of the workbook and my worksheet as it now stands shortly, along with a brief narrative. I don't think I explained it adequately in the original post.
Thanks,
-Ron A.