Hi community,
I have around 30 sheets ( sheet names are 1 to 31 ) on workbook, I need to use formula like ='1'!C8 , but when person chooses From Data Validation for example 2 May link must be ='2'!C8
if 3 may ='3'!C8 etc. Can anybody help me about this?
Try this.
Assuming your drop down is in Cell A1 (Change as required)
=INDIRECT("'"&A1&"'!C8")
Cheers!
Deep Dave
Thanks mate, is there possibility to make C8 fill automatically? c8,c9,c10 etc
Yes it can be done. But you will have to give me some more info.
Best is to attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).
I can attach file, but only think I need right now , is to fill formula when I double click on it, my list starts from c8 to c36
All I want when to double click your formula =INDIRECT("'"&A1&"'!C8") to fill cells like =INDIRECT("'"&A1&"'!C9") =INDIRECT("'"&A1&"'!C10") etc
Change the formula to this:
=INDIRECT("'"&$A$1&"'!C"&ROWS($1:8))
then this will increment the rows when you copy it down.
Hope this helps.
Pete
Thank you very much Pete
Glad to help - thanks for the rep.
If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks