Forum Discussion
Macro that concatenates two cells, references a Date and then copy pastes value into first
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.
