Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
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  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
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




  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default populate or summarize data

Hi Phillip,

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

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

edne.co.za/teamsample.xlsx


here is the downlad link:
https://1drv.ms/x/s!AqMiGBK2qniTgeE3jgK-U0wpUfoZiA


Regards
Claus B.
--
Windows10
Office 2016
  #12   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default populate or summarize data

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.


On Saturday, February 23, 2019 at 11:48:08 AM UTC+2, Claus Busch wrote:
Hi Phillip,

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

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

edne.co.za/teamsample.xlsx


here is the downlad link:
https://1drv.ms/x/s!AqMiGBK2qniTgeE3jgK-U0wpUfoZiA


Regards
Claus B.
--
Windows10
Office 2016


  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default populate or summarize data

Hi Phillip,

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

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.


for me it works fine.
Try it again. If the link doesn't work send me an email

Then I send you the file as attachment.


Regards
Claus B.
--
Windows10
Office 2016
  #14   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default populate or summarize data

email send. Thank you

On Saturday, February 23, 2019 at 11:58:04 AM UTC+2, Claus Busch wrote:
Hi Phillip,

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

This item might not exist or is no longer available
This item might have been deleted, expired, or you might not have permission to view it. Contact the owner of this item for more information.


for me it works fine.
Try it again. If the link doesn't work send me an email

Then I send you the file as attachment.


Regards
Claus B.
--
Windows10
Office 2016


  #15   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default populate or summarize data

Hi Phillip,

Am Sat, 23 Feb 2019 02:21:49 -0800 (PST) schrieb Phillip Swanepoel:

email send. Thank you


I received no mail.
Did you delete the paranthes around the @ sign?

Regards
Claus B.
--
Windows10
Office 2016


  #16   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default populate or summarize data

yes i did...

pswanie
(@)
gmail
com



On Saturday, February 23, 2019 at 12:37:28 PM UTC+2, Claus Busch wrote:
Hi Phillip,

Am Sat, 23 Feb 2019 02:21:49 -0800 (PST) schrieb Phillip Swanepoel:

email send. Thank you


I received no mail.
Did you delete the paranthes around the @ sign?

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 12:53 PM
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:30 PM.

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

About Us

"It's about Microsoft Excel"