+ Reply to Thread
Results 1 to 3 of 3

Problem deleting cell while shifting data up and keeping empt cells

  1. #1
    Registered User
    Join Date
    01-27-2018
    Location
    Des Moine, IA
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Problem deleting cell while shifting data up and keeping empt cells

    When I delete the data of a tem member in the team alignment tab and shift the data up the worksheet loses its empty tabs. Also When I go to the corresponding team tab sheet the deleted team member has "ref" in the cell where their name used to be. Over all I need the data in the team alignment to shift upwards when I remove a team member and also I need the names and their corresponding data to shift up on their team tabs simultaneously. Any help would be greatly appreciated as I am mostly a novice, thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,379

    Re: Problem deleting cell while shifting data up and keeping empt cells

    For B6
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    For B29 and each first row of month
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    drag down to end
    did it on sheet Ruchti for you

    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    01-27-2018
    Location
    Des Moine, IA
    MS-Off Ver
    MS Office 2010
    Posts
    13

    Re: Problem deleting cell while shifting data up and keeping empt cells

    That code you gave me seems to work and now its not showing the "ref' when you delete the TM in the team alignment tab so thank you for that. I do need more than anything for the cells in the corresponding team tabs to delete and shift up when I clear or delete the cell in the team alignment tab. Other than that I appreciate the help you have given me thus far. The code you gave me looks a little more complex than the one I have now but works better than the one I have now too, thank you.

+ 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. Deleting a row of data based on a single cell deletion, and shifting remaining cell up.
    By Dewydecimalpatriot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2014, 04:05 PM
  2. [SOLVED] Keeping the cell reference for SUMIF when deleting the data it references
    By reach78 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2013, 02:29 AM
  3. Deleting cells and shifting them left
    By knitterkuba in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-27-2010, 05:12 PM
  4. deleting double numbers after shifting data
    By greta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2009, 06:46 PM
  5. Macro for pasting, deleting, and shifting data
    By reel004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2007, 06:33 PM
  6. [SOLVED] Cell Deleting and Shifting
    By bodhisatvaofboogie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-15-2006, 08:40 AM
  7. Deleting and shifting cells and columns
    By Curt1521 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2006, 11:20 AM

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