S suresh kannah Member Aug 1, 2016 #1 Hi Need to filter the scripts from LIve sheet to Dash board sheet , Based On Signals generated from the Live sheet in Q Col, Filter only short or buy Stocks and need to publish in the 2nd sheet. Thanks Suresh Attachments Dashboard.xlsx Dashboard.xlsx 14.5 KB · Views: 2
Hi Need to filter the scripts from LIve sheet to Dash board sheet , Based On Signals generated from the Live sheet in Q Col, Filter only short or buy Stocks and need to publish in the 2nd sheet. Thanks Suresh
Luke M Excel Ninja Staff member Aug 1, 2016 #2 Hi suresh, This is pretty easy to setup using the AdvanceFilter. You can either do it manually, or with a macro. Here's your file with filter setup to run automatically when data on LIVE changes. Attachments Dashboard LM.xlsm Dashboard LM.xlsm 22.2 KB · Views: 6
Hi suresh, This is pretty easy to setup using the AdvanceFilter. You can either do it manually, or with a macro. Here's your file with filter setup to run automatically when data on LIVE changes.