Change Data Area as Drop Down Selection changes
I have attached a Sample Excel Sheet for more hands on help.
The Drop Down Selection Menu I am using is the one by Skill. I want the Data Area (cells surrounded by a border) to change as I change the Skill. I have added information on Sheet2 for information on what is to show when Skill is changed from Agility to Construction.
I know I can use the Vlookup Formula, however I am not sure how to do this when the data will encompass 3 columns (Name, Lvl and Base XP) and multiple columns.
Hello my friend.
I've made another sheet named "Data" and put all the information there
Then used this formula to B12:B33:
And this to C12:C33
Please Login or Register to view this content.
And this to D12:D33Please Login or Register to view this content.
Check the workbook sample: Sample.xlsxPlease Login or Register to view this content.
Where is teh data in that table coming from? The only real difference I see is what you have changed the contents to?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, what you gave me in the Edited Sample Document is exactly what I wanted. Thanks for the help.Originally Posted by Gatti
I am not exactly sure what you want to know. However, Gatti has already helped solve what I wanted.
Last edited by PixelPug; 02-04-2016 at 03:25 PM.
Glad to help!
He asked for the sheet I've created... To do INDEX/MATCH or even the OFFSET/MATCH, you should have a sheet with the data
If possible add reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks