I am trying to find a solution but my mind is drawing a blank.
I need to add the data from one sheet into another but it needs to go in the next available column which will change dynamically.
I have attached a spreadsheet example where I need to take the data from sheet 2 and add it to the end of sheet 1.
Is anyone able to help?
History Test.xlsx (23.0 KB)