-
Sleeper: Compare two lists... and make changes
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
-
Please post a sample workbook with any code that you have.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
work book is attached, with the macros inside it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules