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
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