linking data from master sheet to other sheets

justjlc

New Member
Joined
Jan 15, 2004
Messages
3
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!
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,119
Messages
5,640,218
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top