My bank statements are in individual debit + credit format, so I’m using the concatenate function to combine the columns, then I copy and paste as “values only” so I don’t have referencing issues when the original columns are deleted. This works fine when I manually do it, but when I play back the macro, nothing actually gets pasted to the “amount” column like it actually happened.
Anyone have any issues like this when using macros?