Excel VBA: How to set an Autofilter criteria to match the contents of a cell on a different page?

Question

I have a data table that I will want to filter by date and then copy to the report page. I want the user to be able to input the data on the report page and then initiate the macro. The macro should reference the date on the report page and set the filter on the data table to match. How can I do this?

Answer 1

if you want the macro to copy the data over to the report sheet, autofilter isn't going to work. You're better off using a loop to search for the user inputted date and then copy paste that row over to the report sheet.

Answer 2

you are able to desire to objective utilising borders. that would desire to grant you a sturdy grid, and in case you fill them white, you will get an empty cellular which "technically" has content cloth. to stay with borders: a million. spotlight your cells 2. click format (in the main menu) 3. click Cells 4. click the Borders tab 5. elect your border form, then hit ok For the white history, earlier hitting ok, click the varieties tab, and choose the white coloration. Then hit ok. desire that's what you have been after