yourtwizted
New Member
- Joined
- Feb 7, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
- MacOS
Hey guys,
So i have this reporting tool that only shows employees by supervisors and currently is not able to separate them by the LOB they are actually in
I am currently just looking for any way to organize or sort the RawData out and onto different sheets.
Unfortunately my company does not allow me to get to this site so i am on here trying to do this on my own time
the Raw Data gives the following information from Left to Right
Column A Column B Column C
Row 1 Employee Name Supervisor Name Aux Data
Row 2 jon a jon b hold
Row 3 larry a larry b on call
Row 4 ben a ben b ready
I have a list of supervisors for each LOB my goal is to have the raw data on 1 sheet, and for each LOB i would like to have 1 sheet dedicated to pulling data for only 1 LOB. Currently there are 3 LOB's and with potential for more to come in. currently the RawData pulls about 300 employees
Any ideas on how i can get this done? Pivot Table? VBA? Formulas?
So i have this reporting tool that only shows employees by supervisors and currently is not able to separate them by the LOB they are actually in
I am currently just looking for any way to organize or sort the RawData out and onto different sheets.
Unfortunately my company does not allow me to get to this site so i am on here trying to do this on my own time
the Raw Data gives the following information from Left to Right
Column A Column B Column C
Row 1 Employee Name Supervisor Name Aux Data
Row 2 jon a jon b hold
Row 3 larry a larry b on call
Row 4 ben a ben b ready
I have a list of supervisors for each LOB my goal is to have the raw data on 1 sheet, and for each LOB i would like to have 1 sheet dedicated to pulling data for only 1 LOB. Currently there are 3 LOB's and with potential for more to come in. currently the RawData pulls about 300 employees
Any ideas on how i can get this done? Pivot Table? VBA? Formulas?