Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=519281 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from on sheet to another keep duplicate rows
Plesae mail workbook + text/example explaining expected results
-- AP "mrdata" a écrit dans le message de ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from on sheet to another keep duplicate rows
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from on sheet to another keep duplicate rows
-- AP "mrdata" a écrit dans le message de ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from on sheet to another keep duplicate rows
Any Ideas Welcome I'm pulling what hair I have left out over this ! -- mrdata ------------------------------------------------------------------------ mrdata's Profile: http://www.excelforum.com/member.php...o&userid=17899 View this thread: http://www.excelforum.com/showthread...hreadid=519281 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to move rows from one sheet to another sheet (macro) | Excel Discussion (Misc queries) | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
How to move rows in a Sheet? | Excel Discussion (Misc queries) | |||
Identify and move duplicate rows? | Excel Programming |