Missed Conditional Formatting After Running Macro

  • Hi guys, how is everything?
    Look, I need a quick consultancy how to sort this issue out.
    First, please visit this Google Drive link to view the Excel file subject to discussion:
    https://drive.google.com/open?…QVVgUbChttvc6E-NBM5lB02ob

    It’s big file, that’s why I needed to put it in Google Drive.
    Now, in two sheets in the file: 1) (Centre Name) Final Sheet & 2) Intraday, there is a hidden, G column is hidden and it has some conditional formatting.

    When I run the macro, first, the conditional formatting in G column changes the way it works.

    Second, when I copy the generated data range in (Centre Name) Final Sheet and paste it in Intraday sheet, it paste everything but G column, which is really strange.

    How could I fix these two issues please?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!