pranav
08-21-2013, 06:38 AM
Hello n thanks,
i have a sheets with data
DATA
jan feb mar
provisional real real provisonal real real
cca 123 455 455 344 466
dde 445 455 445 555 65
eer 333 333 445 6666 56 78
rrr 544 34r 455 543 56 556
ffr 455 454 1111 455 22 76
now i want a result
cca provisional 123 344
cca real 455 445 466
dde provisional 445 555
dde real 455 445 65
eer provisional 333 6666
eer real 333 445 56 78 (as real is two times)
rrr provisional 544 543
rrr real 34r 455 56 556
can sum one please help me i want a vba code for the button on the sheet 1 and gives result on sheet 2 .....
Thanks in advance
i have a sheets with data
DATA
jan feb mar
provisional real real provisonal real real
cca 123 455 455 344 466
dde 445 455 445 555 65
eer 333 333 445 6666 56 78
rrr 544 34r 455 543 56 556
ffr 455 454 1111 455 22 76
now i want a result
cca provisional 123 344
cca real 455 445 466
dde provisional 445 555
dde real 455 445 65
eer provisional 333 6666
eer real 333 445 56 78 (as real is two times)
rrr provisional 544 543
rrr real 34r 455 56 556
can sum one please help me i want a vba code for the button on the sheet 1 and gives result on sheet 2 .....
Thanks in advance