Auto populate weekday from a separate date entryClosed

Question

Hello, 

I am wanting to do two things:

1. In the first column I want to add in the date, in the second column I want it to automatically insert the weekday which correlates to the date just entered. As I can't seem to autofill the normal validation process because the cells all show a default all the way down the list, even though there is nothing yet entered in the date field.

2. Add to a list from the top which automatically goes down in descending order with each entry, so I am continually using the list from the top.


How do I do these things? Any ideas?
Thanks!

TrowaD · Answer

Hi Feebee1,

1. When entering the date in the first column, also enter it in the second column. Format the second column to display day only. Select column, Ctrl+1, on the numbers tab select the bottom option and enter "dddd".

2. Start recording a macro, select the column you want to sort, apply filter (top menu Data), change filter to descending order, remove filter, stop recording.
Adjusting code: Hit Alt+F11 to view the recorded code, copy the code except the first line. Double click the appropriate sheet on the left side, paste your recorded code and put the following lines at the top:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns(1)) Is Nothing Then Exit Sub 
Change the "1" in the 2nd code line to the column number you applied the autofilter to.
Then place

Let us know if you would like more assistance.

Best regards,
Trowa

Auto populate weekday from a separate date entry

1 response

Similar discussions

Subscribe To Our Newsletter!