Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to have 125 copies of a work sheet:
Sub Macro1() For i = 1 To 125 Sheets("MD").Copy Befo=Sheets(1) ActiveSheet.Name = "MD" & i Next End Sub However, within each worksheet, certain cells must make reference to a cell on another worksheet which for example is A2 from MASTER DATA sheet on sheet MD1, A3 from MASTER DATA sheet on sheet MD2, etc. The formula below simply copies the same data for each new sheet. Range("A4:B4").Select ActiveCell.FormulaR1C1 = "='MASTER DATA'!R[4]C" End Sub Any ideas as to how I can incorporate the sheet copy function and the incremental cell reference formula are much appreciated! :) Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create Macro to Increase Cell Reference | Excel Discussion (Misc queries) | |||
How to Create Macro to Increase Cell Value to one and Print Worksheet | Excel Worksheet Functions | |||
How do I write a macro to increase the value of any cell by 1? | Excel Programming | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
Macro to increase cell number by 1 at a time | Excel Programming |