This is a continuation from a previous thread but best belongs in its own domain. I have a cell which has a reference to another worksheet. This cell is automatically through a series of other macros and so its position is relative to others. Eg, Employees as headers, their skills going down, all referencing to the employee sheets with all their details on. With employees being added and deleted as necessary.
Currently I have this code
Sheets("Data Table").Select Sheets("Data Table").Range("IV4").End(xlToLeft)(1).Offset(0, 1).Select ActiveCell.FormulaR1C1 = resp Sheets("Data Table").Select Sheets("Data Table").Range("IV6").End(xlToLeft)(1).Offset(0, 1).Select ActiveCell = "=" & "'" & resp & "'" & "!P12"
Where 'resp' equals the variable for the employee name and thus the newly inserted sheet. The active cell correctly references the 'resp' worksheet showing (eg) "Sam!P12", but at the moment my only option is to have one of these lines for each cell which is an incredibly slow process because I would need 200+ of them.
Any ideas on the formula i would need to to fill this in?
My best guess is this, but I get an error
Selection.AutoFill Destination:=Range("IV6:IV200").End(xlToLeft)(1).Offset(0, 0), Type:=xlFillDefault
Any help very much appreciated.