Hello,

i’ve currently got 2 lists : 

list 1 is a catalog of toolslist 2 is a the tracking of orders from the catalog

my aim is to declare that there has been an order in the the catalog (list 1) by putting a “Y” in a column and then running a macro that will add the new lines into the list 2 without deleting the old ones and the sorting by “internal ref”

both lists are in the same work book just different pages 

My main question is how can i update list 2 with out deleting the lines currently present, nor creating duplicates ?

i was thinking about going ahead this way :

1 – fetch last line of list 2

2 – copy/paste or advanced filter to fetch all the orders

3 – sort by internal ref

but that doesn’t solve the duplicate error … maybe it could be done with an “if”  or ticking “unique records only” in the advanced filter?

if this option was to complicated i was thinking of a “place order” form that would update list 1 and then add the affected lines to list 2 … the form would need to be able to place multiple orders at once

list 1 looks like this :

Tool nametool versionInternal refTool priceOdered by XOrdered by YZTool 1ATool 1_ind A99  Tool 1BTool 1_ind B56 YTool 1CTool 1_ind C7Y Tool 2ATool 2_ind A456YYtool 3Atool 3_ind A456YYTool 4ATool 4_ind A46Y                         

List 2 looks like (once filtered by internal ref):

Internal refTool nametool versionClientinternal priceinternal order dateinternal delivery datecommentsclient ship dateTool 1_ind BTool 1BY     Tool 1_ind CTool 1CX     Tool 2_ind ATool 2AX     Tool 2_ind ATool 2AY     tool 3_ind Atool 3AX     tool 3_ind Atool 3AY     Tool 4_ind ATool 4AX                                         

​Hello, i’ve currently got 2 lists : list 1 is a catalog of toolslist 2 is a the tracking of orders from the catalogmy aim is to declare that there has been an order in the the catalog (list 1) by putting a “Y” in a column and then running a macro that will add the new lines into the list 2 without deleting the old ones and the sorting by “internal ref” both lists are in the same work book just different pages  My main question is how can i update list 2 with out deleting the lines currently present, nor creating duplicates ? i was thinking about going ahead this way :1 – fetch last line of list 22 – copy/paste or advanced filter to fetch all the orders3 – sort by internal refbut that doesn’t solve the duplicate error … maybe it could be done with an “if”  or ticking “unique records only” in the advanced filter? if this option was to complicated i was thinking of a “place order” form that would update list 1 and then add the affected lines to list 2 … the form would need to be able to place multiple orders at once  list 1 looks like this :Tool nametool versionInternal refTool priceOdered by XOrdered by YZTool 1ATool 1_ind A99  Tool 1BTool 1_ind B56 YTool 1CTool 1_ind C7Y Tool 2ATool 2_ind A456YYtool 3Atool 3_ind A456YYTool 4ATool 4_ind A46Y                           List 2 looks like (once filtered by internal ref):Internal refTool nametool versionClientinternal priceinternal order dateinternal delivery datecommentsclient ship dateTool 1_ind BTool 1BY     Tool 1_ind CTool 1CX     Tool 2_ind ATool 2AX     Tool 2_ind ATool 2AY     tool 3_ind Atool 3AX     tool 3_ind Atool 3AY     Tool 4_ind ATool 4AX                                             Read More

​