Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: linking worksheets

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a main worksheet with data that needs to be sorted and copied to new worksheets. The new worksheets must be linked to the main worksheet so that all updates made automatically appear in each page.

    I would like to filter sort the main worksheet to find each category that needs to be set up in new worksheets.

    The method I am using is:
    1 Filter sort the data in the main spreadsheet by category required
    2 Opening new worksheet and entering in cell A3 =mainspreadsheet!A3 - this is successfully copying the data I need

    The problem I have is that when I copy the formula down it does not copy filtered data it carries on to cell A4 then A5 etc.

    How can I copy the formula for the filtered info only.


    [ This Message was edited by: dione on 2002-03-25 14:02 ]

  2. #2
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I hope I understand what you want. In your master sheet, autofilter and select the category you want to link to, then hight light all the desired data, select your other sheet, and use paste special, and push the Paset Link button. Is this what you're after?
    Richard

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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