software

Hello,

I have a worksheet with 8 columns and 120 rows of data. I would like
to extract only a portion of this data to a new worksheet - and have
the new worksheet update as the original worksheet is updated.

The first column holds the data that I would like to sort by, it
contains the following letters A, AI, C, and CI. In theory, I would
like to have the information from the rows that contain the quot;Aquot; data on
a new worksheet.
I set up a second worksheet with the same headers and can sort/copy to
the new worksheet, but that does not solve my problem of automatic
updating.

I am sorry, this is probably rather simple (at least for some), but I
can not seem to get it to work

Thanks for any help and advice!
Karmen--
Karmen
------------------------------------------------------------------------
Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=511861Hi Karmen,

Have you try using pulldown menu edit, copy and paste special, paste link?
Try it I think it should work.

quot;Karmenquot; wrote:

gt;
gt; Hello,
gt;
gt; I have a worksheet with 8 columns and 120 rows of data. I would like
gt; to extract only a portion of this data to a new worksheet - and have
gt; the new worksheet update as the original worksheet is updated.
gt;
gt; The first column holds the data that I would like to sort by, it
gt; contains the following letters A, AI, C, and CI. In theory, I would
gt; like to have the information from the rows that contain the quot;Aquot; data on
gt; a new worksheet.
gt; I set up a second worksheet with the same headers and can sort/copy to
gt; the new worksheet, but that does not solve my problem of automatic
gt; updating.
gt;
gt; I am sorry, this is probably rather simple (at least for some), but I
gt; can not seem to get it to work
gt;
gt; Thanks for any help and advice!
gt; Karmen
gt;
gt;
gt; --
gt; Karmen
gt; ------------------------------------------------------------------------
gt; Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
gt; View this thread: www.excelforum.com/showthread...hreadid=511861
gt;
gt;


Thanks Mel,
This did try that....it worked
Thanks!
Mel Arquiza Wrote:
gt; Hi Karmen,
gt;
gt; Have you try using pulldown menu edit, copy and paste special, paste
gt; link?
gt; Try it I think it should work.--
Karmen
------------------------------------------------------------------------
Karmen's Profile: www.excelforum.com/member.php...oamp;userid=30972
View this thread: www.excelforum.com/showthread...hreadid=511861