Hello,
I am a beginner VBA programmer who is trying to teach myself Excel programming. I have a workbook (enclosed), that contains multiple worksheets.
I am trying to take a small range of cells (Totals) from Worksheet A (Dashboard), and copy them to the appropriate cell range in worksheets Jan, Feb, Mar..., based on matching dates.
Worksheet A contains a date stamp and the other worksheets have calendar dates populated in Column B. I also created Macro Buttons on Worksheet A, that allow a user to execute the macros.
Any help would be much appreciated with this. I am not sure how to point the macro to all of the worksheets and match a date stamp with the dates in column B.
Enclosed is my workbook. FYI- The Clear Data macro button works
Bookmarks