randomhause
New Member
- Joined
- Jun 12, 2015
- Messages
- 8
Hello ~ I need some help with the following!
I need to use a Radio Button in sheet1 to filter a list in excel in sheet2 and then output the results in sheet1. The options for the radio button will filter on sheet2 column B.
So a user will select one of the three options (which is "Type"), click the "Filter" button which will then output the results in Sheet1. The results in Sheet1 will only show the users who have that specific "type". Sheet2 I have a full list of all the users column A and column B the "Type" of device they have.
Example
Sheet1
() IPhone
() IPad
() Iphone & Ipad
{Filter Button}
Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]User[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Betts[/TD]
[TD]Iphone[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Logan[/TD]
[TD]Ipad, Iphone[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Sue[/TD]
[TD]Ipad[/TD]
[/TR]
</tbody>[/TABLE]
I'm looking at creating a macro, I've try searching for some help on this but only found macros that use a SearchBox option.
Thank you for your help <3
I need to use a Radio Button in sheet1 to filter a list in excel in sheet2 and then output the results in sheet1. The options for the radio button will filter on sheet2 column B.
So a user will select one of the three options (which is "Type"), click the "Filter" button which will then output the results in Sheet1. The results in Sheet1 will only show the users who have that specific "type". Sheet2 I have a full list of all the users column A and column B the "Type" of device they have.
Example
Sheet1
() IPhone
() IPad
() Iphone & Ipad
{Filter Button}
Sheet2
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]a[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]User[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Betts[/TD]
[TD]Iphone[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Logan[/TD]
[TD]Ipad, Iphone[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Sue[/TD]
[TD]Ipad[/TD]
[/TR]
</tbody>[/TABLE]
I'm looking at creating a macro, I've try searching for some help on this but only found macros that use a SearchBox option.
Thank you for your help <3