+ Reply to Thread
Results 1 to 10 of 10

Auto Fill Cell With Today's Date And Shift Cells To The Right

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Auto Fill Cell With Today's Date And Shift Cells To The Right

    I'm trying to create a log sheet / check-list for work.
    • I need the history to be preserved as the dates go on
    • I need the latest dates to show in column D
    • The current date needs to be easily inputed

    Does anyone have any ideas?

    In the file attached C4:E6 would need to be updated to look like C2:E3.

    Any help would be greatly appreciatedCheck List Template.xlsx

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,570

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Hi,

    See attached
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    That Is amazing! Thank you so much. I've never used Macro's before. I need to insert a column before C, but it interfere's with them. I've tried editing the macro but it didn't work for some reason. Could you insert a column?

  4. #4
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Nevermind I got it to work!

  5. #5
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,570

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Hi,

    Try the attached instead.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Thanks

    I start editing cells, then it keeps giving me, run-time error '13': type mismatch.

    Then It all stops working.

    Does this latest one work with column D? I find it didn't even when I inserted the cells

  7. #7
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,570

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Yes,

    Sorry about that. I'd forgotten that column C was hard coded in the macro.

    I've made it a variable now and set a variable name in the Excel sheet. See attached
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Wow, now that works well. One last thing :S I'm going to be using this with different clients so I'll need to filter them. When I turn on the filter it doesn't work and gives me "run time error:1004 insert method of range class failed". that's way above me.

    Do you think I should learn how to do these macros? if so, do you know of a good place to start learning?

  9. #9
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,570

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Hi,

    How and what are you flltering since I don't find any problem.

    If you are going to rely on workbooks that have macros then it's certainly a good idea that you have at least a basic understanding of what makes them tick. As for learning, well we're all different. Some prefer to go on courses, others prefer to get stuck in obviously starting with very simple stuff, make lots of mistakes and ask questions in forums like this.

    The first place to start is the macro recorder. Create macros for a few simple tasks like copying or filtering data and study the code you get. When you understand the syntax and what specific code instructions are doing then start to modify the code. Usually the first thing to do is think about creating variables so that you can generalise code since the macro recorder only captures very specific stuff like selected ranges.

    Buy a book that explains the basics of VBA / Macros and repeat the examples that will come with that. And of course follow threads here and watch the answers as they modify and adapt things.

  10. #10
    Registered User
    Join Date
    08-13-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Mac Excel 2011
    Posts
    30

    Re: Auto Fill Cell With Today's Date And Shift Cells To The Right

    Okay, I'll have to get into it. I have several things on the ropes to learn, like CSS and html, but i definitely want to at least get the basics. Toying around with the record and the forums definitely seems more my style. Thanks!

    I tried adding the filter, it didn't give me an error but it seems as though it just turns off.
    Check List Template (1).xlsm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code for auto fill date (today)
    By reignkystar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 04:09 AM
  2. Auto-fill cells with Dates based on another date cell
    By oneilkr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-16-2013, 07:32 PM
  3. Click on a blank cell to auto add today's date
    By DK1981 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2011, 05:55 AM
  4. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  5. [SOLVED] [SOLVED] Fill cell with today's date
    By Sarahbkelly in forum Excel General
    Replies: 6
    Last Post: 01-19-2006, 09:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1