Hi George,
Have a look at the attached to see if it does what you need.
The macro puts the new data onto sheet 2, but it could just as easily modify
the sheet the data is on (sheet 1).
Regards - Dave.
> Hi Dave,
>
> I'll try to describe it better.
>
> I have columns like
>
> F
Hi Dave,
I'll try to describe it better.
I have columns like
F J
data1 data2
(empty)data3
(empty)data4
(empty)(empty)
data5 data6
(empty)data7
(empty)data8
(empty)data9
(empty)(empty)
My result must look like:
F J
data1
Hi George,
Can't quite understand your request.
"column F down untill we reach two empty cells in columns F and J"
But your sample data doesn't have 2 empty cells in both F and J.
Perhaps you could attach a sample workbook with a bit more data - say 20 rows.
Regards - Dave.
> Date: Fri, 29 May 20
