Clare Cameron
New Member
Hey good evening, I am new to the forum and looking for a little help please.
I'm not sure how to properly explain what I'm trying to do but I'll give it a go.
I have a tab on the sheet for new people joining our business (Onboarding Tab) , each person joining is allocated a customer ID number, the person who introduced them also has a customer ID number.
Each person who is introducing new people to the business has their own tab where I list the people that have introduced (Ambassador Tabs)
Is it possible to add an index function to the ambassador tab which will pull a list of the new people from the onboarding tab onto the relevant ambassador tab?
I found a instruction that seems like almost what I need here but only seems to work if you are working on one tab.
Example: Jane Brown is an Ambassador and has her own tab called Jane Brown which has her own customer number (which is 43) in cell A1. Collumn B in her tab will list the customer numbers of her new recruits.
Jane Brown introduces three new recruits, Jemma Ball customer number 171, Barry James customer number 175 and Sammy David customer number 179.
The new recruits are inputted into the onboarding tab with the customer numbers in collumn A.
I'm not sure how to properly explain what I'm trying to do but I'll give it a go.
I have a tab on the sheet for new people joining our business (Onboarding Tab) , each person joining is allocated a customer ID number, the person who introduced them also has a customer ID number.
Each person who is introducing new people to the business has their own tab where I list the people that have introduced (Ambassador Tabs)
Is it possible to add an index function to the ambassador tab which will pull a list of the new people from the onboarding tab onto the relevant ambassador tab?
I found a instruction that seems like almost what I need here but only seems to work if you are working on one tab.
Example: Jane Brown is an Ambassador and has her own tab called Jane Brown which has her own customer number (which is 43) in cell A1. Collumn B in her tab will list the customer numbers of her new recruits.
Jane Brown introduces three new recruits, Jemma Ball customer number 171, Barry James customer number 175 and Sammy David customer number 179.
The new recruits are inputted into the onboarding tab with the customer numbers in collumn A.
