Populating current weeks scores via drop down name box

[Nattio]

Hi,

First off, I can not upload my file to show you so any help would be greatly appreciated.

then,

I need to be able to look up a person, and be able to look at any particular weeks performances via the drop down list in C1 (Name) and C19 (Week) on A Shift Profiles tab on the workbook that i have attached.

I currently have most of that working apart from the score for the particular week being dragged over.

In the Cell range C22:M22, on A Shift profiles the formula:-

Please Login or Register  to view this content.

only drags from cell C6 on Productivity Tracker sheet instead of looking up the Name in C1 on A Shift profiles, then looking up on Productivity Tracker and matching with those scores.

any help would be great.

Thanks.

[Haseeb Avarakkan]

Please attach a dummy file. Go to;

Go Advanced >> Manage Attachments.
Top right side, click Add Files.
Select file browse your file, then click
Upload files.
Then, on the right bottom side click Done.
Submit reply.

[Nattio]

It wont let me upload it.

I did this this:-

Go Advanced >> Manage Attachments.
Top right side, click Add Files.
Select file browse your file, then click
Upload files.

I press upload and the loading bar goes across, then just stops. I'm not able to drag the file into the bottom and even when i click done it tells me to add a file!!!