Copy range from sheet1 to sheet2 not deleting older dates and not doubling up.

[Zeak]

Hi All,

I've been searching though the web and though the different threads on here but I am unable to find anything that will work for me.
So if the magician's on here could help me with their wizardry, I would much appreciate it.
My problem is that I need to copy data in columns (Release Date, ID, Sequence, Parent Item, Qty Ordered) in sheet 1 to sheet 2 and as said in the title it needs to not overwrite the data in sheet 2 or duplicate what is already there.
Sheet 1 updates weekly and can have overlapping/same data from week to week.
Sheet 2 is basically a running history of orders, where sheet 1 is the current order we have from week to week and some of these order can push over to the following week.
Currently i'm selecting the rows that are new orders and pasting them into sheet 2, I also need to add comments to the rows pasted in sheet 2 that need to stay with that row of information (this can take a lot of time out of my week just keeping sheet 2 up to date when new orders come in), Please help.

Example.xlam
	A	B	C	D	E	F	G	H	I	J	K	L
1	Release Date	Day	Primary Line	ID	Work Order	Sequence	Due Date	Parent Item	Description	Work Order Status	Component Status	Qty Ordered
2	28/12/2019	Saturday	2112	3356625	4060094	1	28/12/2019	113	DRUM STD	F	Planned Receipts	8850
3	28/12/2019	Saturday	908	3773716	11130348	2	28/12/2019	132	DRUM T&C	F	Planned Receipts	17750
4	28/12/2019	Saturday	1018	3467174	6280011	3	28/12/2019	115	DRUM PF	F	Planned Receipts	13867
5	28/12/2019	Saturday	2126|920	3393888	5090043	4	28/12/2019	107	DRUM GFG	F	Planned Receipts	13750
6	29/12/2019	Sunday	1003	3113210	10220236	1	29/12/2019	102	DRUM B	F	Planned Receipts	4009
7	29/12/2019	Sunday		3527133	7301371	2	29/12/2019	103	DRUM GA	F	Planned Receipts	2112
8	29/12/2019	Sunday	1009	3351287	4030128	3	29/12/2019	105	DRUM DGB	F	Planned Receipts	9150
9	29/12/2019	Sunday	1005	3334835	3260144	4	29/12/2019	113	DRUM STD	F	Planned Receipts	13275
10	30/12/2019	Monday	1014	3584930	8270009	1	30/12/2019	110	DRUM PG	F	Planned Receipts	4250
11	1/01/2020	Wednesday		3343323	3290051		5/01/2020	106	BAR G	F	No Status	2380
12	1/01/2020	Wednesday	2106|2105	3290844	2250282	1	1/01/2020	112	DRUM L	F	No Status	14400
13	1/01/2020	Wednesday	1016|1000	3581190	8261357	2	1/01/2020	101	DRUM BO	F	No Status	11850
14	1/01/2020	Wednesday	1023	3436980	6112059	3	1/01/2020	117	DRUM PC	F	No Status	3810
15	2/01/2020	Thursday		3380810	4300174		8/01/2020	102	BAR GFG	F	No Status	6000
16	2/01/2020	Thursday		3581341	8261508		4/01/2020	101	BAR BO	F	No Status	1390
17	2/01/2020	Thursday		3320137	3160055	1	2/01/2020	205	DRUMED G	F	No Status	3
18	2/01/2020	Thursday	1019	3467173	6280010	1	2/01/2020	115	DRUM PF	F	No Status	15657
19	2/01/2020	Thursday		3014714	8050058	1	3/01/2020	205	DRUMED G	F	No Status	3050
20	2/01/2020	Thursday	1081|1080	3533243	8010091	2	2/01/2020	124	DRUM M	F	No Status	19555
21	2/01/2020	Thursday	1017	3515549	7240050	3	2/01/2020	102	DRUM B	F	No Status	4009
22	3/01/2020	Friday		3544466	8070139		9/01/2020	107	BAR L STD	F	No Status	3625
23	3/01/2020	Friday		3581355	8261522		4/01/2020	112	BAR P	F	No Status	1100
24	3/01/2020	Friday		3669716	10040134		5/01/2020	110	BAR P	F	No Status	1360
25	4/01/2020	Saturday	2108|2107	3281273	2150052	1	4/01/2020	100	DRUM AC	F	No Status	5426
Sheet1

 

[CSmith]

So basically just merge the info in sheet 1 into sheet 2 without creating duplicates based on what criteria?

 

[Zeak]

So basically just merge the info in sheet 1 into sheet 2 without creating duplicates based on what criteria?

Sorry I'm not exactly sure what you mean by criteria, I guess the criteria is that only some of the columns from sheet 1 are required.

 

[CSmith]

So what items could be duplicate but not make a duplicate line item? Obviously Description can be the same for some items... What fields/columns must be unique to each row?

 

[Zeak]

So what items could be duplicate but not make a duplicate line item? Obviously Description can be the same for some items... What fields/columns must be unique to each row?

OK, now I gotcha. So the main difference between each row would be the ID column as each batch has a unique ID number. but the Release Date, Sequence, Parent Item and Qty Ordered can be the same.

 

[CSmith]

So just make sure no duplication batch ID correct?

 

[Zeak]

So just make sure no duplication batch ID correct?

Correct.

 

[Zeak]

So i'm guessing you're talking about the merge table wizard?? where I was looking for a macro to do this.
Also I forgot to mention that sheet1 one gets updated weekly from a CSV file.

I already have a macro button inplace to refresh the data in sheet 1 but I wanted to update/merge the data into sheet 2 at the same time. As I said earlier sheet 1 is a live/current view of orders and sheet 2 is a history log of orders. So when the data goes from sheet 1 to sheet 2 it needs to insert the new rows and not just shuffle the data down which causes the comments in the other column in sheet 2 to become unalign.

 

[CSmith]

Gotcha would appending to the bottom of current data on sheet 2 work?

 

[Zeak]

Gotcha would appending to the bottom of current data on sheet 2 work?

Is it possible to find where in the data on sheet 2 it should go and then insert it in between the rows it needs to, or would it just be a lot easier to go on the bottom?
Is there a command to sort the rows based on ID number, as this is a auto generated ascending number.