Hi, I'm new to the forum and I'm pretty much completely new to VBA as well. I originally signed up to ask for help with some errors that I was getting with the below mentioned drop down macro, but I finally solved that issue after doing some more searching around on the internet. Now, I have the macro working as well as I can get it to, but not like I originally would have liked, so I thought I might be able to see if anyone could help me improve it to get it closer to what I originally wanted.
I just set up a worksheet with a drop down menu that copies and pastes a list of equipment into the primary sheet depending on what you select in the drop down. When you open the sheet the drop down cell says "Choose Job" then you use that cell to select the list you want to load. All of that works exactly like it should, except that I was hoping there was a way to have the list change every time you made a different selection. I'll paste the code so I can better explain what I'm talking about.


Please Login or Register  to view this content.
As you can see I use separate macros to copy and paste the the different lists. I'm sure this isn't really necessary, but it made it easier for me to figure out how to make this work. The beginning If function is what I had been missing for a day of trying to figure out where I was going wrong, and it turned out the be the most simple and obvious solution. I don't know of a better way to make it read when a list is loaded other than to type "act" into one of the cells that are in a header and then color that text the same color as the header to make it invisible. I'm sure there's a better way, but I'm not aware of it.

So with the current Macro I can load and list I want to include by making separate macros for each one. However, once the list is on the primary sheet, I have to have a macro button that sets the drop down cell back to "Choose One" and clears the list out of the primary sheet before I can load a different one. If I were to accidentally select the wrong list and needed a different one for example. I can't figure out a way to make that happen because once a list is loaded it disables the macro by inserting the "act" into the A11 cell. I know there are a lot of people out there that know all about VBA so I thought it might not hurt to ask if anyone could help me build on what I have. Thank you so much if you take the time to help. I'm new, but I'm a pretty quick learner.

The Macro that I use to transfer the different lists:

Please Login or Register  to view this content.