Hi - is there a way to drag and drop hyperlinks to incrementally add to each cell?
Sheets 1 thru 10 have sets of questions i.e. Sheet 1 has rows 1:120 questions, Sheet 2 has 1:60, Sheet 3 has 1:42 etc.
Sheet 2 is a master sheet with all of the questions
Both sheets have A, B, C and D with specific data that never changes
Both sheets have E, F, G etc which contain responses to the questions and each of these columns has a unique header
The Admin who reviews Sheet 2 (the consolidated view) needs to validate responses and use Excel comments to post a message for the person who input the data if something needs to be corrected or updated i.e. change this rate or change this time zone etc.
The next person who comes in and sees the note needs to find the header that the note applies to as well as the question and click a link to take them to the appropriate sheet and row # of the question (the rows are not 1:1 on the master due to the fact that it's a consolidation of the other sheets).
I was thinking I could paste a hyperlink on the actual question which would bring the user at least to the proper sheet and row. They would then have to manually find the correct header and make the change.
Thoughts? Maybe there is a better way or something that could bring them directly to the header and cell to make the change? The master columns are not in the same order as the individual sheets because not all headers are on all sheets etc. If there isn't a better way, can someone help me determine how to create this hyperlink for each cell without having to do them individually?
Sheets 1 thru 10 have sets of questions i.e. Sheet 1 has rows 1:120 questions, Sheet 2 has 1:60, Sheet 3 has 1:42 etc.
Sheet 2 is a master sheet with all of the questions
Both sheets have A, B, C and D with specific data that never changes
Both sheets have E, F, G etc which contain responses to the questions and each of these columns has a unique header
The Admin who reviews Sheet 2 (the consolidated view) needs to validate responses and use Excel comments to post a message for the person who input the data if something needs to be corrected or updated i.e. change this rate or change this time zone etc.
The next person who comes in and sees the note needs to find the header that the note applies to as well as the question and click a link to take them to the appropriate sheet and row # of the question (the rows are not 1:1 on the master due to the fact that it's a consolidation of the other sheets).
I was thinking I could paste a hyperlink on the actual question which would bring the user at least to the proper sheet and row. They would then have to manually find the correct header and make the change.
Thoughts? Maybe there is a better way or something that could bring them directly to the header and cell to make the change? The master columns are not in the same order as the individual sheets because not all headers are on all sheets etc. If there isn't a better way, can someone help me determine how to create this hyperlink for each cell without having to do them individually?