I am linking (manually, using 'paste link' as opposed to a macro) from one worksheet to another. The column I am linking into has a filter on it to only display cells from the originating sheet with a certain value.
My problem is that the filter on the receiving sheet is fixed (by default). So if I add or change a value in the original sheet which matches the value specified in the filter , it won't add it to my filtered list UNLESS I click on the filter again manually.
Is there any way for this to be done automatically when a value is added/changed in the first sheet? PLEASE bear in mind I have absolutely NO experience of VBA (hence the sorry mess of the logic I'm using for these sheets) so anything that doesn't involve macros would be a great advantage.
Thanks in advance
Bookmarks