Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code on a template sheet
I have a template page in my workbook which users can copy & rename to record
cost estimates Part of the sheet compares the previous estimate with the lastest I want an update button which copies columns F-H & pastes the values in columns C-E. This code needs to be in the 'template' sheet, but obviously needs to work whenever the sheet is copied & renamed I have a macro which works on a global scale, but how do I make it sheet specific for sheets that haven't been created yet? Sub copylast() Sheets("Shell and Core").Select Range("f6:h50").Select Selection.Copy Range("c6").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Range("f6").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge data in Excel - one sheet to template sheet? | Excel Worksheet Functions | |||
adding code from a template | Excel Programming | |||
template code in one place | Excel Programming | |||
Opening a template.xls using VBA code. | Excel Programming | |||
Opening a template .xls with VBA code | Excel Programming |