Forum Discussion
Deleted
Jan 20, 2021Macro that concatenates two cells, references a Date and then copy pastes value into first
Would love some help writing this macro i tried attaching a file with more explanations within the file if it helps make it clearer. (in yellow highlights & red text) I have two sheets. One tit...
AnaBoyko
Jan 20, 2021Copper Contributor
Deleted
I agree with Mr. mathetes it is not an easy job to create a macros like this. Try to create your report for one date with sufficient extra space and link the date of the report to a list of the dates. Then you can create much more easy macros, thal will change the date in the report, calculate and copy the result to a new sheet or book
mathetes
Jan 20, 2021Silver Contributor
I just want to make sure there's no confusion here. You wrote I agree with Mr. @mathetes it is not an easy job to create a macros like this, but in fact we're not in agreement.
I was not saying that it's "not easy" to create a macro....my fundamental point was that creating a macro was the wrong way to approach the task of creating a spreadsheet to track income and expenses. Excel can do wonders without relying on macros, especially in dealing with databases of financial transactions. The Pivot Table is one tool that requires no macros to analyze a database. There are functions like the recently released FILTER that can pull records from one sheet to another based on a variety of criteria.
Macros do have a place. I don't categorically oppose them. But Excel's built-in functions provide reliable ways to accomplish a task like this. It's worth while to spend time learning how to use those built-in functions rather than spending the time to figure out how to write an unnecessary routine to accomplish the same task.