Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 19, 03:35 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data

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

  #2   Report Post  
Old February 22nd 19, 05:33 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,661
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
  #3   Report Post  
Old February 22nd 19, 05:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data

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


  #4   Report Post  
Old February 22nd 19, 06:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,661
Default populate or summarize data

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
  #5   Report Post  
Old February 23rd 19, 05:47 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data

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!!!


  #6   Report Post  
Old February 23rd 19, 06:20 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data

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


  #7   Report Post  
Old February 23rd 19, 07:47 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,661
Default populate or summarize data

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
  #8   Report Post  
Old February 23rd 19, 08:09 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data


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





  #9   Report Post  
Old February 23rd 19, 08:28 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,661
Default populate or summarize data

Hi Phillip,

Am Sat, 23 Feb 2019 00:09:54 -0800 (PST) schrieb Phillip Swanepoel:

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


I cannot see any difference. My posted link leads you to the same file.
You have to download it to get all functions to work (some things are
disabled in OneDrive).


Regards
Claus B.
--
Windows10
Office 2016
  #10   Report Post  
Old February 23rd 19, 08:43 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2018
Posts: 15
Default populate or summarize data


claus please have a look at this new link and sample...(renamed)

edne.co.za/teamsample.xlsx


On Saturday, February 23, 2019 at 10:29:01 AM UTC+2, Claus Busch wrote:
Hi Phillip,

Am Sat, 23 Feb 2019 00:09:54 -0800 (PST) schrieb Phillip Swanepoel:

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


I cannot see any difference. My posted link leads you to the same file.
You have to download it to get all functions to work (some things are
disabled in OneDrive).


Regards
Claus B.
--
Windows10
Office 2016




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summarize data Chris Excel Discussion (Misc queries) 1 April 28th 09 09:24 PM
Summarize Data joecrabtree Excel Programming 4 March 23rd 09 11:53 AM
Looking for a way to summarize data? Rich Excel Worksheet Functions 0 September 19th 06 06:05 PM
Summarize Data kgsggilbert Excel Discussion (Misc queries) 1 June 8th 05 09:41 PM
Summarize Data Set Jim Excel Worksheet Functions 6 April 7th 05 03:46 PM


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017