Auto Fill Days of week based on drop down selection in first day/column

**CKD777** · 10-22-2011, 12:51 PM

7 columns - first column has drop down menu with choices Monday thru Sunday - Once day of week is selected I want following 6 days/columns to auto populate in order with correct day.

EXAMPLE: Choose Tuesday from drop down in first day/column then second column will automatically fill with Wednesday, third column will fill with Thursday and complete to fill all columns. THANK U!!

**mrice** · 10-22-2011, 02:55 PM

Try pasting the following code into the relevant sheet tab (e.g. Sheet1) in the VBA editor (Alt F11).

Please Login or Register  to view this content.

I've assumed that the cell with the drop down is A1 and the 6 additional cells are in B1 to G1

Auto Fill Days of week based on drop down selection in first day/column

LinkBack

Thread Tools

Rate This Thread

Display

Auto Fill Days of week based on drop down selection in first day/column

Re: Auto Fill Days of week based on drop down selection in first day/column

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions