You can enter date in J5 and then select J5, K5 (Blank) and L5 (Blank) and then click on the plus sign which you can see on right hand down side of cell L5 and then strech your selection using mouse (dont leave first button of your mouse until the selection is complete) till AW5 or till wherever you want.
Thanks, Ajay On Thu, Sep 4, 2008 at 1:37 PM, cmatera <[EMAIL PROTECTED]> wrote: > > I have a worksheet where cells J5, M5, P5 All the way through AW5 have > dates formatted in the mm/dd/yyyy format. Ideally I want to enter in > the date in the first cell J5 and have the rest of the dates populate > the cells all the way up to cells AW5 is that possible? > > Thanks > > Chris > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
