Hello...I am a novice coder when it comes to Excel. I have looked into the issue, but am unable to find the logic..if it exists for what I want to do.
I have have found bits and pieces that seem to be what i want - vlookup, match, offset, do while, etc....but nothing exact.
I am using Excel 2003 on Windows XP.
I have a cell that contains data like "group_a;group_b;group_c"....I need to loop through this cell with a master list to verify if anyone has added a group or misspelled a group.
Unfortunately, the cell is in a template that has to stay in this format, but I would like to validate the data before its imported into another system.
Any thoughts would be appreciated.
Thanks.
I have have found bits and pieces that seem to be what i want - vlookup, match, offset, do while, etc....but nothing exact.
I am using Excel 2003 on Windows XP.
I have a cell that contains data like "group_a;group_b;group_c"....I need to loop through this cell with a master list to verify if anyone has added a group or misspelled a group.
Unfortunately, the cell is in a template that has to stay in this format, but I would like to validate the data before its imported into another system.
Any thoughts would be appreciated.
Thanks.