Marco Help to Stop duplicates

[Jamesr571]

Hello All,

I was wondering if anyone can help me with a very annoying issue I have.

I have over 1000 sites and have to log 4 different job types, some of which need to be logged in 2 areas. I have made a tracker that merges all those lists together so I can keep track of what has been done and what I need to do for each site.

Info: Area Tab, will contain all info on the sites within each area (there are 7 area tabs). So this tab needs to log the first minor / major / survey job for the site. Major Tab needs to log all Majors done, there may be some sites that have more then 1 Major per report. Reactive tab needs to log all reactives done and there may be several reactives per site.

Issue: If the first job on a site is a Major it gets logged on both the Area & Major tab, I need a macro that will recognise it is the same job and only put in the area details onto the Tracker. But I still need it to log if a major service is done at a later date that it gets added, so really needs to compare dates and job types.

I have attached a little example although it is not a complete extract (due to confidentiality reasons)

Anyone got any ideas?

Book2.xls

[Jamesr571]

could someone please help me with this????????

[Jamesr571]

anyone??

If you think it isnt possible then please at least let me know so I can rethink what to do

[RHCPgergo]

It sounds possible and I'd love to help, but can you explain it more in layman's terms?

For example: "if the values and the date of a row are the same in two sheets, then only copy the row once to another sheet" or something like that.

From what you wrote I reckon you already have a macro that populates your sheets?

[Jamesr571]

Hello,

basically exactly what you said. if the values and the date of a row are the same in two sheets, then only copy the row once to another sheet"

I will give you an example: if there is a Major Service (during a major service a minor service will also be done so it counts for both) it will be inputted onto the area sheet & also onto the Major Service sheet. But I would like the tracker sheet to recognise it is the same job and only show the Area sheet info. This can be done by comparing both the Job type & service date columns.