+ Reply to Thread
Results 1 to 1 of 1

Update unique data based on criteria

  1. #1
    Registered User
    Join Date
    10-23-2009
    Location
    Wolverhampton
    MS-Off Ver
    Excel 2003
    Posts
    1

    Post Update unique data based on criteria

    Hi
    im a little stuck and looking for help, i have a spread sheet which i will automatically update based on certain criteria which will return the following columns

    Event Number - SRW ID - Location - Start Date - Start Time - End Date - End Time

    i wish to run a query based on this information to another sheet comparing the data and only returning any new unique values to the last row.

    The Data i want the sheets to compare based on the SRW ID in column B, in the manual sheet i would like the data that has already been adjusted in H to N not to be altered.

    I suppose the question i am asking is, should i get the database query to run on the same sheet only adding new unique entries to the last row, or should i run the database query separate, then getting the 2 sheets to compare adding any new unique rows to the last row, or will i need to create a macro to run this query.

    i know i have probably not been very clear here so i have attached an example
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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