Could someone please advise? I use Excel 2003. I have two worksheets, ie, ws1 an

Question

Could someone please advise? I use Excel 2003.

I have two worksheets, ie, ws1 and ws2. I need some of the data in wss1 in ws2, the thing is that ws1 continues to have data added. I thought I could do this by advanced filter howeverr, it does not update, it only shows the data that is filtered at this time. What I would really like is to be ablee to input into ws1 then go to ws2 have the data relevant transfered ready to work on. Is this possible???

Thanks in advance of any help it is very much appreciated????

Explanation / Answer

In the source worksheet, select the cell you want to link to and click the Copy button on the Home tab. Or press Ctrl+C, or right-click and select Copy. Switch to the destination spreadsheet and click the cell where you want the link. Then, depending on your version of Excel: Excel 2007, 2010, and 2013: On the Home tab, click the down arrow below Paste and click Paste Link. In newer versions you may also right-click and select the Paste Link from the Paste menu. Excel 2003 and older versions: On the Edit menu, click Paste Special, and then click Paste Link. Return to the source worksheet and press ESC to remove the animated border around the cell.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects