Forum Discussion
Formulas across multiple workbooks
I have 3 Excel Workbooks
One called PO Number System
One called Marc
One called Kyle
The workbook called PO Number System has 2 sheets, one called customer list and one called PO. There is an existing formula in the sheet called PO (column B) that will automatically assign a PO number once the Customer name is filled in. We will then manually enter the remainder of the info on this sheet.
What I would like is to be able to enter the information on the PO Sheet of the PO Number System Workbook and for that information to copy over to the individual salesman’s workbooks called Marc and Kyle. This is indicated by the first column of the PO Number System. The Marc and Kyle workbooks have lots of other information on them, but the columns from the PO number workbook I would like to automatically populate once filled in. The key to all of this is that the PO number and formula transfer as well. Therefore, if Marc and Kyle both have a customer name Kroger, the system doesn’t assign them the same PO number just because they are in 2 different worksheets.
- peiyezhuBronze ContributorTherefore, if Marc and Kyle both have a customer name Kroger, the system doesn’t assign them the same PO number
If multiple users share data,web plus database may have better performance than spreadsheet.