G
Guest
I have a formula with references to other worksheets. Is there a way to have
the formula read the sheet name from another cell?
Worksheet(1)
Sheet name Formula I have now: Formula I hope for:
Bob =Bob!c3 =sheetname(This sheet A1)!c3
Jill =Jill!c3 =sheetname(This sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet A3)!c3
Thanks,
Todd
the formula read the sheet name from another cell?
Worksheet(1)
Sheet name Formula I have now: Formula I hope for:
Bob =Bob!c3 =sheetname(This sheet A1)!c3
Jill =Jill!c3 =sheetname(This sheet
A2)!c3
Peter =Peter!c3 =sheetname(This sheet A3)!c3
Thanks,
Todd