Tashi has attended:
No courses
Worksheet name from cell
We have a table with dates consisting of mnth-yr in row name, down the left side.
We are trying to populate the table by using the row title (cell value) to pull numbers from another workbook. The month in Column A equals the tab names of the different sheets in the different work book.
e.g.
March 11 in cell A1 in workbook 1 . we want to get data from a sheet with the name March 11 in workbook 2.
However the tab name seems to be in text and does not seem to be recognised as a cell value.
Does it involve using the indirect function? and if so how?
How do we get the cell location to put into various vlookup formulas from column A instead of writing the location in?
RE: Worksheet name from cell
Hi Tashi,
Can you please clarify a couple of things?
When you say you want "to get data", do you mean you want to link the cells in some way? if you have march 11 in cell A1 where do you want to put the data you are looking for? A2 etc...?
The last thing you asked sounds like you want a combo box with a list of look ups opposed to typing in a value, is that correct?
thanks
Paul
RE: Worksheet name from cell
Hi Tashi,
Can you please let me know whether you have managed to resolve this problem as I am trying to clear up the active questions on our support forum.
If you can, please try and respond to this question within five days, otherwise it will automatically be marked as completed.
Thank you for your assistance.
Regards
Simon
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
