Hi all,
I am hoping y'all can help me with something. I have several large (big enough to not make it practical to combine them) workbooks in 1 folder on a shared server.
I have created a seperate workbook to pull data from these workbooks based on a "customer number" criteria. What i would like to happen, is to type in this reference number and based on a key have the data for that particular customer draw from the various sheets.
IE:
Agent Workbook 1
Customer A
Customer B
Customer C
Agent Workbook 2
Customer D
Customer E
Customer F
Can i use vlookup (open to other suggestions) to input "Customer A" and it knows to reference Agent Workbook 1. Each of the agent workbooks are identical in formatting, i just need some help with the sheet knowing it needs to change Agent Workbooks based on the Customer
Thanks for any help yall can provide!
-J
I am hoping y'all can help me with something. I have several large (big enough to not make it practical to combine them) workbooks in 1 folder on a shared server.
I have created a seperate workbook to pull data from these workbooks based on a "customer number" criteria. What i would like to happen, is to type in this reference number and based on a key have the data for that particular customer draw from the various sheets.
IE:
Agent Workbook 1
Customer A
Customer B
Customer C
Agent Workbook 2
Customer D
Customer E
Customer F
Can i use vlookup (open to other suggestions) to input "Customer A" and it knows to reference Agent Workbook 1. Each of the agent workbooks are identical in formatting, i just need some help with the sheet knowing it needs to change Agent Workbooks based on the Customer
Thanks for any help yall can provide!
-J