Move data from on sheet to another keep duplicate rows

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

Hope someone can help me with this if you need a better expaination I can send an example workbook that explains what I need better.

Thanks
Charles

Plesae mail workbook + text/example explaining expected results

--
AP

"mrdata" <[email protected]> a écrit dans
le message de news:[email protected]...
>
> 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 cotain 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
>
> Hope someone can help me with this if you need a better expaination I
> can send an example workbook that explains what I need better.
>
> Thanks
> Charles
>
>
> --
> mrdata
> ------------------------------------------------------------------------
> mrdata's Profile:
http://www.excelforum.com/member.php...o&userid=17899
> View this thread: http://www.excelforum.com/showthread...hreadid=519281
>

mailto:[email protected]

--
AP

"mrdata" <[email protected]> a écrit dans
le message de news:[email protected]...
>
> Ardus Petus
>
> Where do email the workbook to?
>
> Charles
>
>
> --
> mrdata
> ------------------------------------------------------------------------
> mrdata's Profile:
http://www.excelforum.com/member.php...o&userid=17899
> View this thread: http://www.excelforum.com/showthread...hreadid=519281
>

Any Ideas Welcome
I'm pulling what hair I have left out over this !