VBA to Copy Data

[geoffbird]

Hey,

I am sure this is simple for a lot of people here and would really appreciate the help.

Basically I am looking to copy data into the next empty cell using VB

I have a data set in S2:S292. I would like to copy this into cell C2. If C2 has values already within this then copy to D2. if D2 has values then E2 etc etc etc.

Thanks in advance!!

 

[geoffbird]

I was hoping to do this with some sort of loop but I have managed another way.

For anyone who mkay be interested I have used the below to find the next blank cell and offset 1 column before pasting.

Range("S2:S292").Select
Selection.Copy
Range("A2").Select
Selection.End(xlToRight).Offset(0, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

 

[jmacleary]

Hi Geoff

Glad to see you sorted out your problem yourself - just a question - what happens when you have used up all the columns between C and S?

Regards
John