LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 40
Default Extracting data into another worksheet

Let me try to explain
In work sheet called Sickhistory
I have columns A to P
In A3 down to A502 i have names
In B3 down to B502 i have Years
Then in columns C to O are columns that are recording data linked from other
sheets
In P3 down to P502 there are various different scores

What i want to be able to do is extract the top 10 scores data from Column P
including the name and years from columns A & B and then add them to a sheet
called Top 10 so that it is displayed something like this

Name Year score

I cannot use the filter button on worksheet Sickhistory as there are cells
of various sizes so it won't filter all the correct information

Any help with this would be extremely appreciated
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting data from large worksheet Louise Excel Worksheet Functions 4 April 27th 07 03:17 PM
Ignoring Rows When Extracting Data From One Worksheet To Another Jim J. Excel Worksheet Functions 2 May 8th 06 04:55 PM
Extracting data from one Worsheet to Another Worksheet with common link value Edwin Mashiringwani Excel Discussion (Misc queries) 1 November 25th 05 03:14 AM
Extracting data from a client worksheet to create an invoice Jacques E. Bouchard Excel Discussion (Misc queries) 1 May 8th 05 07:13 AM
Extracting worksheet names.... johnT Excel Worksheet Functions 5 April 4th 05 02:39 PM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"