https://imgur.com/a/PiUe6Lz
I want the macro to be relative because the actual data is in adjacent 2 lists so it just keeps going down.
All the VBA I know just overwrites the cell or Takes the first row's formula copied as a quote and applies that to every output rather than whats inside the cell newly selected cell of the 2nd row.
E.g the first row copied is yellow lorry added correctly to Red Lorry but if the 2nd row says purple lorry the output and vba code creates the same output as the first row instead of
"red lorry purple lorry" shown in image.
I want the macro to be relative because the actual data is in adjacent 2 lists so it just keeps going down.
All the VBA I know just overwrites the cell or Takes the first row's formula copied as a quote and applies that to every output rather than whats inside the cell newly selected cell of the 2nd row.
E.g the first row copied is yellow lorry added correctly to Red Lorry but if the 2nd row says purple lorry the output and vba code creates the same output as the first row instead of
"red lorry purple lorry" shown in image.
