Copy Values From 2 Columns To Next Available Row

[Jaye7]

Hi All,

I am after a script that would loop between columns C to column I.

The range is based on column A.

The columns (C-I) may not have values in certain cells, when they do I need to copy the value from Column C into the next available row in column A and also copy the same row value of column A into column B, so if a value was found in range("C3") then it would copy the value from C3 into the next empty row in column A and it would copy range("A3") value to column B next to where the C3 value was copied to.

I hope that this makes sense.

 

[Jaye7]

That's great, thanks for all your help Anthony, have a great day/night.