Copy row then paste values below

[lapot]

Dear all

By using a macro on the attached report I like to copy the row values named "Section Total" in red and and paste them over the values starting with "Aged Debt" in blue (the rest of the wording cahanges every month so "Aged Debt" is the key word for that row). Is this possible?

Kind regards

[mongoose36]

Copy and paste this into a new module. I tested it and at first it didn't do the second "Section Total", but this is because I think you have an extra spaces after the word "total" in the second "Section Total". If you copy your first Section Total and paste it into the cell that has your second section total the code works for both.

Please Login or Register  to view this content.

Please add reputation if I have answered your question.