Same Date in Column A on Mutiple Lines in seperate worksheets
Solved/Closed
grangeeman
Posts
2
Registration date
Wednesday September 2, 2015
Status
Member
Last seen
September 3, 2015
-
Sep 2, 2015 at 06:11 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 7, 2015 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 7, 2015 at 11:24 AM
Related:
- Same Date in Column A on Mutiple Lines in seperate worksheets
- How to insert lines in word for resume - Guide
- Commandos behind enemy lines download - Download - Strategy
- Display two columns in data validation list but return only one - Guide
- How to remove table lines in word - Guide
- Bash reverse lines - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 3, 2015 at 11:17 AM
Sep 3, 2015 at 11:17 AM
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:
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:
Best regards,
Trowa
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
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 7, 2015 at 11:24 AM
Sep 7, 2015 at 11:24 AM
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
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
Sep 3, 2015 at 02:56 PM