Hi!
I'm trying to make a 'quick view' sheet which is a copy of the main sheet but where i can hide columns that aren't of interest, whilst getting it to automatically update with any new information that has been applied to the main sheet.
I have tried to dynamically link the two sheets but the formatting isn't great and where there is conditional formatting in the source sheet the destination sheet cells just throw up numbers.
I'm trying to make a 'quick view' sheet which is a copy of the main sheet but where i can hide columns that aren't of interest, whilst getting it to automatically update with any new information that has been applied to the main sheet.
I have tried to dynamically link the two sheets but the formatting isn't great and where there is conditional formatting in the source sheet the destination sheet cells just throw up numbers.