Hi
Is it possible someone can help with this:
I have a spreadsheet called MIS-New
I want a macro to compare all the data row by row on it to each of the other spreadsheets named P* and Ante*
If there are entries in the MIS-New and not in the P* and Ante* I want them added to the spreadsheet that is listed in each rows
I have attached a Demo to help
Another use of the dictionary - double this time:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi
When I run this it is copying all the data into every sheet, it is not comparing Column F (reg Class) in MIS_New with the sheet name and only pasting those that it cannot find that match the same Class name.
So If there is Joe Bloggs Pr2, it will not add it to Pr1. Equally if Joe Smith, Pr3, is already in the Pr sheet it will ignore it.
Last edited by Newbuilder; 09-13-2017 at 05:25 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks