Here is my Data set.
ColA ColB
Scenario 1 Dogs
Scenario 2 Cats
Scenario 3 Pigs
Scenario 4 Sheep
Scenario 5 Goats
I want to use dropdown boxes to copy data in one scenario and paste in
another.
For example, if I want to copy and paste the values of Scenario 4 into
Scenario 2, I would like to be able to choose "Scencario 4" in DropDownBox1
and choose "Scenario 2" in DropDownBox2, then press a third button so that
the macro copies the values in Scenario 2 and pastes over as value in
Scenario 4.
This is tough for me because I many more scenarios and I do not know how to
apply relative references.
Copy Which Scenario Paste Over as Value to Which Scenario
DropDownBox1 DropDownBox2
Scenario 4 Scenario 2
After I run my macro, my data set should look like this:
ColA ColB
Scenario 1 Dogs
Scenario 2 Sheep
Scenario 3 Pigs
Scenario 4 Sheep
Scenario 5 Goats
As you can see, I have copied the data from Scenario 4 and pasted it in
Scenario 2.
Any suggestions? thanks very much for taking a look.
Steve
|
Similar Threads
