I have a spreadsheet with a summary page with a list of values that are links to various values on different sheets. Is there an excel formula or macro that I can use to list out which sheets the list of values are linked to. I want it to look like this
Column A Column B
3.45 Sheet 1
6.54 Sheet 2
1.23 Sheet 4
8.96 Sheet 9
4.54 Sheet 2
3.64 Sheet 3
3.33 Sheet 1
So, is there an Excel formula or Macro that can accomplish this?
While on the subject, is there anyway to make a macro/formula to look up a specific cell on a specific sheet. E.g,
Column A Column B
Sheet 1 D4
Is there a formula or macro that I can use so that the value in D4 on Sheet 1 in my workbook is put into Column C? How about a link to ‘Sheet 1’D4? That would be helpful.
THANKS!!
Column A Column B
3.45 Sheet 1
6.54 Sheet 2
1.23 Sheet 4
8.96 Sheet 9
4.54 Sheet 2
3.64 Sheet 3
3.33 Sheet 1
So, is there an Excel formula or Macro that can accomplish this?
While on the subject, is there anyway to make a macro/formula to look up a specific cell on a specific sheet. E.g,
Column A Column B
Sheet 1 D4
Is there a formula or macro that I can use so that the value in D4 on Sheet 1 in my workbook is put into Column C? How about a link to ‘Sheet 1’D4? That would be helpful.
THANKS!!