Static output from a table with three scenarios

[KS85]

Hi,


On Sheet 1 - I have data in a tabular form and have 3 drop downs to select the scenarios. Based on each scenario selected the table gets populated (9rows and 5 columns)


On Sheet 2 - i am trying to replicate the table from sheet 1 for each of the scenarios. the issue is that i want to be able to change scenarios in Sheet 1 but keep the output in sheet 2 static (and have the option of refreshing it when i want)


any ideas on how to go about it?


thanks!!

 

[Luke M]

Use a macro that does a Copy, Paste Values from Sheet 1 to Sheet 2? Then you coudl assign the macro to a button of some sort and click that when you want to refresh the data.

[pre]

Sub CopyPaste()
Worksheets("Source Sheet").Cells.Copy
Worksheets("Other Sheet").Cells.PasteSpecial (xlPasteValues)
End Sub

[/pre]

 

[KS85]

Thanks Luke! this was really helpful


Would you be able to help me with the macro - where am trying to say

If a cell in Sheet 2 = ABC then copy paste (as described earlier)


Thanks Again!