+ Reply to Thread
Results 1 to 2 of 2

Linking into filtered cells

  1. #1
    Registered User
    Join Date
    05-19-2008
    Posts
    56

    Linking into filtered cells

    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

  2. #2
    Registered User
    Join Date
    05-19-2008
    Posts
    56
    This can be closed now, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1