I created this macro so it will collect info from 3 cells a put a phrase in
AS2. The data that is on these 3 cells comes form other sheets. (Sheet 1, 2,
and 3)
What I need this macro to do also is to collect info from 2 cells instead
of 3. If the information in cell is RC[-20] is coming from sheet 4.
Any suggestions?

Sheets("Upload").Select
Range("AS2").Select
ActiveCell.FormulaR1C1 = _
"=IF(RC[-1]="""","""",RC[-43]&'Sport'!R6C29&'Upload'!RC[-20])"
Range("AS2").Select
Selection.AutoFill Destination:=Range("AS2:AS500"), Type:=xlFillDefault
Range("AS2:AS500").Select