concatenate the currency too

isasa74 · #14 12-14-2015, 02:12 PM

Quote:

Originally Posted by charlesdh

Ok,

Now you lost me. I ran your code without the modification and ran the modified code. I compared the 2 runs and could not see a difference in the 2 runs.

I'm very sorry for the confusion, you don't see differences probably because you run it on the same raw data, try to modify one of the two sheets (better the sheet2) to create "discrepancies" on purpose.

My code in absence of the " V" concatenates the columns in Sheet2 and via index/match reports the concatenation to H in sheet1

Yours seems to concatenate the first six columns in sheet1 reporting them in H of the same sheet1

I have uploaded another file, this time you can start from the very raw data, please run the " prepare" button (sub_Main) to have the two sheets prepared for comparison and then the " run check".
you will notice that Sheet1 one is very different in the format before the preparation (currency for example are expressed with words USD/EUR rather than with symbols), that is because the two sheets are actually coming from different systems.

EDIT attached File was wrong , now attached the correct one sorry

hope this helps.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use Two (concatenate) Fields If Condition Is Met (If... Then... Else)	SoonerLater	Mail Merge	1	09-30-2015 05:40 PM
how to concatenate text box on new slide	wichitawx	PowerPoint	5	05-19-2015 05:17 AM
Concatenate with @ symbol	anickles	Excel	2	02-06-2015 09:39 AM
Concatenate if in descending order	pgeorgilas	Excel Programming	2	12-10-2014 01:35 AM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM