How do I copy the results of this autofilter to Sheet2?
When I go to select the first cell and ctrl+shift+down to select the range it can be different each time. A22 one time A10 another.. How do I tell it to just select the visible cells in column A, and copy them to another sheet?
If the filter does not produce any results? skip copying this to the other sheet. (there are just headers in the filter, or do not count row 1.
I need to run another procedure on the results of this filter... any ideas? -R-
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…