i have two sheets which contain 4 columns
order of columns in different order i need to compare the cost values and replace wit 1st sheet value
1 st sheet is
product catgory province cost
aa b c 5
f 10

vv zz 5

order of columns in 2nd sheet is
provinces product category cost
c aa b 5
zz aa vv 5





EggHeadCafe - Software Developer Portal of Choice
..NET Reflection - Copy Class Properties
http://www.eggheadcafe.com/tutorials...--copy-cl.aspx