Macro Auto-populate under certain date

Copper Contributor

Hello,

 I am trying to create a macro that would populate data from one sheet to another after clicking a button. I figured out how to do that. but i want it to auto populate under a cell with a date. 

Example: Row 1 is my date range, E1 is 4/16/2021 I want the macro to run on E6. 

0 Replies