S
Sophs
Hi all,
I have created a macro to copy the template sheet and name the shee
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 formul
=IF('1'!A$3="","",'1'!A$3) to the next row but to reference the ne
worksheet so it would be =IF('2'!A$3="","",'2'!A$3). Does anyone kno
how I can do this?
Thank
I have created a macro to copy the template sheet and name the shee
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 formul
=IF('1'!A$3="","",'1'!A$3) to the next row but to reference the ne
worksheet so it would be =IF('2'!A$3="","",'2'!A$3). Does anyone kno
how I can do this?
Thank