Move data from on sheet to another keep duplicate rows

M

mrdata

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top