I have 3 workbooks.  One called PO number system and one for each project manager.

Workbook 1 – PO Number system

Workbook 2 – Marc

Workbook 3 – Kyle

On the PO Number System, Column A is dropdown for project manager name.

Column B is PO number (generated from formula tied to Customer List in same workbook)

I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column.  If it doesn’t say Marc’s name, then nothing happens to his spreadsheet.  If A2 says Kyle, then everything should fill in on Kyle’s workbook.

Spreadsheets attached for reference.

​I have 3 workbooks.  One called PO number system and one for each project manager.Workbook 1 – PO Number systemWorkbook 2 – MarcWorkbook 3 – KyleOn the PO Number System, Column A is dropdown for project manager name.Column B is PO number (generated from formula tied to Customer List in same workbook)I want the project manager to be able to fill in the remainder of the columns (C-K) and it automatically fill in on their corresponding workbook – if Column A2 on PO Number System Workbook says Marc, then I want Marc’s workbook to automatically fill in everything associated with that line 2 from the PO Number System Column.  If it doesn’t say Marc’s name, then nothing happens to his spreadsheet.  If A2 says Kyle, then everything should fill in on Kyle’s workbook.Spreadsheets attached for reference.  Read More

​