I need some guidance on creating my doc.
As a short introduction:
I have 2 sheets: Sheet1 and Sheet2.
On sheet 1 cell 2B I have a dorpdown List with values from Sheet2 A2:A5. The options in the dropdown list are called 1,2,3,4.
On Sheet 1 I have a button that has a macro assigned to copy cells from Sheet 2 underneath it.
For now I have assigned macro 1 for this button.
I have 4 macros created for each Cell value on cell 2B (1,2,3,4) in order to copy the certain Cells from Sheet2.
How do I make the button to perform macro1 if cell b2 has value 1, macro 2 if cell b2 has value 2, macro 3 if cell b2 has value 3 and macro 4 if cell B2 has value 4?
Below is the code with all the 4 macros:
I have also attached the document.
Thank you!hideunhide cells project.xlsm