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
Thank you in advance