Populate list based on dynamic range

[sarah04]

I have created a dynamic named range in the Variables sheet of the workbook listing employees and what their role is. The list is by department also, so there is two columns for each dept., ie:

Dept A Dept B
Employee ROLE Employee ROLE

I need these to populate in a different sheet like this:

Dept A
Employee ROLE weekly information
Employee ROLE weekly info

Dept B
Employee ROLE weekly info
Employee ROLE weekly info

The idea is that the fVariables sheet could be updated as staffing changes, and the other sheet would populate accordingly.

I am not sure if I needed the dynamic range on the variables sheet... it was just the best idea I had and didnt get me far.

So, help is appreciated!
Thanks

 

[sarah04]

Really? No one can help?

To clarify a little:

Using MS Excel 07
Variables sheet holds lists of employees by department coupled with their title in an adjacent cell.
I need this list to be dynamic (which I think i've done) so that I can add employees and remove employees as staffing changes are made.
I need this info on the Variables sheet to be the basis for another sheet involving hours and bill rates, arranged by row according to employee name.

department
name title hours worked bill rate etc.

name and title should populate/change based on the variables sheet?

can this be done??

Thanks

 

[Toonies]

Hi if you post an example of your present spreadsheet then others may have a better idea of what you actually are looking for.

use this

http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[sarah04]

Here is the way my data is set up in the Variables tab:

Excel Workbook
	A	B	C	D
1	Department A	Role	Department B	Role
2	Amy	Person 1	Andy	Person 1
3	Ben	Person 2	Beth	Person 2
4	Cindy	Person 3	Craig	Person 3
5	Dean	Person 4	Donna	Person 4
6	(new employee)
Sheet3

Here is how I need it to appear in the second sheet. The idea is that new rows would appear when new employees are added to the Variables sheet.

Excel Workbook
	L	M	N
2	Department A	Role	FTE
3	Amy	Person 1	10%
4	Ben	Person 2	80%
5	Cindy	Person 3	0%
6	Dean	Person 4	80%
7	(new employee)
8	Department B	Role	FTE
9	Andy	Person 1	100%
10	Beth	Person 2	100%
11	Craig	Person 3	100%
12	Donna	Person 4	100%
13	Department C	Role	FTE
14	Andy	Person 1	50%
15	Beth	Person 2	50%
16	Craig	Person 3	25%
17	Donna	Person 4	80%
Sheet3

I included a third column to show that I will be adding static (mostly) data next to these items in the second sheet.

hope that helps!