Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Thanked 0 Times in 0 Posts

    Linked Files (Excel 2000)

    I have two excel files. Each cell in the second file is linked to the first by "=(filename.xls)Sheet1!A1)", etc., I also have autofilter set to only view an "active" column on file 2.
    When I add a new row with "active" status to file1, file2 does not update until I select the filter again.

    Is there a way to have the second file automatically update when a new "active" row is added to the first excel file?

    Thank you.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts

    Re: Linked Files (Excel 2000)

    You could add code to worksheet activate event to filter on the appropriate column.

    So when you leave file 2 and change file1 status, then goto file 2, the macro would trigger (file2 is activated) and the column would be filtered

    <pre>Private Sub Worksheet_Activate()
    Range("A1").AutoFilter Field:=1, Criteria1:="active"
    End Sub</pre>

    Change the range, field number and criteria as appropriate.


Posting Permissions

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