Chris_AAA
03-31-2015, 05:39 AM
Hi
I have a coulumn (D) with several times. I need to decrease the time by one hour - due to clocks changing.
I have added two columns E&F
In E, I have added 01:00:00
In F > D-E
My issue, is because E is a blank column, when I want to fill down the time it does not recognise the last known cell. I understand what I need to do in esscence. I Need to fill down in relation to a column it recognises has a last known field... say column D with the times for example.
So my question is, (and i have searched the net for examples) how do I fill down - but locking the time at 01:00:00 when I try ...
Selection.AutoFill Destination:=Range("e6:e" & Cells(Rows.Count, "d").End(xlUp).Row)
It obviously adds a sequential gain of 1 hour to each row down.
I want to lock the 1 hour time, and fill down in relation to column D to last know row.
Im sure its really easy, but cant get past this puzzle.
Any advise is appreciated.
Thank you kindly.
I have a coulumn (D) with several times. I need to decrease the time by one hour - due to clocks changing.
I have added two columns E&F
In E, I have added 01:00:00
In F > D-E
My issue, is because E is a blank column, when I want to fill down the time it does not recognise the last known cell. I understand what I need to do in esscence. I Need to fill down in relation to a column it recognises has a last known field... say column D with the times for example.
So my question is, (and i have searched the net for examples) how do I fill down - but locking the time at 01:00:00 when I try ...
Selection.AutoFill Destination:=Range("e6:e" & Cells(Rows.Count, "d").End(xlUp).Row)
It obviously adds a sequential gain of 1 hour to each row down.
I want to lock the 1 hour time, and fill down in relation to column D to last know row.
Im sure its really easy, but cant get past this puzzle.
Any advise is appreciated.
Thank you kindly.