AlexMason
11-02-2009, 02:59 AM
heres what i would like to try and do
i have 2 lists. A master parts list and an updated parts list.
i want to compare the two lists (which are in the same workbook on different sheets)
what needs to happen is this
1) matching parts need to be updated, but only if they have not been checked as recieved on the master list. i have already got code to do this
2) any new unique parts that are in the update list need to be merged over to the master list, just put them at the bottom of the list
3) any parts in the master list that now dont appear in the update list now need to be removed from the master list. or better still, marked as "omitted" or something
any help will be much appreciated
thanks
alex
i have 2 lists. A master parts list and an updated parts list.
i want to compare the two lists (which are in the same workbook on different sheets)
what needs to happen is this
1) matching parts need to be updated, but only if they have not been checked as recieved on the master list. i have already got code to do this
2) any new unique parts that are in the update list need to be merged over to the master list, just put them at the bottom of the list
3) any parts in the master list that now dont appear in the update list now need to be removed from the master list. or better still, marked as "omitted" or something
any help will be much appreciated
thanks
alex