Hi all,
Is there a quick way to change/develop a macro to change the hardcoded cell references A, B, B1 (for example to A -> B, B -> C, B1 -> C1)? The reason is these hardcoded cell references are pretty much across a lot of modules and i need to develop a quick way to change the hardcoded references.
'C&P sum of column into the identified column
ActiveCell.EntireColumn.Copy
Sheets("Tab One").Columns("A:A").Select
ActiveSheet.Paste
Application.CutCopyMode = False
'Index match codes for the identified tab
Sheets("Tab One").Cells(1, "B").Formula = "=INDEX('Tab Two'!F:F,MATCH('Tab1'!A1,'Tab Two'!E:E,0))"
Sheets("Tab One").Range("B1:B" & lastrow1).FillDown
Is there a quick way to change/develop a macro to change the hardcoded cell references A, B, B1 (for example to A -> B, B -> C, B1 -> C1)? The reason is these hardcoded cell references are pretty much across a lot of modules and i need to develop a quick way to change the hardcoded references.
'C&P sum of column into the identified column
ActiveCell.EntireColumn.Copy
Sheets("Tab One").Columns("A:A").Select
ActiveSheet.Paste
Application.CutCopyMode = False
'Index match codes for the identified tab
Sheets("Tab One").Cells(1, "B").Formula = "=INDEX('Tab Two'!F:F,MATCH('Tab1'!A1,'Tab Two'!E:E,0))"
Sheets("Tab One").Range("B1:B" & lastrow1).FillDown