+ Reply to Thread
Results 1 to 5 of 5

Filing system

  1. 04-13-2007, 08:06 AM #1
    poppedinsouled
    poppedinsouled is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    6

    Filing system

    Hi,
    I'm a newbie here and am a little with excel.

    I want to start a filing system for my work and want excel to do a specific thing.

    When I type 'C' in a column and tab I want the date to appear i.e. Cyymmdd.

    I've tried custom formatting and absolute addressing, but the date changes from day to day, I want it to stay on the date when I first put it in.

    Hope I've made my self clear

    Anyhelp would be appreciated or a point in the right direction.

    Regards
    Reply With QuoteRegister To Reply
  2. 04-13-2007, 08:45 AM #2
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    You need a worksheet change macro
    This macro adds date when a C is entered into column A - Change the red number 1 as required

    'These instructions pre typed & are worded to cater for the novice programmer
    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Select sheet this is to appy to
    'Right Click on Sheet Name Tab > select View Code
    'Past macro into the Worksheet Module displayed

    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.
    Reply With QuoteRegister To Reply
  3. 04-13-2007, 09:24 AM #3
    poppedinsouled
    poppedinsouled is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    6

    Talking

    Many thanks...that is exactly what I wanted...brilliant !!!

    Reply With QuoteRegister To Reply
  4. 04-13-2007, 10:49 AM #4
    poppedinsouled
    poppedinsouled is offline
    Registered User
    Join Date
    04-13-2007
    Posts
    6

    Filing System

    Hi

    I maybe being a bit slow on this subject, but I've just gone back into my spreadsheet, and the program I cut and pasted into my excel sheet has now stopped working, the code is still there when I right click >view code, but nothing happens when I press 'C' in column one.

    Is there something I should be engaging for it to work.

    Any help would be appreciated

    Regards,
    Reply With QuoteRegister To Reply
  5. 04-13-2007, 04:47 PM #5
    mudraker
    mudraker is offline
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    One of the commands in the macro turns off event triggers - if this command is run & for some reason the command tha turns them back on does not get run when you type the C in nothing happens.

    Place this macro on the same module sheet

    Please Login or Register  to view this content.
    Run it (F5)
    Try your sheet
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1