I have a macro to copy data in B9:M9 and to paste these as values in B9 onwards
Where “Current” appears in row5 for e.g. B5, then the column containing Current must not be copied and pasted as values. In this eg only C9:M9 to be copied and pasted as values in C10 onwards
It would be appreciated if someone could kindly amend my code
Please Login or Register to view this content.
I have also posted on https://www.mrexcel.com/board/thread...-data.1149818/
Bookmarks