copy details in sheet3,d8 into sheet1,e10. there are 48 sheet.

i do have 48 sheets, sheet1 named as RENAME.
the function of sheet1 is as a receipt. it will copy details from the layout onto selected sheet by clicking SIMPAN button.
it gonna copy details into selected sheet only.. after that gonna be reused for another transaction.
a sheet can be selected from sheet1,c10. example, im gonna put ST 842 T(the name of the third sheet) in sheet1,c10 (its a dropdown)

i want details from sheet3,d8 would be copied into sheet1,e10.

i already try to add new VBA as i want to be in the . but it seems frustrating me.

pls see the attachment and the VBA coding
the workbook is already coded.

You want to write of d8 of your selected sheet to e10 rite?
Try this code

Please Login or Register  to view this content.

Originally Posted by bheanloh

Apa Khabarr~ Try the attached workbook
Feel free to ask anything! Malaysia boleh~

hi, bheanloh

hebat!!! blh saya taw... VBA mana yng anda guna. saya da cuba bermacam2 tapi tak buleh juga.

Originally Posted by Sindhus

You want to write of d8 of your selected sheet to e10 rite?
Try this code

Please Login or Register  to view this content.

thanks dude... u people are so kind... helping each other

Thank you. If your problem is resolved, please make this thread as solved

where should i mark the thread as solve?