ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   writing a statement (https://www.excelbanter.com/excel-worksheet-functions/100697-writing-statement.html)

newexceluser

writing a statement
 
i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates and also i need it to move
down a row once the 1st row is full.
I am very new at writing statements so any help would be great.
thanks

Sasa Stankovic

writing a statement
 
you really need VBA, but you should give more info? what do you mean with
"i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates"

you're copiing dates based on dates?

....and also i need it to move down a row once the 1st row is full..
move down: ActiveCell.Offset(RowOffset:=1, ColumnOffset:=0)
"newexceluser" wrote in message
...
i need to write a statement in excel that will copy dates to another
spreadsheet in the correct cell based on the dates and also i need it to
move
down a row once the 1st row is full.
I am very new at writing statements so any help would be great.
thanks





All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com