+ Reply to Thread
Results 1 to 5 of 5

Deleting a Record a Worksheet

  1. 12-08-2010, 02:44 PM #1
    jason_kelly
    jason_kelly is offline
    Registered User
    Join Date
    07-22-2010
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    71

    Deleting a Record a Worksheet

    Hi there,

    I need your help.

    I have a userform from which I would like to program the "Delete Record" button to search through 2 worksheets for the record based on the file number specified and remove the line from the specified worksheet.

    Any help with this is greatly appreciated.

    Thanks a bunch
    Attached Files Attached Files
    Last edited by jason_kelly; 12-08-2010 at 06:34 PM.
    Reply With QuoteRegister To Reply
  2. 12-08-2010, 04:01 PM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Deleting a Record a Worksheet

    Hello Jason,

    Which column holds the file number? Is it column "C" (2011-TEST)?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 12-08-2010, 04:43 PM #3
    jason_kelly
    jason_kelly is offline
    Registered User
    Join Date
    07-22-2010
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Deleting a Record a Worksheet

    Hi Leith,

    You are correct!

    Column C does indeed hold the file number.

    Thanks again
    Reply With QuoteRegister To Reply
  4. 12-08-2010, 05:01 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Deleting a Record a Worksheet

    Hello Jason,

    Here is the updated macro. I have added it to the attached workbook.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 12-08-2010, 06:34 PM #5
    jason_kelly
    jason_kelly is offline
    Registered User
    Join Date
    07-22-2010
    Location
    Ontario
    MS-Off Ver
    Excel 2003
    Posts
    71

    Re: Deleting a Record a Worksheet

    Thanks very much for the awesome help Leith.

    It worked like a charm, your a genious!

    Cheers and have a great evening.

    Jay
    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