| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered Data Refresh
Hi,
I have a cell that uses a data validation list on one of my worksheets, (Cell 'B3'). I pick a value from 'B3' and by using advance filtering, data is copied over from another worksheet. If I add a new row to one of the sheets that the data is being copied from that match's the choice I have selected in B3 it doesn't display until I select the choice again from my list in 'B3'. How can I make my code refresh the current choice in 'B3' without me having to select it? Thanks, Jody |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filtered Data Refresh
Probably execute the Advanced filter code from the calculate event.
-- Regards, Tom Ogilvy "ssjody" wrote in message ups.com... Hi, I have a cell that uses a data validation list on one of my worksheets, (Cell 'B3'). I pick a value from 'B3' and by using advance filtering, data is copied over from another worksheet. If I add a new row to one of the sheets that the data is being copied from that match's the choice I have selected in B3 it doesn't display until I select the choice again from my list in 'B3'. How can I make my code refresh the current choice in 'B3' without me having to select it? Thanks, Jody |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
| How Do I Automatically Refresh Auto Filtered Data? | Excel Discussion (Misc queries) | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Linear Mode
