Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summarize data | Excel Discussion (Misc queries) | |||
Summarize Data | Excel Programming | |||
Looking for a way to summarize data? | Excel Worksheet Functions | |||
Summarize Data | Excel Discussion (Misc queries) | |||
Summarize Data Set | Excel Worksheet Functions |