Copying between workbooks, then adding a date into cell

Hello,

I am trying to take a daily total, lets say from B1, and add it into a seperate workbook Column "B", daily. However, I would like to add the date to display in column A, in addition to adding the total for that day into column "B" when the script is ran. Im pretty sure I can just use =today() if that will be simplest (unless of course theres an easier way to stick the date into the cell via VBA). Im not sure about the syntax, but Im thinking where I have (nextrow, "B"), I can add the date via (nextrow, "A"). I tried to formular1c1, but not sure if theres a more practical way? I think im over-thinking it..

Also, the workbook to copy from will be named different every day, so I have set it to Workbooks(2). Thanks for any suggestions!

Please Login or Register  to view this content.

:EDIT:

My solution is to add:

Please Login or Register  to view this content.

How do I set the date to format as 17-Aug for example without having to format the column every time?

Change this line from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

thank you so much!