I want to make a form that will act as an autofilter. I want it to list the dates (non dupes) in a drop down box. Once you select a date, it will remove all the other rows that DON'T equal to that date. I've created the form itself already but I'm a newbie when it comes to integrating them into Excel. If done manually, I would have to remove rows of data from 20+ sheets. I intend to call the function from each of the sheets. Please help if you can! Thanks in Advance!!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Simple Forms question.
- Thread starter JayLee
- Start date
Excel Facts
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Ok I got the data to show in the drop down box. And then I did this:
Dim CurrentDate As Integer
ActiveCell = CurrentDate
Call DateRemoval
Now, how do i use the variable to remove the rows that don't match the date in the other sheets? On another note, the drop down box also shows the column title as well. Is there a way to remove that? Thanks in advance if you can help!!!
Dim CurrentDate As Integer
ActiveCell = CurrentDate
Call DateRemoval
Now, how do i use the variable to remove the rows that don't match the date in the other sheets? On another note, the drop down box also shows the column title as well. Is there a way to remove that? Thanks in advance if you can help!!!
Upvote
0
Similar threads
- Question
- Replies
- 3
- Views
- 171
- Question
- Replies
- 0
- Views
- 74
- Replies
- 0
- Views
- 160
- Replies
- 0
- Views
- 203
