Hi all,
I found the script below (which works great), however, I would like to tweak it to:
1) Check against a value on worksheet "settings" in cell C3 (this is a dropdown where you can select from a range of values)
2) Then, depending on the value selected, special copy/paste from various worksheets and cells
I've attached an example spreadsheet. Hope this helps!Sub CopyPasteTCsTemplate() 'Use the Range.PasteSpecial method for other paste types 'Copy and PasteSpecial a between worksheets Worksheets("Template1").Range("C3").Copy Worksheets("Template").Range("C6").PasteSpecial Paste:=xlPasteFormulas 'Disable marching ants around copied range Application.CutCopyMode = False End Sub
In total, there will be approx. 100 cells to copy over (example only holds 1) for each value you can select. So the script should accommodate for that. E.g. if value Template 1 is selected, copy 100 cells from worksheet Template1. If Template 2 is selected, copy 100 cells from worksheet Template2.
The copy/paste should be special (as in the existing script) so can't work with formulas here, I'm afraid.
Not quite sure where to start with this so would appreciate any help!
Many thanks!
Bookmarks