linking data from master sheet to other sheets

[justjlc]

I have a workbook which I enter data into, to be credited to different members of the group.

DATA on the 'MASTER' sheet

# close project
of surveys date name score avg ID
2 1\1\04 a 20 5 A
1\1\04 a 17 4 A
2 1\2\04 b 16 4 B
1\3\04 b 20 5 B


Using the preview I see that I can't format the data for you to look at. The data includes number of surveys, close date,project name, score, average and ID.
I would like to do two things. I would like to copy the entire record for each different ID to a page for each different ID. I would like to accumlate each ID's records on a separate page.

Also, I will need to calculate with the data that I copy. Or do I need to just leave the data on the 'Master' sheet and just do calculations on the separate sheets.

I hope I have provided clear information!

 

[BrianB]

Looks like your data is set up in a simple table - which is the best way possible to use the powerful Excel database functions.

Without knowing exactly what you need, I suggest 2 possble methods :-

1. Try Data/Filter/autofilter. You can choose an ID at the top to display all records for it, and copy/paste to another sheet.

2. Try setting up a pivot table. You can doubleclick a value cell in the PT to get all the records that make up that total put into another sheet. You can also link to the PT (if you have summary totals) using the Excel =VLOOKUP() function.

Having decided how to do the the job manually, you could record a macro of the process.

 

[justjlc]

Just wanted to says THANKS!!! I'll give it a try