I have a rather large spreadsheet that is updated with various "comments". Could be 10, could be 100... Would like to ADD a second TAB that will show some of the DATA POINTS and the COMMENT that was entered.
For example: Col A is the name of the configuration item, column C is the location of the configuration item, and column G is the person on-call. Anywhere in the sheet (up to column M) can/will contain a COMMENT.
Would like to capture columns A, C, G, and the comment on the second sheet. Definitely will be a formula of some kind on the secondary sheet, just not sure where or how to gather the info. Any help would be MOST appreciated...
For example: Col A is the name of the configuration item, column C is the location of the configuration item, and column G is the person on-call. Anywhere in the sheet (up to column M) can/will contain a COMMENT.
Would like to capture columns A, C, G, and the comment on the second sheet. Definitely will be a formula of some kind on the secondary sheet, just not sure where or how to gather the info. Any help would be MOST appreciated...