View Single Post
  #2   Report Post  
Old February 22nd 19, 06:33 PM posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,647
Default populate or summarize data

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