lienlee
06-30-2011, 08:08 AM
Morning Everyone :hi:
I require some assistance with comparing columns and creating a checklist to confirm.
I want to have Column A as a check list to mark off all the compared columns to confirm it's good, so X for compare is correct.
For clarification i want compare column B and C, D and E, F and G, and so on. I may need more columns to compare also, but i can reuse the prior the code above
But when they do the compare for each two comparison, B and C vs D and E - if both are correct i need column A to have an X to show all the compares are matching. I've attached an excel document of the desired output.
If possible I need a macro to do this.
Your help is really appricated and thank you for your assistance on this matter. Vbaexpress forum is probably the best place to learn new stuff.
I require some assistance with comparing columns and creating a checklist to confirm.
I want to have Column A as a check list to mark off all the compared columns to confirm it's good, so X for compare is correct.
For clarification i want compare column B and C, D and E, F and G, and so on. I may need more columns to compare also, but i can reuse the prior the code above
But when they do the compare for each two comparison, B and C vs D and E - if both are correct i need column A to have an X to show all the compares are matching. I've attached an excel document of the desired output.
If possible I need a macro to do this.
Your help is really appricated and thank you for your assistance on this matter. Vbaexpress forum is probably the best place to learn new stuff.