I wish to create a macro button that will move a specific set of daily entered data into a list that has dates on it. My goal is to be able to put the data in the same set cells every day and then be able to push the macro button and it will automatically move the data into the cells that are in the list for the currrent day. Does anyone have any advice on how to do that?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Moving Data
0
Discussion
Please let us look at the design of the space wher you wish to enter the data and the design of the list to which you wish to add the daily entries. How should your macro know in which row of the list the new data are to be inserted?
Variatus (rep: 4889) Nov 5, '19 at 4:41 am