linking worksheets

dione · Mar 25th, 2002, 03:02 PM

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 ]

RichardS · Mar 25th, 2002, 03:26 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 03:02 PM	#1
dione New Member Join Date: Mar 2002 Posts: 3	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 ]

Mar 25th, 2002, 03:26 PM	#2
RichardS Board Regular Join Date: Feb 2002 Location: Victoria, Australia Posts: 761	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