Looking to find a macro to change the first value in the concatenate to the site number in b column. Current code in column d is =CONCATENATE($B$779,+$C780)
I Auto filled the d column and now I need to change them to the site to the left in column B. Is there a way to automate this or another simple way to make an vba code at all?
Attached a picture for reference
[ATTACH=JSON]{"data-align":"none","data-size":"full","data-attachmentid":1199446}[/ATTACH]
Thank you in advance