Adding Values To a Next Column

[abi]

Hi Good Day to You. I am a beginner on recording a macro on excel.What I am doing now is making excel macro on my report every week.I am using Vlook up to input data on my worksheet template. I just want to know what formula I will use to put a data on a next column everytime the macro will run.There are 2 columns that I need to fill up.The data of this 2 columns has a different source of data.Please advice!!! Thanks a lot in Advance.... :wink:

 

[erik.van.geit]

Hi, abi
Welcome to the Board !!!!!

just want to know what formula I will use to put a data on a next column everytime the macro will run

when only reading this line my suggestion would be "test1"
(adding info to row 1)
"next column" perhaps you mean "row"

There are 2 columns that I need to fill up

this would be "test2" (adding info to column 2)

Sub test1()
Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1) = Date 'or whatever
End Sub

Sub test2()
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = Date
End Sub

anyway your post is somewhat confusing to my sense
please provide an example of what you're doing

kind regards,
Erik