Forum Discussion

marietuttle1973's avatar
marietuttle1973
Copper Contributor
Aug 05, 2024

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.

Resources