Help Required

[Burrelly]

I am writing a script to help me manage use of a tool. I have done all the basic functions that pull data from different worksheets.

I am having a problem pulling data in a certain way. I have attached the spreadsheet so someone may be able to help me.

What I need is the data from the Use Report to be pulled to the Team Data sheet.

There is a section for data to show the number of sessions of the tool per person. I need the number of time the people names appears in the use report to show in the column number of sessions.

Any help would be great.

[Carim]

Hi,

I understand your goal ..but what is the common field (the one which will allow the link) between Team Data and Use Report ... ?

HTH
Carim

[Burrelly]

This is the problem I am having, the data in the file is pulled directly from a report.

The only constant there is the 5 digit number next to each persons name.

I used the following code to extract it from the full name

=RIGHT(LEFT(**cell**,12),5) would extract 19867 from REP ID 19867 LYALL DBS 05 this is the dellserv id. a constant in the team data worksheet.

Dave

[Carim]

Dave,

It is funny but my attempt has been the same as yours ...
by the way formula to extract is

=MID('Use Report'!K2,FIND("ID",'Use Report'!K2,1)+2,6)

But none of these codes find a match in the Team Data sheet ... so ...
I do not know how to progress ...

HTH
Carim

[Burrelly]

What if we put another column in the use report to pull the id from the name then do the search from there?

[Carim]

Sorry Dave,

for not being clear ...
that is exactly what I have already done ...
BUT
there is not a single match between the two worksheets ...
so there is at this stage no interest at all ...

question :
what do you want to do next ... ???

Carim