At first, please look this excel worksheet:
The month table contains whole year data. If I select any month from the table by typing or by selecting from drop down menu (e.g "Selected") then only those rows will be appeared after certain rows. As for example I want that the selected rows will be appeared after rows 14 and onward (i.e Rows will not be appeared before row 15). How to achieve this?
For your kind information, Number of selected rows may vary. As for example, in the above table there are two rows selected (April & September). But it might be March, April & September selected. So I can't specify a cell range in which the selected rows will be appeared. Also, there will be some text on Rows 17. So, the selected rows have to inserted dynamically after rows 14.
Any idea how to achieve this?
Best Answer
I would probably go using a PivotTable. Month would go in COLUMNS while B, C & D in VALUES (this should essentially make the table look more or less the same as yours). The selection parametre then needs to be put into FILTERS to show only the stuff you want.
The bad thing about is that each team you want changes to be displayed, you need refresh the PivotTable (RMB and Refresh or through Analyse; alternatively you can use a macro to do it periodically for you).