Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default how to fill the coloumn with the calendar automatically

HELP ME..
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how to fill the coloumn with the calendar automatically


I'm afraid "HELP ME!" doesn't help us to help you, what is it you need
help with? over what range? are there restrictions or conditions?

NEED HELP PLEASE;452772 Wrote:
HELP ME..



--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125322

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default how to fill the coloumn with the calendar automatically

Enter a valid date in A1

In A2 enter =A1 + 1

Copy down as far as you wish.

When you change the date in A1 all others will also change.

To just fill a column with fixed dates...............

Enter a date in A1

Select A1 to A100 and EditFill SeriesDateDay

Step Value = 1 and OK


Gord Dibben MS Excel MVP

On Fri, 14 Aug 2009 01:01:01 -0700, NEED HELP PLEASE <NEED HELP
wrote:

HELP ME..


Reply
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
Entering calendar automatically ron Excel Worksheet Functions 2 October 28th 07 08:16 AM
link excel to automatically update mailbox calendar when you upd. allyreesevans Excel Worksheet Functions 0 October 11th 07 07:55 PM
How can I fill a time sheet from a calendar PeterM Excel Discussion (Misc queries) 6 November 29th 05 10:24 PM
Calendar that automatically push events back one day. data3501 Excel Discussion (Misc queries) 1 February 3rd 05 02:00 AM
HOW CAN I FILL AN EMPLOYEE CARD WITH EXACT DAYS CALENDAR LARGO16 Excel Worksheet Functions 0 January 19th 05 01:41 PM


All times are GMT +1. The time now is 12:10 AM.

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

About Us

"It's about Microsoft Excel"