Hello,
This is my first post to this forum and I am definitely a novice when it comes to macros.
I have a spreadsheet (attached) that I would like to function a little smarter. Basically, there are 3 columns (Name, Reference to PQS, Reference to GPB) that represent procedure numbers and any references to other procedure numbers that are contained in Column A. (column A contains a list of all procedure numbers of both types - PQS and GPB)
What I would like to do is have the spreadsheet automatically update the references when a reference is created. For example, the second row shows C1000 (A2) referencing Q1221 (B2). I would then like the spreadsheet to update the Q1221 row (297) with the value of C1000 in column C. Basically, this is a cross reference. (I want the values to match for all values of A)
I hope this makes a little sense - please let me know if I need to clarify anything.
Bookmarks