+ Reply to Thread
Results 1 to 4 of 4

Delete row (row# to delete is listed on spreadsheet)

  1. #1
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Delete row (row# to delete is listed on spreadsheet)

    I have a userform that is actually 8 separate forms (I did this instead of using darn multipage that doesn't let me change the color of the multipage tabs). Page one starts a new row in a table on "SkinData" worksheet. Pages 2-8 just keep adding more data to that same row. All 8 forms must be completed or our audit is incomplete.

    It's fine to use the 'x' on page 1....because a new row hasn't been started yet. But, my problem is if they close using the "x" in the corner of the form on pages 2-8, it could mess our data up.

    So, if they use the 'x', I want it to give them a yes/no "Are you sure" kind of warning. Then, if they say yes to close (and they're on any page other than page 1), I want the row they started to be deleted. This will ensure we don't have fragments of data.

    One more thing....I already have the row # started by page 1 in a 'validations' worksheet (cell DA2). So...either I can tell it to delete that row OR I guess I could tell it to delete the last row in column A (only columns A-G are completed by page 1 so it would have to look at one of those...there are like 60 columns but I guess that doesn't matter if I delete the entire row).

    So...HELP and a pre-thank you for those who help!

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Delete row (row# to delete is listed on spreadsheet)

    I forgot to mention I'm working in Excel 2013

  3. #3
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Delete row (row# to delete is listed on spreadsheet)

    No ideas from anyone?!?!

  4. #4
    Forum Contributor
    Join Date
    07-25-2012
    Location
    Winterville, NC
    MS-Off Ver
    Excel 2013
    Posts
    141

    Re: Delete row (row# to delete is listed on spreadsheet)

    Any suggestions?

+ 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. [SOLVED] delete entire row if it doesn't contains at least 1 of the words listed
    By 4evra in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2013, 02:14 PM
  2. Date filter, find listed dates and delete whole row
    By zit1343 in forum Excel General
    Replies: 3
    Last Post: 04-25-2012, 08:16 PM
  3. Delete rows in worksheet1 which are not listed in worksheet2
    By prayami in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2007, 06:07 PM
  4. Replies: 1
    Last Post: 06-19-2006, 04:37 AM
  5. Delete rows listed less than 8 times???
    By anilos81 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-10-2005, 12:29 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