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:
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?