I am trying to create a macro that when a specific type of unit is choose from a drop down box in a cell it takes the name of that cell and looks up the sheet it correlates with and copy's and pastes the contents in a final spreadsheet.
There are four types of variables and each has at least three choices. So there are many combinations.
Example.
HVAC: Bard or Marvair
Generator: MTU, Katolight, Cummins
Environmentals: Yes,NO
Fuel: Diesel,Propane
Each of these chosen will go to a specific sheet and copy the data in that sheet and paste it to another sheet.
My command button will save the file sheet to the desktop of the computer using the sheet.
Any help on where to start would be so helpful. I have been trying different things but nothing is truly working in the way I want it.