98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Worksheet name from cell
Worksheet name from cell
Resolved · Urgent Priority · Version 2010
Tue 13 Nov 2012, 11:57Delegate Tashi said...
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?
Tue 13 Nov 2012, 14:22Trainer Paul said...
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
Fri 16 Nov 2012, 10:49Trainer Simon said...
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
Fri 16 Nov 2012, 10:50Trainer Simon said...
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.
Fri 23 Nov 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Showing all menu itemsIf you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items. |
