Hi all, I am trying to change the values within a table based on the item selected in a combo box drop down. I have all the values listed on a different tab. Can anyone give me any guidance here?
Screen1.png
Options in the drop down
Screen2.png
And a sample of the items I would need to be in that table
Screen3.png
Is this the best way to go about this or should I be exploring other avenue?
Hello Dropsix,
It would be much better if you could attach a sample workbook, instead of images.
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.
Regards.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello! thanks for the quick reply! I have added the workbook to the thread now.
Will the previous screen shot I had included work as an example of what I am trying to accomplish?
Hello Dropsix,
Here is a simple uncomplicated way to go about your issue.
Code for sheet5;
Regards.
Please Login or Register to view this content.
You sir are amazing.
Thank you so much, that's absolutely perfect!
**Quick follow up question.
If I want to do the same thing but instead of the values being listed in a column, they are as follows:
legend.png
**** Please disregard. I managed to do it by repeating the lines of code. My issue now is the clear contents code isn't working. I will report back.
Last edited by Dropsix; 05-03-2018 at 10:25 AM.
Hi Dropsix,
I can try to change it for you, if I know what you have changed where?LOL
Once again, please attach a sample workbook.
Regards.
Last edited by Winon; 05-03-2018 at 10:27 AM. Reason: Spelling!
Hi Dropsix,
Just change this line
Regards.Please Login or Register to view this content.
Here is the workbook. I am trying to clear the cells like you coded in the previous instance.
Thank you Dropsix,
Here is your solution,
Enjoy.Please Login or Register to view this content.
I'd give you a hug if I could. Thanks Winon, I really appreciate it!
You are welcome, Dropsix.
Thank you for the Rep+, and for marking this Thread as "Solved"
You set a fine example!
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks