Same Date in Column A on Mutiple Lines in seperate worksheetsSolved/Closed

Question

Hi,

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

TrowaD · Answer

Hi Grangeeman,

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.

When you are ready for the next date:

 create a new sheet
 enter the date in A1
 paste the same code in the new sheet

Best regards,
Trowa

TrowaD · Answer

Hi Grangeeman,

You must have done something different.

Download the following workbook:
http://ge.tt/4Do8vWN2/v/0?c

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.

Best regards,
Trowa

Same Date in Column A on Mutiple Lines in seperate worksheets

2 responses

Similar discussions

Subscribe To Our Newsletter!