PDA

View Full Version : compare two lists... and make changes



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

mdmackillop
11-02-2009, 06:29 AM
Please post a sample workbook with any code that you have.

AlexMason
11-02-2009, 06:41 AM
work book is attached, with the macros inside it