Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Need some help with a Macro
Here's my problem, I have two work sheets. One is the following:
MainID; ID2; ID3; ID4; Date; Date2; UpdatedBy
Currently looks something like this (data that is)
1910; 153; 153; 11; 10/12/2010 15:52; 10/18/2010 15:51; 367
1912; 201; 201; 13; 12/24/2011 12:31; 12/31/2011 18:21; 213
The issue is that we are updating the MainID to a new set of ID's. It is NOT a 1:1 ration so I can't just do a vlookup. My Second Worksheet is as follows:
NewID is currently a list of the different NewID's broken out by Commas. it looks something like this:
In some cases, the old MainID may no longer even exist and in those cases I wouldn't want it to show.
Based on the data above, I would expect the end result to be:
2191; 153; 153; 11; 10/12/2010 15:52; 10/18/2010 15:51; 367
2189; 201; 201; 13; 12/24/2011 12:31; 12/31/2011 18:21; 213
2190; 201; 201; 13; 12/24/2011 12:31; 12/31/2011 18:21; 213
2191; 201; 201; 13; 12/24/2011 12:31; 12/31/2011 18:21; 213
Notice all of the columns past the first are just copies, and rows went from 2 to 4 since the second set of data (1912) has 3 different entries.
I can reformat the second column (i.e. NewID) any way necessary, I'm just stating how it currently is.
I tend to be very generous when it comes to saving me time!! Just let me know your email address and I will send cash via Paypal if the function does what I need it to!