nitishbanka
New Member
- Joined
- Oct 17, 2018
- Messages
- 2
Hi, I have never used VBA before.
I am trying to automate a process for which I have created a simple example to get help.
I have a drop down list in Sheet1, Cell "A3" with values 1, 2 and 3.
The values in Sheet 2, Range B3:B5 forms accordingly.
The formulas used in Sheet2 are as follows:
B3: =IF(B4=5,"Base",IF(B4=10,"Scenario 1","Scenario 2"))
B4: =Sheet1!A3*5
B5: =Sheet1!A3*10
Now what I want is for Sheet1 drop down to run on a loop and the entire updated Sheet2 along with all formats to get copied in a new workbook.
I also wanted the name of the Sheet in the new workbook to be whatever the value is in Sheet2, Cell B3 (Base, Scenario 1 and Scenario 2).
This is a recurring activity with much larger data and I could really use the help of a VBA code.
I am trying to automate a process for which I have created a simple example to get help.
I have a drop down list in Sheet1, Cell "A3" with values 1, 2 and 3.
The values in Sheet 2, Range B3:B5 forms accordingly.
The formulas used in Sheet2 are as follows:
B3: =IF(B4=5,"Base",IF(B4=10,"Scenario 1","Scenario 2"))
B4: =Sheet1!A3*5
B5: =Sheet1!A3*10
Now what I want is for Sheet1 drop down to run on a loop and the entire updated Sheet2 along with all formats to get copied in a new workbook.
I also wanted the name of the Sheet in the new workbook to be whatever the value is in Sheet2, Cell B3 (Base, Scenario 1 and Scenario 2).
This is a recurring activity with much larger data and I could really use the help of a VBA code.