Dynamically linking two sheets

[S0ph1e]

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.

 

[Joe4]

Welcome to the Board!

You could put formulas in each cell to return the value of its counterpart on the other sheet.

For example, if you want the value from cell A1 on Sheet1 to show up in cell A1 on Sheet2, place this formula in cell A1 on Sheet2:

=IF(Sheet1!A1<>"",Sheet1!A1,"")

You can then copy this formula for all cells that may contain values.
Since these are formulas, they will automatically update as the values in Sheet1 are updated.

Unfortunately, Excel formulas can only return values and not formatting.
If you wish to apply the same formatting as on Sheet1, I recommend that you use the Format painter to copy and paste the formatting from Sheet1 to the exact same range on Sheet2.