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?id=1_u...c6E-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?
This post was originally posted here but I got no answer
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1212494-missed-conditional-formatting-after-running-macro
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?id=1_u...c6E-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?
This post was originally posted here but I got no answer
https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1212494-missed-conditional-formatting-after-running-macro