+ Reply to Thread
Results 1 to 4 of 4

Delete a row but keep values

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    East Lyme
    MS-Off Ver
    10
    Posts
    37

    Delete a row but keep values

    Hi, just wonder: how can I delete a row but keep values in specific cells from deleting (automatically move values to the next row)? Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Delete a row but keep values

    So... you want to delete a row, but keep some of the values on the row that you have just deleted??
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    08-16-2017
    Location
    East Lyme
    MS-Off Ver
    10
    Posts
    37

    Re: Delete a row but keep values

    yes, can I do it? Thx

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Delete a row but keep values

    Not without VBA, you can't, probably. If it has to be VBA, I can't help. However, it might help if you posted a sample worksheet showing exactly what you want.

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

+ 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. Rows delete formula as per range of cell values with counter to delete # rows
    By qureshi2016 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-03-2017, 09:35 AM
  2. [SOLVED] Help needed with VBA code to replace values with names and delete others Values
    By rv02 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-10-2015, 01:50 AM
  3. Delete duplicate values from cells containing multiple values
    By Buzzed Aldrin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-03-2014, 02:50 PM
  4. [SOLVED] Delete Unique Values Macro Skipping Some Values
    By stockgoblin42 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2013, 06:27 AM
  5. [SOLVED] Delete duplicate values and mantening unique values
    By ronald coletto in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 02:19 PM
  6. delete values between two other constant values..
    By newtothis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2011, 04:50 AM
  7. Exclude values and delete remaining values
    By BJ5352 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2011, 02:36 AM

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