| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Macro to add new sheet and then fill formula in a totals sheet to refernce this sheet
Hi all,
I have created a macro to copy the template sheet and name the sheet based on the last sheet, so sheet names are 1,2,3 etc Sheets("TemplateSheet").Copy After:=Sheets(ActiveWorkbook.Sheets.Count) ActiveSheet.Previous.Select Range("C6").Copy ActiveSheet.Next.Select Range("c6").PasteSpecial xlPasteValues Range("c6").Value = Range("c6").Value + 1 ActiveSheet.Name = Format(Range("c6").Value, "#") This works fine but i also want to add to the macro to copy this formula =IF('1'!A$3="","",'1'!A$3) to the next row but to reference the new worksheet so it would be =IF('2'!A$3="","",'2'!A$3). Does anyone know how I can do this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for totals throughout sheet | Excel Discussion (Misc queries) | |||
| Refernce sheet names in if statement | Excel Programming | |||
| "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
| counting like items on one sheet, showing totals on another sheet | Excel Programming | |||
| Conditionally Fill a sheet row if cell value in another sheet 0 | Excel Worksheet Functions | |||
Threaded Mode
