PDA

View Full Version : help to Write a code to put value copy two tyms and columb values to row



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

SamT
08-21-2013, 08:37 AM
Please upload workbook with two sheets: One as original and one as desired.

Go Advanced and Manage Attachments.

pranav
08-22-2013, 01:02 AM
Please upload workbook with two sheets: One as original and one as desired.

Go Advanced and Manage Attachments.

thank you for response i have attached sheet with data which starts at row 41 and a button and i hav shown the result the way i would like to on the Result sheet.


thanks