LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 440
Default Autofill dates when 1 is entered in a cell

If a 1 is entered in any of C7 - C13, I would like to autofill sequential
numbers down column C up as far as the number 31. It's for a monthly sheet
with days of the week in column B. So regardless of which day is the 1st, the
code will copy the numbers down for the user.

Thanks,
--
Traa Dy Liooar

Jock
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
autofill colour based on date entered Tacrier Excel Discussion (Misc queries) 4 December 17th 08 06:02 PM
How can I autofill dates having a blank cell between each day? Dee New Users to Excel 1 July 3rd 08 04:59 AM
autofill on fixed dates Guido Cole Excel Worksheet Functions 1 March 18th 07 04:23 PM
autofill next sheet with next set of dates Penny Excel Worksheet Functions 0 July 11th 05 09:25 PM
If both dates are entered into a cell then answer is yes Teresa Warne Excel Worksheet Functions 2 October 30th 04 02:56 PM


All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"