Solved: Add new record of data to existing worksheet

[JimS]

I have a worksheet with several rows of data in Columns A-J called “Original”.

I manually add some notes in Column K on the “Original” worksheet.

Each row of data represents a “record of data” being made up by a single row of data in Columns A-J.

I need to add new records of data to the Original worksheet from a different worksheet containing several rows of data, BUT only if the records are new.

Once again a record being a single row of data made up of Columns A-J.

Basically I need to evaluate the row of data (Columns A-J only) and add it to the worksheet only if it's a new record.

I have attached an example file.

Any ideas?

Thanks…
JimS

[p45cal]

Is there one column to look at which decides whether a record is new or not, or does the whole row need looking at?

[JimS]

Unfortunately the entire row needs to be evaluated (Columns A-J).

[p45cal]

I don't have a machine with excel 2007 on it to hand, but can't you just add all the possibly new records under the existing records in the Original sheet, then select all the records and remove duplicates? I think this will evaluate all columns in the records for similarity.

Look at Method 5 here: http://www.mrexcel.com/tip138.shtml
and a you tube vid here.

[Aussiebear]

Is there a limit to the number of fields used to evaluate?

[p45cal]

Is there a limit to the number of fields used to evaluate?

As I said, I don't have a version 2007 up to try this on, but an internet search doesn't show up any limitation. Ultimately, I suppose there could be one; did you ask because you strongly suspect the existence of such a limitation?

[JimS]

I can use the Remove Dups by deselecting the Notes Column.

Thanks for your help...

JimS

[Aussiebear]

Just curious. I suspect there might be a limitation but when you think about it, there probably not that many times when you need to 10 columns to see if its a new record.