Generate rows based on data in another worksheet

sarah04

New Member
Joined
May 12, 2011
Messages
14
I am an Excel noob and have been given a project in excel .... one thing I am struggling with is how to have a list of current employees populate in (for example) Sheet A based on a dynamic list from Sheet B.

so, this is what Sheet A would look like:

<employee 1, group A> <title> <other data>
<employee 2, group A> <title> <other data>
<employee 3, group A> <title> <other data>
<employee 1, group B><title> <other data>
<employee 2, group B> <title> <other data>
<employee 3, group B> <title> <other data>
<employee 1, group C> <title> <other data>
<employee 2, group C> <title> <other data>
<employee 1, group D> <title> <other data>
<employee 2, group D> <title> <other data>

and Sheet B:
<Group A> <Group B> <Group C> etc
<employee 1><title> <employee 1><title> <employee 1><title>
<employee 2><title> <employee 2><title> <employee 2><title>
<employee 3><title> <employee 3><title> <employee 3><title>

if I added a third employee to sheet B (in red, above), I need sheet A to automatically insert a row beneath <employee 2, group C><title><other data>

I have looked at naming a range/dynamic ranges but I'm not understanding exactly how to do them or if naming a range would solve this problem.

Hoping that makes sense - thanks in advance for the help!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
I'm sorry, I'm not sure why the rest of my message isn't showing up.

Sheet A is something like:

Group A
employee 1, title
e2, t
e3, t
GroupB
e1, t
e2, t
Group C
e1, t
e2, t
e3, t

and sheet B would be

Group A Group B Group C
list name, list title etc etc
etc etc etc

If I enter a new employee into Group B on Sheet B, I would like sheet A to insert a row for a third employee in group B.

I have looked at naming ranges and dynamic ranges but am not understanding the instructions, nor am I certain these will work to fix this problem.

Thanks for the help!
 
Upvote 0

Forum statistics

Threads
1,224,600
Messages
6,179,834
Members
452,947
Latest member
Gerry_F

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
Back
Top