Automatically copy and past and add to the record by one click

[alexchen]

Hi All masters

This is Alex, i don't have much experience in VBA, try to seek your advice with following question:
I am developing a charge rate calculator which allow me to select job, level and input the base pay rate, it will calculate the charge rate to client. What I need is once every thing is done, by clicking the Confirm button (form control) in Charge Rate calculator sheet, it will automatically copy and paste the job title, all charge rate into the Summary sheet as in the attached. And the user select another job title, and click confirm again, it will add to the next record in the summary sheet. It will keep adding until the "clear button" is click, which will clear all record in the summary sheet.

Would you know how to do it?

thanks

[alansidman]

See attached for the code necessary to make the buttons work. I presumed that you had the issue of the combo boxes under control and the development of the billing rates.

[alexchen]

Thanks a lot Alan. Yes, I have hidden other list of the combo box. Could you help me a further ?- say if the job title is already pasted, it will not pasted to the summary, i,e, no duplication?

thanks in advance,

ALEX

[alansidman]

Alex;
Change the code behind the confirm button to read:

Please Login or Register  to view this content.

[alexchen]

Thanks for the prompt response. The code works fine expect for I would like to copy and paste special the value of the selected cells. how can i change the codes?

Thank you

Alex

[alansidman]

Updated the code for you. I changed it slightly as I was getting a compile error on the vlookup line.

Please Login or Register  to view this content.

[alexchen]

Thanks Alan， it all works fine now, very appreciated.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.