Hi All,
I recorded a macro but it is very ineffecient as I copied the code, dragged to fill etc but, I would like to perform the following but in VBA code
=IF(I2=I1,N1&", "&E2,E2)
Where it loops until the end where the approver stops (the sheets can vary in how many row it can be).
The idea behind the code is to filter companies .Value <> "Burger Bar" (deleted all other columns for ease), sort the approver a-z then perform the function =IF(I2=I1,N1&", "&E2,E2) then only keep the longest chain according to the approvers email so only 1 mail is sent with all the workers (I have another VBA that automatically sends the mail)
I just want to clean up the code and make it more responsive and flexible.
I highly appreciate any time given to assisting me, thank you
I recorded a macro but it is very ineffecient as I copied the code, dragged to fill etc but, I would like to perform the following but in VBA code
=IF(I2=I1,N1&", "&E2,E2)
Where it loops until the end where the approver stops (the sheets can vary in how many row it can be).
The idea behind the code is to filter companies .Value <> "Burger Bar" (deleted all other columns for ease), sort the approver a-z then perform the function =IF(I2=I1,N1&", "&E2,E2) then only keep the longest chain according to the approvers email so only 1 mail is sent with all the workers (I have another VBA that automatically sends the mail)
I just want to clean up the code and make it more responsive and flexible.
I highly appreciate any time given to assisting me, thank you
