Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 19th 05, 09:40 PM
macquarl
 
Posts: n/a
Default Creating seperate sheet lists from larger list


I have a list the is in one sheet - this list contains names and
departments and then the data that I seek.

Currently there are seperate lists on different "department" sheets
that break down the people that are on the complete list so that
department managers can click on their sheet and just view their data.
This is all done manually.

The problem: With turnaround (hiring, firing, dpeartment moves, etc)
these sheets are becoming a nightmare to maintain.

The question: Is there a formula that I can use that will use the main
listing as a starting point that will filter the other sheets based on
the department listed in column B so that column A and Column C (the
data) will appear in the various department sheets?

Any help would be greatly appreciated.


--
macquarl
------------------------------------------------------------------------
macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388
View this thread: http://www.excelforum.com/showthread...hreadid=477665


  #2   Report Post  
Old October 19th 05, 10:17 PM
Ron de Bruin
 
Posts: n/a
Default Creating seperate sheet lists from larger list

Hi macquarl

You can try this
http://www.rondebruin.nl/copy5.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"macquarl" wrote in message
...

I have a list the is in one sheet - this list contains names and
departments and then the data that I seek.

Currently there are seperate lists on different "department" sheets
that break down the people that are on the complete list so that
department managers can click on their sheet and just view their data.
This is all done manually.

The problem: With turnaround (hiring, firing, dpeartment moves, etc)
these sheets are becoming a nightmare to maintain.

The question: Is there a formula that I can use that will use the main
listing as a starting point that will filter the other sheets based on
the department listed in column B so that column A and Column C (the
data) will appear in the various department sheets?

Any help would be greatly appreciated.


--
macquarl
------------------------------------------------------------------------
macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388
View this thread: http://www.excelforum.com/showthread...hreadid=477665





Reply
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
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Creating a dynamic list Jarrod A Excel Worksheet Functions 1 November 18th 05 11:29 PM
Update master list with other lists Chab Excel Worksheet Functions 0 August 4th 05 03:46 PM
Creating Drop Down boxes with the List function... JeanneW Excel Discussion (Misc queries) 3 June 1st 05 02:59 PM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 09:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017