Is it possible to link sheets in 2 workbooks, and if so is it possible to be able to hide some columns in the linked sheet so that if data in the original sheet is changed, the hidden column will show as updated when unhidden?
Is it possible to link sheets in 2 workbooks, and if so is it possible to be able to hide some columns in the linked sheet so that if data in the original sheet is changed, the hidden column will show as updated when unhidden?
Hi, basils57,
AFAIK you will need VBA to get a result - either the Worksheet_Change-event if the values are entered manually or the Calculate-Event if the values derive from formulas. It would be useful to know if both workbooks are open all the time or if the event should be done when opening the linked workbook (there the Workbook_Open-event may be used for showing the columns).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thanks for the response HaHoBe. Both workbooks aren't open all the time, so the event should be done when opening the linked workbook.
However, my knowledge of VBA is zero, and so I think I might have to forgo this idea.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks