Hi all, i have a table with headers in row 1 (A to Q).

I need a macro to filter by column B (Date) to find selections for today only, and then copy the selections to past somewhere else.

I don't want column A data to be included in the selected area (so only B to Q), and sometimes there will be only 1 item, sometimes 0, sometimes 100 - so the amount of rows to be selected is unknown.

Any help much appreciated - as I suspect someone will know exactly how to do this