You are viewing our Forum Archives. To view or take place in current topics click here.
Any Excel Wizards Around??
Posted:
Any Excel Wizards Around??Posted:
Status: Offline
Joined: Jun 25, 20159Year Member
Posts: 993
Reputation Power: 109
Status: Offline
Joined: Jun 25, 20159Year Member
Posts: 993
Reputation Power: 109
Hey guys hopefully someone out there can help and explain something for me.
Basically I have a weekly report sheet from work with all colleagues and their performances.
I am wanting to pull the information from there (which will be in the first sheet) and put into a sheet to correspond to the department they work in (sheet 2)
I then want those results to be compared to a separate sheet that will hold actual targets (sheet 3) and turn the background green or red accordingly.
The report shows around 40 colleagues and around 20 results per colleague.
There are also 4 departments to split them into.
I was using VLOOKUP to grab the Colleagues data (as each colleague has an individual number identifier)
When trying to then match that lookup with the targets page is where I fall short.
Basically I have a weekly report sheet from work with all colleagues and their performances.
I am wanting to pull the information from there (which will be in the first sheet) and put into a sheet to correspond to the department they work in (sheet 2)
I then want those results to be compared to a separate sheet that will hold actual targets (sheet 3) and turn the background green or red accordingly.
The report shows around 40 colleagues and around 20 results per colleague.
There are also 4 departments to split them into.
I was using VLOOKUP to grab the Colleagues data (as each colleague has an individual number identifier)
When trying to then match that lookup with the targets page is where I fall short.
#2. Posted:
Status: Offline
Joined: Aug 19, 201014Year Member
Posts: 5,243
Reputation Power: 532
Status: Offline
Joined: Aug 19, 201014Year Member
Posts: 5,243
Reputation Power: 532
If you've got the data on another sheet, you can use sheetname!cell_id to reference a particular cell.
E.g. if I have sheet 1 called "Names" and I want cell B4, I would use Names!B4 to grab that cell data.
E.g. if I have sheet 1 called "Names" and I want cell B4, I would use Names!B4 to grab that cell data.
- 0useful
- 0not useful
You are viewing our Forum Archives. To view or take place in current topics click here.