+ Reply to Thread
Results 1 to 5 of 5

Deleting a line from one worksheet does not delete the corresponding line in another

  1. #1
    Registered User
    Join Date
    08-09-2004
    Location
    auckland
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    72

    Deleting a line from one worksheet does not delete the corresponding line in another

    Hi,

    I have a spreadsheet that is a database of certain houses in the area for sale, with lots of associated property data. It is in a table format so I can easily change the order based on whatever aspect of the property I am trying to compare.
    In another worksheet I have a more readable version of the same data, nicer order, less detailed info. It takes its data directly from the worksheet with the table.

    When I delete lines from the table (which I do once I'm narrowing down a search), the corresponding line in the readable (comparable) worksheet doesn't disappear, leaving a whole lot of blank rows.

    Funny thing is, I'm sure I remember having this work properly a while back. I'm not sure what I've changed.

    Is anyone able to fix what I have done?

    Thanks
    Last edited by AliGW; 06-26-2022 at 04:35 PM. Reason: Workbook removed.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,742

    Re: Deleting a line from one worksheet does not delete the corresponding line in another

    Administrative Note:

    Is your data proprietary or have you desensitised it? If it is NOT desensitised, then you need to remove it from the workbook and replace it with dummy data.


    Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,343

    Re: Deleting a line from one worksheet does not delete the corresponding line in another

    At least one of those entries is a real Real Estate Agent … and the email addresses are very imaginative if they're not real … just saying. Think it needs Moderator intervention …
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,742

    Re: Deleting a line from one worksheet does not delete the corresponding line in another

    I have removed it. It needs to be replaced with a sanitised version with dummy data. There have been at least seven downloads.

  5. #5
    Registered User
    Join Date
    08-09-2004
    Location
    auckland
    MS-Off Ver
    MS Office Professional Plus 2016
    Posts
    72

    Re: Deleting a line from one worksheet does not delete the corresponding line in another

    Thanks guys. I’ll update it and replace shortly

+ 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. Move row to new sheet and delete - Explain this code line by line
    By omoHF in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2018, 12:38 PM
  2. Replies: 3
    Last Post: 03-12-2017, 03:39 PM
  3. deleting a line based on data in a previous line
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2013, 09:49 AM
  4. Populating a form in excel from a different worksheet line by line
    By GhettoNarnia in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-07-2012, 06:51 PM
  5. line appears when deleting chart- cannot delete it
    By Brian in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-20-2006, 08:50 AM
  6. [SOLVED] Delete every other line in LARGE worksheet
    By robotman@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2006, 11:50 AM
  7. Macro problem on, Yellowed line - previous line or next line.
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-29-2005, 07:06 PM

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