Solution to Problem: Data Validation Drop Down List Macro

Data Validation Drop Down List Macro

I have the following list of items (apple, peach, plum, banana, etc).
I created a "Data Validation" "List" to select about 15 different items to display data for each item.
How do I create a macro that will select "apple" and then move the tab into another
workbook called "book1".
Then select "Peach" and then move the tab to the same workbook as "Apple" in "book1".
So on and so forth for each item in the list.
 
Goal:
My data is retrieve based on what is selected from the drop down.
I need a macro that will select each item in my list and then move the tab to another workbook.
Then select the next item in my list then move it to the same workbook as the previous.
The
final result would be to have a tab for each selection.
Any help is much appreciated....
 
Thanks

Keys to the Problem Data Validation Drop Down List Macro

Download SmartPCFixer to Fix It (Free)

Nekia,
I believe after you sent me the actual workbook that we have the solution.  You could confirm that by marking this posting as Answer.
For others reading this - the problems we had along the way were caused by some things not revealed during the discussion.  Most notable were numerous other sheets in the workbook, many of which were hidden and in some cases interfering with the codes function. 
Another problem that wasn't discovered until the actual list used for data validation was exposed to me: at least one of the entries in it was over the 31 character limit allowed for worksheet names.  That required additional code to ensure that when we tried
to use an entry from the list to rename a worksheet that it was going to work; additional code was also put in place to ensure that none of those entries retained any invalid characters for a worksheet name. 
It all works now at my end on the actual workbook.  Case closed ....
book'm Danno!

Tweak IE Options
  • Open Internet Explorer.
  • Go to "Tools > Internet Options > Advanced Tab".
  • Uncheck "Enable third-party browser extensions".
  • Click "Apply".
  • Reboot your computer.

Another Safe way to Repair the Problem: Data Validation Drop Down List Macro:

How to Fix Data Validation Drop Down List Macro with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.


Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: How to Fix Problem - Desktop icons open with Adobe reader?,Troubleshoot:deleting unsent message,Solution to Error: Deleting extra pages in a worksheet,Troubleshooting:Date and time wrongly changing automatically ones a day that goes to 2002 with time? Error,Troubleshoot:Desktop moves to cover my work while I'm typing.
Comments