Macro Auto-populate under certain date

%3CLINGO-SUB%20id%3D%22lingo-sub-2281653%22%20slang%3D%22en-US%22%3EMacro%20Auto-populate%20under%20certain%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2281653%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3BI%20am%20trying%20to%20create%20a%20macro%20that%20would%20populate%20data%20from%20one%20sheet%20to%20another%20after%20clicking%20a%20button.%20I%20figured%20out%20how%20to%20do%20that.%20but%20i%20want%20it%20to%20auto%20populate%20under%20a%20cell%20with%20a%20date.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EExample%3A%20Row%201%20is%20my%20date%20range%2C%20E1%20is%204%2F16%2F2021%20I%20want%20the%20macro%20to%20run%20on%20E6.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2281653%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

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