i want to ask how can i use macro to make one click button to transfer data to another form like payslip.. i manually copy paste the info needed from another worksheet to payslip tab... its the comission summary not actually a salary payslip
Could you please upload a sample of your work book showing how you would like it all to work. Show your inputs and expected results.
You can upload a sample of your work book to a free file sharing site such as DropBox, ge.tt or Sendspace then post the link to your file back here. We may then be able to better understand your requirements and offer some help.