V
vimalg vimalg
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/tutorial...d78-ff541dfbcb56/net-reflection--copy-cl.aspx
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/tutorial...d78-ff541dfbcb56/net-reflection--copy-cl.aspx