HI,
I have a workbook which is populated by a query. Due to the nature of the data, both the width and the length of the data changes. I have created an "Admin" work sheet in which the column headers of Sheet1 are searched to identify the one I need in this particular case as well as finding the last row of populated data in a column. So in my admin page I now, for example, have a cell that contains "AG" and a cell that contains "813". What I now want to do is in another worksheet, refer to the value in this cell I thought I could do it along the lines of "=Sheet1!INDIRECT(B5 & B6)" where B5 is the cell that contains the value "AG" and B6 is the one that contains the value "815 in my Admin worksheet. I get an error. I have tried different parenthesis combinations but again, no joy. I also tried creating a Named Range using =INDIRECT(Admin!b5&815). When I run this on the admin page it goes to the correct cell reference but in the Admin worksheet.
So the question is how do I uses a calculated cell reference contained in a cell in a subsequent formula?
I have a workbook which is populated by a query. Due to the nature of the data, both the width and the length of the data changes. I have created an "Admin" work sheet in which the column headers of Sheet1 are searched to identify the one I need in this particular case as well as finding the last row of populated data in a column. So in my admin page I now, for example, have a cell that contains "AG" and a cell that contains "813". What I now want to do is in another worksheet, refer to the value in this cell I thought I could do it along the lines of "=Sheet1!INDIRECT(B5 & B6)" where B5 is the cell that contains the value "AG" and B6 is the one that contains the value "815 in my Admin worksheet. I get an error. I have tried different parenthesis combinations but again, no joy. I also tried creating a Named Range using =INDIRECT(Admin!b5&815). When I run this on the admin page it goes to the correct cell reference but in the Admin worksheet.
So the question is how do I uses a calculated cell reference contained in a cell in a subsequent formula?
