Pulling selected date from one sheet to another

[Walkol]

*data* - good start!

Hi Everyone,

My apologies if this has been answered already - but ive had a good search now and haven't seem to find anything that can help.

Im working on Excel 2010.

What i'm trying to do, is keep an ongoing 'master' sheet where I enter certain information like Name, Role, Month, Hours, Project and so forth - which will be updated on a monthly basis manually.

From this, I want to pull parts of this data into a seperate sheet (same workbook). So, I would have a worksheet for each project for example. Once I updated the master sheet with new hours on a specific project - all rows from the master sheet would be automatically pulled into that sheet with the rest of the revelant information (name, role, month, hours etc etc).

I would also have sheets for each 'name', so again once I have updated the master sheet, all of the information regarding to a specific person would be pulled into their own specific spreadsheet.

Is this even possible?

Hopefully I have explained what im trying to do well, if not please let me know.

Thanks all!

[arlu1201]

Yes this is very much doable. Please post a sample workbook and the details on what needs to go where.

[Walkol]

Hi there,

Please see attached example. So each of the sheets would pull all the data connected to that descriptor.

So for example, on the 13874 sheet it would pull through all the information lines 3 and 6.

Thanks!

[Herman Merman]

Do they have to go into a separate worksheet? Seems to me you can have a report which has a drop down list to view the relevant data for each category (Project, Employee etc). That way you only need to have one data worksheet plus a report worksheet. If you do need to extract to a separate worksheet this is also possible but just wanted to check.

[Walkol]

Unfortunately they need to be on seperate sheets, as each variable to need be analyised further differently,

ie - a sheet regarding a project with be further analysied differently than a sheet regarding a specific month.

I've tried simply linking sheets back to the master sheet, but due to the amount of data this makes everything work really slowly, so much so its unworkable. I have also tried pivot tables but they dont quite fit what im after.

[veejar]

hi Walkol,

I think Pivot Table should be the answer to your problem. However, Please do remember that you can create a pivot table only when there is no break in data rows or columns. for example in your sample sheet row 2 is empty and then data is presented, delete this row 2 and try pivot table with project and month as column and value field settings as sum of hours or whatever is appropriate and rest of the headers as row headers.

Regards,

Veejar