Hi
I have tried to find a solution to this without much success.

I have a workbook containing a Main worksheet where data will be
edited
And another worksheet that is imported containing new data this is
updated on a daily basis.

For instance mondays imported data needs to copy to the Main worksheet
there it will be edited the data consists of columns A-M columns O-R
are manualy keyed entries.

Tuesdays imported data will contain mondays data plus new data
This new data may be anywhere in the the imported data worksheet as the
data is sorted by column A.

Example:
Mondays data:
400 Apples Oranges Pears Lemons
401 Apples Oranges Pears Lemons
402 Apples Oranges Pears Lemons
403 Apples Oranges Pears Lemons
404 Apples Oranges Pears Lemons

Tuesdays Data:
400 Grapes carrots corn beets <<<<<<<<<<<<<New ENTRY
400 Apples Oranges Pears Lemons <<<<Old ENTRY
401 Apples Oranges Pears Lemons <<<<Old ENTRY
402 Apples Oranges Pears Lemons <<<<Old ENTRY
402 Grapes carrots corn beets <<<<<<<<<<<<<New ENTRY
403 Apples Oranges Pears Lemons <<<<Old ENTRY
404 Apples Oranges Pears Lemons <<<<Old ENTRY

the above is a crude example of what I need Im not working with fruit

What I want to do is look at the Main worksheet and the Imported one
Determine if any of the row data matches and only copy the new data to
the last available empty row of the main worksheet.
Then have columns A-R sort by column A range A5:R350
This will keep all the manualy keyed data on the correct rows

Thanks
Charles


--
mrdata
------------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899
View this thread: http://www.excelforum.com/showthread...hreadid=525526