Cell look up problem

[simon frost]

Hi guys,

Forum newbie here... be gentle

Im a pretty decent user of Excel but for the life of me i cant work out the answer to this problem. Maybe some VBA code is needed but im not good at that at all !

I have 2 tables.

Set Up
Table 1 is a time sheet to show tasks done per project/job. It has columns for:

• Date
• Start Time
• Finish Time
• Hours Works (calculated cell)
• Task (a drop down list)
• Job number

There can be multiple entries on Table 1 for each project/job depending on what task/s are performed.

Table 2 table is to summarize the time spent on each different task per project. It has columns for:

• Job number
• *various columns for tasks like Site visit, email, drawing, Prep etc as shown in the drop down list in Table 1

The Problem
I am trying to get the Job number column in Table 2 to show a list of the Job numbers in Table 1 but each job number should only appear only once.

Hope you can help and sorry if i have not explained it very well.

Cheers

Simon

 

[JimM]

Sounds like the perfect scenario for a pivot table, suggest you try a Google search to get the feel of how they work and then post back here if you have specific issues

 

[simon frost]

Indeed it was.... thank you. I knew there had to be a simple solution.