PhilipCCFE
New Member
I have workbook with several sheets, most of them are the same, bar the front one, which is a index of the others.
on that sheet I have the following data starting in Row 5:
ACT Action List =HYPERLINK("[index.xls]"&A5&"!A1","Click Here") =ACT!$B$4 =ACT!$C$4
APP Appointment =HYPERLINK("[index.xls]"&A6&"!A1","Click Here") =APP!$B$4 =APP!$C$4
I have one row for every worksheet, Worksheets take the same name as column A, as such I have worksheets called ACT, APP, etc. in the hyperlink equation (C) I can make reference to the name by calling call A5 (ACT) and A6 (APP), however I cant seem to work out how to reference them in the same way for the equations in D and E. As you can see these are hard coded;
Is there a way of using the value in A in these equations?
Thanks in Advance
on that sheet I have the following data starting in Row 5:
ACT Action List =HYPERLINK("[index.xls]"&A5&"!A1","Click Here") =ACT!$B$4 =ACT!$C$4
APP Appointment =HYPERLINK("[index.xls]"&A6&"!A1","Click Here") =APP!$B$4 =APP!$C$4
I have one row for every worksheet, Worksheets take the same name as column A, as such I have worksheets called ACT, APP, etc. in the hyperlink equation (C) I can make reference to the name by calling call A5 (ACT) and A6 (APP), however I cant seem to work out how to reference them in the same way for the equations in D and E. As you can see these are hard coded;
Is there a way of using the value in A in these equations?
Thanks in Advance