+ Reply to Thread
Results 1 to 5 of 5

Delete cells value based on date

  1. #1
    Registered User
    Join Date
    04-12-2010
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    96

    Question Delete cells value based on date

    Hi, i have a problem here. I already have a macro to run my program. but there is a little change for my data so that i have to modify my macro. Pls check the attachment below, i have to run the macro in the "111MyProgramEmpty" file and get the data from the several "CustomerDemand". but now, there is one more column added in the report file which is" Month Refresh", so i have to delete the data that is smaller than the Month Refresh month. there is code in the "111Myprogram" file, please open it and try to run.
    As i am a VBA beginner, i really hope someone could help me with this. Please ask questions if there is any confusion. Greatly appreciated!!
    Last edited by yjmmay34; 04-27-2010 at 03:35 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Delete cells value baced on date

    please don't use in-line attachments. Just use the Manage Attachments tool, and then leave it at that. Our members like to know how big a file is, and inline attachments don't show file size.

  3. #3
    Registered User
    Join Date
    04-12-2010
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    96

    Re: Delete cells value baced on date

    Quote Originally Posted by teylyn View Post
    please don't use in-line attachments. Just use the Manage Attachments tool, and then leave it at that. Our members like to know how big a file is, and inline attachments don't show file size.
    Hi, thank you. But could you help me with this problem?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Delete cells value baced on date

    Once again - do not use the user messaging to solicit help

    I suggest you actually read the Forum Rules that you agreed to when joining the Forum
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Delete cells value based on date

    In addition to Roy's post, let me repeat what I've asked you at least three times already:

    Do not quote whole posts. Use the Post Reply button or the Quick Reply box. Do not use the Quote button to answer a post.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1