Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sheets("Output").Select
- Range("G7").Select
- ActiveCell.FormulaR1C1 = "All stores"
- Sheets("Stuurgroep").Select
- Range("N4:N18").Select
- Selection.Copy
- Range("C4").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Sheets("Output").Select
- Range("G7").Select
- ActiveCell.FormulaR1C1 = "Quartile 1"
- Sheets("Stuurgroep").Select
- Range("N4:N18").Select
- Selection.Copy
- Range("D4").Select
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Set ListScenarios = ActiveWorkbook.Sheets("RefTables").Range("B3:B11")
- For Each cell In ListScenarios
- Application.CutCopyMode = False
- Selection.Copy
- Sheets("Output").Select
- Range("G7").Select
- ActiveSheet.Paste
- Sheets("Stuurgroep").Select
- Range("N4:N18").Select
- Selection.Copy
- Call Paste
- Next cell
- Sub Paste()
- Set Destination = ActiveWorkbook.Sheets("Stuurgroep").Range("C4:K4")
- For Each cell In Destination
- Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
- :=False, Transpose:=False
- Next cell
Add Comment
Please, Sign In to add comment