Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to transfer data from one workbook to another with VB
here is the scenario;
I have a blank master invoice file which is opened and filled filled out when a customer makes a purchase. things like customer name information, product information, prices and totals. I have an existing command on the worksheet button that prints and saves the file. what i want to do is add to that command button VB code which will gather customer information, tax, subtotals and add that to a master ledger sheet in a seperate workbook at the next availible row starting in column A. i have some glimmerings on where to start but not enough to get going. anyone got an idea how to make this work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer data from a cell to another workbook if certain criteria | Excel Worksheet Functions | |||
How to transfer data from one workbook to another via VBA | Excel Discussion (Misc queries) | |||
Transfer data from one workbook to another workbook based on a key | Excel Programming | |||
Transfer data from one workbook to a form in another workbook | Excel Programming | |||
Data transfer from a template to a workbook | Excel Worksheet Functions |