I need one workbook page to feed selected data to others!

[Rich19041980]

Hi,

I have been asked to design a simple timesheet entry system for how we spend our time on clients.

It has been requested that on sheet one that we are able to select a client name or code from a dropdown box, enter our start and finish times, and an optional note.

We need it to then automatically pull that data to the correct corresponding sheet for that client, so we can subtotal monthly how much time we have spent on them.

I have attached the bare bones of what we have so far, I hope someone can help!

[DBY]

Hello
Perhaps an easier solution than creating sheets for each client would be to have a single entry table and then a pivot table to analyze the data for each client, or do you have to have your current layout?

[Rich19041980]

Not necessarily, if a pivot table would easily show how many hours by client

[DBY]

Okay, I'll upload an example for you to consider. Give me a few minutes.

[DBY]

What version of Excel are you using?

[Rich19041980]

Excel 2010 currently

[DBY]

Here's an example Pivot table option.

[shukla.ankur281190]

Please check the attached file hope this will help you.

[Rich19041980]

Many thanks! Just need to get a list of our clients as a drop down box now and im away!

Many thanks