Need a little assistance with a vba formula to get info from cells to create a formula like this
I am constantly adding to the formula.
So, say column A would be what to look for, column B what to change to to.
Thanks
Code:
Range("J1").Formula = "=IF(D1=""Mayberry R.F.D."",""Mayberry RFD""," & _
"IF(D1=""Diners, Drive-ins and Dives"",""Diners Drive-Ins and Dives"",IF(D1=""Forever "",""Forever (2014)""," & _
"IF(D1=""Food Factory (CA)"",""Food Factory CA"",IF(D1=""Castle (2009)"",""Castle 2009"",IF(D1=""Guy's Grocery Games"",""Guys Grocery Games"",D1))))))"
Range("J1").Copy
Range("J2:J" & LastRow).Select
ActiveSheet.Paste
Application.CutCopyMode = False
I am constantly adding to the formula.
So, say column A would be what to look for, column B what to change to to.
Thanks