Hello,
I have the following data in cells as below that I want to overwrite ID which is in column A of sheet 2 and the rest transposed into that row.
How would I do this please?
Set rng = Sheets("Entry - Accidents").Range("G5, D5, J7, D7, G7, D9, G9, D13, K13, D15, G15, D19, G19, J28, J26...