Macro to Paste Scenario Data

Hi,
I'm trying to get a macro to grab a range of cells from one worksheet and paste them into another one. I want the macro to choose between 4 different sets of data based on a single cell value (1,2,3, or 4). I have previously used =choose to do this however my model is going to run very complex sensitivty calcs and I don't want to waste computer grunt on 500 cells having =choose statements.

I have attached an example of my sheets, and I want the data to paste into the orange cells when I click the button.

I don't want to use excel's scenario manager, I want to do it using a macro, or some other clever way that anyone can think of.

I am quite inexperienced with VBA in the multi worksheet & global variable setup type stuff.

Any advice greatly appreciated, Cheers!

Can you =choose a named range?
Does this use less grunt than having an =choose in 500 different cells?

hi, code for the button "Paste Scenario"

Please Login or Register  to view this content.