Hello,
I am very new when it comes to building macros. And am not really familiar with how to build one. But im trying to make one that will automatically copy data from one sheet labeled "Report Calculator" and push it to another sheet in the same workbook labeled by dates. My sheets are labelled "1", "2","3" etc with each number representing the day in the month....Is it also possible to add a filter to the macro so that it will push the data to the worksheets based on dates? My apologies if what I'm asking is confusing. The cells with Data that need to be moved are A3:D3, A7:D7, A11:C11, A15:B15, and C18. I want the values in these cells to move to the same exact cells except on a different Worksheet. Thanks in advance for any help
I am very new when it comes to building macros. And am not really familiar with how to build one. But im trying to make one that will automatically copy data from one sheet labeled "Report Calculator" and push it to another sheet in the same workbook labeled by dates. My sheets are labelled "1", "2","3" etc with each number representing the day in the month....Is it also possible to add a filter to the macro so that it will push the data to the worksheets based on dates? My apologies if what I'm asking is confusing. The cells with Data that need to be moved are A3:D3, A7:D7, A11:C11, A15:B15, and C18. I want the values in these cells to move to the same exact cells except on a different Worksheet. Thanks in advance for any help
Last edited: