Macro 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 titled 'Money', the second titled 'Data'
In the 'Money' tab, there's a section which currently begins from row 41 where the macro would be populating the data it's pulling. For clarity's sake, i'll refer to this section as the Expense section.

Essentially, the macro is pulling data from the 'Data' tab based on certain criteria (the date). If the criteria is met, it will copy the data of its respective row from the 'Data' tab; will go to the 'Money' tab, look for the last row that contains data in the first portion of the Expense section, creates a new row and pastes values in this new row; making sure not to be pasting over any previous data

written out as steps:
if the concatenation of N & O of 'Data' sheet, viewed as Date format, matches the month of today's date; then copy and paste values of the concatenation into the first available row in column B of 'Money' sheet (beginning from B42 onwards)
then still referencing that same row in 'Data' sheet, copy columns P thru S and paste values into columns C thru F of 'Money' sheet in the same row that was previously referenced.
then still referencing that same row in 'Data' sheet, copy columns T and U and paste values into columns H & I of 'Money' sheet in the same row that was previously referenced.
then still referencing that same row in 'Data' sheet, copy column V and paste values into column G of 'Money' sheet in the same row that was previously referenced



i hope i explained that decently. please let me know if the Excel file isn't any clearer and i'll add more clarity.


*edit: i posted this on mrexcel forum as well - no response there

Please mark the thread as solved - you should know that we don't delete threads.

I am surprised that you needed reminding about cross-post links (that's LINKS to cross-posts, not just a casual mention.

What about all the others?

https://www.ozgrid.com/forum/index.p...i/#post1243461
https://techcommunity.microsoft.com/...en/m-p/2077123

Your tone is completely unacceptable (and I note that it is equally so on other forums). I will give you ten days to cool down before posting here again.