Hello, I'm trying to make a macro for updating a source list. Sheet1 has a list of items with different attributes (attributes are listed in column B, separated by commas). All these attributes are also listed in column A on Sheet2, each unique attribute in its cell (for reference, as a "Glossary").
I want to have a macro which, when run, will analyze Sheet1 column B for attributes that are not listed in column A of Sheet2, add them to that column and paint them red.
I have come up with a code which does it, with attributes from column B of Sheet1 stored in an array. Array is temporary copied to column A of Sheet3 and used as a reference for pasting data into Sheet2.
The only problem I have is that the array is a loop and it copies only the last instance of the loop into Sheet3, overwriting all the previous loops.
Can someone help me deal with that?
See attached file (module 2, sub updt).
Here's the code:
*****issue resolved here: http://www.mrexcel.com/forum/excel-q...ay-column.html*****
Bookmarks