Help! Need Vba for transfering data from purchase order to another Worksheet

[bossrockzz]

Hi , I have purchase order format . When my company staff request for purchase order . I create a purchase order in excel . I want the data entered in my purchase order to be stored in another workbook which acts like database for future reference . I got a code from net but it enteres only one cell value . For example i have items from D12 to D34 but it works only for one cell (D12)

Please Login or Register  to view this content.

Purchase order1.xlsm is the format and Purchaseorder_database.xlsm is the file which will store the purchase order . PLease help me with this code or if you can create me a code .

[JOHN H. DAVIS]

Based on your samples, maybe:

Please Login or Register  to view this content.

[PCI]

bossrockzz,
I have some experience with such form and data base to build and I would suggest:
- to give some names to cells in the form and in the database header.
- to put the macro in the database and not in the form
If you agree, just tell it, meanwhile I will investigate your need.
PCI

[PCI]

Here my suggestion

Please Login or Register  to view this content.

[jolivanes]

Something to play with.

The numbering in Column C needs to be in sequence starting at 1 (one) in Cell C12. (As in your example)
The PurchaseOrder_Database Workbook has to be open.
Code is run from the Purchase Order Workbook.

Please Login or Register  to view this content.

[bossrockzz]

Thank you so much brothers . Its working . You guys are really awesome