Hello,
I have a list of sheets that are all names. I have the list of names and i need to grab one bit from each sheet.
Is there anyway to do something like =B1!A6
Where B1 is the name of the sheet and A6 is the value i need from the sheet.
Hello,
I have a list of sheets that are all names. I have the list of names and i need to grab one bit from each sheet.
Is there anyway to do something like =B1!A6
Where B1 is the name of the sheet and A6 is the value i need from the sheet.
Perhaps
=Indirect("B1!A6") ...adapt for others accordingly
Life's a spreadsheet, Excel!
Say thanks, Click *
Try - =SUM(INDIRECT(B1&"!A6"))
Try this
Drag/Fill Down.Please Login or Register to view this content.
Note the apostrophes in the formula to allow for possible spaces in the sheet name.
See this workbook to see the results ... Is th1s what you mean?
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
I get a reference error when i do this for some reason? on both Ace and Barry's versions. Its copying the name of the worksheet from a cell and drawing a piece of data from said sheet but i get a ref error. If i swap the B1 for just the exact copy from the cell it seems to work.
Have you looked at the attachment in Post #4
If this doesn't do as you need, then post a sample workbook illustrating your expectations.
hi couldnt get it to work here is an example sheet
hereis an example
test book for people.xls
To get this to work the data you need to retrieve should be in the same position on each sheet, otherwise you will need to manually change each formula, in which case you might as well just use direct references.
See this workbook
Hey thnks for that its working and its all in the right place now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks