Worksheet help Hi Could someone please advise? I use Excel 2003. I have two work

Question

Worksheet help

Hi

Could someone please advise? I use Excel 2003.

I have two worksheets, ie, ws1 and ws2. I need some of the data in ws1 in ws2, the thing is that ws1 continues to have data added. I thought I could do this by advanced filter however, it does not update, it only shows the data that is filtered at this time. What I would really like is to be able 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 W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.