+ Reply to Thread
Results 1 to 4 of 4

Automatic removal of data from one worksheet where it exist within another worksheet

  1. #1
    Registered User
    Join Date
    05-02-2017
    Location
    england
    MS-Off Ver
    2013
    Posts
    11

    Automatic removal of data from one worksheet where it exist within another worksheet

    Hi. I have the attached workbook with 2 sheets. I would like the first sheet to automatically exclude the data from the second sheet. This first sheet will be overwritten regularly by a much larger range of data and rather than having to manually find the test cases from the second sheet I was hoping there was an automatic way to do this. Any help would be much appreciated.

    Basically:
    Sheet 2 will always be the same data and never change.
    Sheet 1 will continue to grow more rows as more support tickets are added to our database.

    I wanted to check to see if there is an easy way to automatically remove the data from sheet 2 when the new data is added to sheet one and overwrites the original. It will eventually grow to 10,000s of rows and its quicker to add all the data to sheet 1 and overwrite this as some items may change, rather than trying to pinpoint specific tickets through the reporting engine we use to obtain the data.
    Attached Files Attached Files
    Last edited by barber87; 05-08-2017 at 10:55 AM.

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,990

    Re: Automatic removal of data from one worksheet where it exist within another worksheet

    Your stated requirement is vague.
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Registered User
    Join Date
    04-25-2017
    Location
    Chicago
    MS-Off Ver
    2013
    Posts
    3

    Re: Automatic removal of data from one worksheet where it exist within another worksheet

    I was able to create the attached file with OpsLab. First, I imported each sheet as a separate table. Then, I used this query to create the output:

    Please Login or Register  to view this content.
    In OpsLab, change s-elect to select, I had to type it this way for the post to be accepted by this website. Please let me know if you'd like more help on this.
    Attached Files Attached Files
    solving problems at Amdirent, Inc

  4. #4
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,990

    Re: Automatic removal of data from one worksheet where it exist within another worksheet

    Please Login or Register  to view this content.

+ 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. Need to check if data exist in another worksheet
    By VladVerishko in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2015, 11:14 AM
  2. WorkSheet SelectionChange on a worksheet that doesnt yet exist
    By Johan99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2014, 10:56 AM
  3. Replies: 0
    Last Post: 08-05-2013, 08:44 PM
  4. [SOLVED] using macro to check worksheet if data input in another worksheet exist.
    By Curtis goh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2013, 01:02 AM
  5. i need a macro if a worksheet name exist rename to a new worksheet
    By daillest319 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2012, 04:55 PM
  6. Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist
    By pete.bastin@btopenworld.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2006, 01:10 PM
  7. File opens as worksheet.xls:1 and worksheet.xls:2. Only one exist
    By Dave the wave in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2006, 07:35 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