excel vba - VBA BUTTON to copy from one workbook to another -

excel vba - VBA BUTTON to copy from one workbook to another -

and need help accomplish specific re-create , paste. have active client list updating. , when work finish have prepare invoice. trying no success create button on active costumer workbook re-create client name select maybe highlighting cell in column c, transfer name template named invoice in cell b3. template set vlookup , if function populate info based on client name. want button re-create cell select not whole column or row. code possible?

both these suggestions assume in client workbook/sheet cell selected ... button code this:

sub copy_cust() workbooks("invoice").sheets("sheet1").range("b1") = activecell end sub

or

sub copy_cust2() selection.copy workbooks("invoice").sheets("sheet1").range("b1").pastespecial application.cutcopymode = false end sub

excel-vba excel-formula buttonclick commandbutton