Not using FILL with copy/paste....Is there a way to create a date range in Column A (IE: 9/1/15) from line 1 going downward when entering multiple lines of data on Column B (sometimes going well past line 9000). Then create a new sheet with the next date range (IE: 9/2/15) , when entering multiple lines of data on Column B. Then a new sheet would have (IE: 9/3/15) and so on & so on..... or a way to change all dates in column A to next day like above?
09/01/15 1:13:10 AM Trigger
09/01/15 1:13:11 AM Stop
09/01/15 1:13:11 AM Start
09/01/15 1:14:11 AM Stop
09/01/15 1:14:11 AM Start
09/01/15 1:40:07 AM Trigger
Thanks
grangeeman
Related:
Same Date in Column A on Mutiple Lines in seperate worksheets
The following code will enter the date present in A1 into column A of the respective row when an entry is made in column B:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("B:B")) Is Nothing Then Exit Sub
Target.Offset(0, -1).Value = Range("A1").Value
End Sub
Implement the code by right-clicking the sheets tab and select View code, then paste the code into the big white field.
Here you will find a date in A1. Now enter something anywhere in column B and notice that the date from A1 will be copied to the cell left of the one you entered something in.