+ 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 Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

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

    Your stated requirement is vague.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  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 Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    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. 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