JP2R
11-03-2008, 05:35 PM
Greetings All -
I was scanning through the information/questions/help on Loops and using FormulaR1C1 - but just can't seem to get my brain around it...
I'm trying my hand at writing a VBA script to automate/massage my data -
In column "AA" I have a Date/Time stamp - In column "AB" I would like to fill down the formula "=INT()" - Where the loop looks to column "AA" - sees if it is empty or if there is something there - if there isn't moves to the next - if there is - then put that date in that cell.
Hope that makes sense...
01 AA AB
02 09/30/2008 13:32:00 =INT(AA2)
This is how it looks now - because I filled the column in manually
with the result in "AB" showing just the date.
I'm sure this is so simple for most of you - but I haven't a clue.
Thanks so much!
-- Monk
I was scanning through the information/questions/help on Loops and using FormulaR1C1 - but just can't seem to get my brain around it...
I'm trying my hand at writing a VBA script to automate/massage my data -
In column "AA" I have a Date/Time stamp - In column "AB" I would like to fill down the formula "=INT()" - Where the loop looks to column "AA" - sees if it is empty or if there is something there - if there isn't moves to the next - if there is - then put that date in that cell.
Hope that makes sense...
01 AA AB
02 09/30/2008 13:32:00 =INT(AA2)
This is how it looks now - because I filled the column in manually
with the result in "AB" showing just the date.
I'm sure this is so simple for most of you - but I haven't a clue.
Thanks so much!
-- Monk