vba - Button in Excel to copy information about specific month from other table -
so have 1 big table, includes lot of information. need make button or else, copy information massive table date, example, purchases made in november. here's principle of have , should get.
this button copy data , paste other sheet. nice if there month list data validation, select month , press button , shows purchases made in month.
this example of big massive table
this using button , select drop down menu
i use table achieve this. select top-left cell (labelled "nr.") , insert ribbon choose table. providing have no gaps in rows , columns automatically select data.
then can use filter button on row heading date. date values in cells enable date filter options shown in screen-shot below. right-click options meet requirements, or can use custom filter option enter specific date ranges. no code required.
Comments
Post a Comment