[TABLE="width: 761"]
<tbody>[TR]
[TD]Hi All,
I am a relative novice to Excel, though know how to use basic VLOOKUP. Appreciate any help you can provide.
What I am trying to do is automate an email distribution per the example below using buttons.
Say I need to send an email to groups B and D, then I would like to click on button B and D and have the cell labeled 'OUTPUT' automatically populated with all the email addresses separated by 'semicolon and a space'
There is also an added complication with B and D since 'cuttysark' is found twice, can the formula remove duplicates?
So the questions are
1. how do I create buttons?
2. how do I allow the buttons to execute a query like the one above?
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]whitehorse@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]johnniewalker@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]jimbeam@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl65"]cuttysark@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 187"]
<tbody>[TR]
[TD="class: xl65"]jeremiahweed@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]chivasregal@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]wildturkey@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]glenmorangie@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]jackdaniels@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl65"]glenfiddich@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]cuttysark@google.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OUTPUT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Many thanks
<tbody>[TR]
[TD]Hi All,
I am a relative novice to Excel, though know how to use basic VLOOKUP. Appreciate any help you can provide.
What I am trying to do is automate an email distribution per the example below using buttons.
Say I need to send an email to groups B and D, then I would like to click on button B and D and have the cell labeled 'OUTPUT' automatically populated with all the email addresses separated by 'semicolon and a space'
There is also an added complication with B and D since 'cuttysark' is found twice, can the formula remove duplicates?
So the questions are
1. how do I create buttons?
2. how do I allow the buttons to execute a query like the one above?
[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]whitehorse@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]B[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]johnniewalker@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]jimbeam@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl65"]cuttysark@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 187"]
<tbody>[TR]
[TD="class: xl65"]jeremiahweed@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]C[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]chivasregal@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]wildturkey@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]D[/TD]
[TD][TABLE="width: 181"]
<tbody>[TR]
[TD="class: xl65"]glenmorangie@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 164"]
<tbody>[TR]
[TD="class: xl65"]jackdaniels@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl65"]glenfiddich@google.com[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]cuttysark@google.com[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OUTPUT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Many thanks