not sure what i realy need..


sheet1
have column a row5 =team 1 row10=team 2 row15=team 3 etc
column b row5 =personA row6 =personB row7=personC row8 =personD
column c row5 =infoforA row6 =infoforB row7 =infoforC row8 =infoforD


sheet 2 the user need to select a dropdown or row etc for team 1 and get info for rows 5,6,7,8 only. select team 2 and get info for row 9,10,11,12 etc

can/will email example workbook

Hi Phillip,

Am Fri, 22 Feb 2019 07:35:28 -0800 (PST) schrieb Phillip Swanepoel:

sheet1
have column a row5 =team 1 row10=team 2 row15=team 3 etc
column b row5 =personA row6 =personB row7=personC row8 =personD
column c row5 =infoforA row6 =infoforB row7 =infoforC row8 =infoforD

sheet 2 the user need to select a dropdown or row etc for team 1 and get info for rows 5,6,7,8 only. select team 2 and get info for row 9,10,11,12 etc

I created some names for the ranges and 2 data validations.
Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeEyd20wBSXErMrtxQ


Regards
Claus B.
--
Windows10
Office 2016

hi...

thanx a lot... think we will get it done...

maybe i need to explain more clearer...

only need to select one team at a time... for example team 2

then second drop down must only let user choose between e,f,g,h


i need every person to have 3 info lines per person

so if user select g then i need c12 to display infog.1 and e12 display infog.2 and d18 to display infog.3

can i mail you a sample? http://edne.co.za/example.xlsx


regards



On Friday, February 22, 2019 at 5:35:37 PM UTC+2, Phillip Swanepoel wrote:
not sure what i realy need..


sheet1
have column a row5 =team 1 row10=team 2 row15=team 3 etc
column b row5 =personA row6 =personB row7=personC row8 =personD
column c row5 =infoforA row6 =infoforB row7 =infoforC row8 =infoforD


sheet 2 the user need to select a dropdown or row etc for team 1 and get info for rows 5,6,7,8 only. select team 2 and get info for row 9,10,11,12 etc

can/will email example workbook

Hi Phillip,

Am Fri, 22 Feb 2019 09:51:44 -0800 (PST) schrieb Phillip Swanepoel:

thanx a lot... think we will get it done...

maybe i need to explain more clearer...

only need to select one team at a time... for example team 2

then second drop down must only let user choose between e,f,g,h

i need every person to have 3 info lines per person

so if user select g then i need c12 to display infog.1 and e12 display infog.2 and d18 to display infog.3

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeEzF7KaFTz-OsTotw


Regards
Claus B.
--
Windows10
Office 2016

On Friday, February 22, 2019 at 8:51:53 PM UTC+2, Claus Busch wrote:
Hi Phillip,

Am Fri, 22 Feb 2019 09:51:44 -0800 (PST) schrieb Phillip Swanepoel:

thanx a lot... think we will get it done...

maybe i need to explain more clearer...

only need to select one team at a time... for example team 2

then second drop down must only let user choose between e,f,g,h

i need every person to have 3 info lines per person

so if user select g then i need c12 to display infog.1 and e12 display infog.2 and d18 to display infog.3

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeEzF7KaFTz-OsTotw


Regards
Claus B.
--
Windows10
Office 2016

Hi

Yes look good

Thank you!!!

good morning

have another version in the same style. was thinking i will see the way you did the one. and then adapt. but i am not there yet..

please can you help with the second one?

select statement and select team member. then display the info on the left acording to the selected info..

edne.co.za/team.xlsx

regards and thank you



On Friday, February 22, 2019 at 8:51:53 PM UTC+2, Claus Busch wrote:
Hi Phillip,

Am Fri, 22 Feb 2019 09:51:44 -0800 (PST) schrieb Phillip Swanepoel:

thanx a lot... think we will get it done...

maybe i need to explain more clearer...

only need to select one team at a time... for example team 2

then second drop down must only let user choose between e,f,g,h

i need every person to have 3 info lines per person

so if user select g then i need c12 to display infog.1 and e12 display infog.2 and d18 to display infog.3

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgeEzF7KaFTz-OsTotw


Regards
Claus B.
--
Windows10
Office 2016

Hi Phillip,

Am Fri, 22 Feb 2019 22:20:21 -0800 (PST) schrieb Phillip Swanepoel:

select statement and select team member. then display the info on the left acording to the selected info..

edne.co.za/team.xlsx

download the file from he
https://1drv.ms/x/s!AqMiGBK2qniTgeE1psys_3OkyDWARg

The formulas in the info box are array formulas. They must be inserted
with CTRL+Shift+Enter.


Regards
Claus B.
--
Windows10
Office 2016

i am so so sorry.. i uploaded wrong file... (very similar though the correct sample is available now.... (standing red faced and apologetic)

edne.co.za/team.xlsx

thanx a million


On Saturday, February 23, 2019 at 9:47:57 AM UTC+2, Claus Busch wrote:
Hi Phillip,

Am Fri, 22 Feb 2019 22:20:21 -0800 (PST) schrieb Phillip Swanepoel:

select statement and select team member. then display the info on the left acording to the selected info..

edne.co.za/team.xlsx

download the file from he
https://1drv.ms/x/s!AqMiGBK2qniTgeE1psys_3OkyDWARg

The formulas in the info box are array formulas. They must be inserted
with CTRL+Shift+Enter.


Regards
Claus B.
--
Windows10
Office 2016