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