Help Required

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.

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

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

Dave,

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

Please Login or Register  to view this content.

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

HTH
Carim

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

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

Ok I think we are getting a little confused.

The first column ID doesent really mean anything at all within the spreadsheet. What i think is if we add another column to the use report sheet thar pulls the 5 digit id from column K.

The 5 digit id contained in column K is the same in column C of the Team Data sheet.

There are a combination of dat form over 250 users in the use report sheet but i only want to pull the data for some of the users the ones in the team data sheer.

Dave ...

Sorry again ...
But I fully understand what you are saying and that's exactly what I have done ... !!!
Now the result of this process is ...
Not a single match ...i.e. not a single 5 digit number corresponds to any 5 digit number of the Team Data ... nor, by the way, to any 5 digit number of the Users List ...(which is worrying ...) no ?

Are we on the same wave lenght ?

Carim

I just did a quick search and the dellserv id for Neil Douglas 31784 is in the use report - cell K13

OK ...

Cells were not formatted as numbers but as text ...

In the Use Report, you can use the L column and type ...

Please Login or Register  to view this content.

In the Team Data, you can have column K as helper with ...

Please Login or Register  to view this content.

HTH
Carim

Hello again,

Attached is your file with the number of sessions ...

HTH
Carim

Thanks that is working great!

Cheers

Glad your problem is fixed.

Thanks a lot for the feedback

Carim

Going Through This Thread I Got Some Great Ideas
For My Work Book Thanks Again