software

I actually have two questions,
I have a spreadsheet with rolling data- everytime I insert a new line the
top line is deleted.
At the bottom of the sheet I want to pull all the information that contains
the letters PD 10 into a little table of it's own. I used the Advanced
Filter to do this and recorded a marco to update the filter and repopulate
the table, but it gets messed up because of the rolling info. Is there a
better way to do this?

Second question concerns Offset - I have had to use offset in everything I
have done.
How do mix the two equations
=IF(OR((LEN(B27)=10),(LEFT(B27,4)=quot;PD 5quot;)),H27,NA()) and an offset equation
to keep this equation in place?--
Thanks,
Nikki

I just wanted to say I figured it out-
--
Thanks,
Nikkiquot;Nikkiquot; wrote:

gt; I actually have two questions,
gt; I have a spreadsheet with rolling data- everytime I insert a new line the
gt; top line is deleted.
gt; At the bottom of the sheet I want to pull all the information that contains
gt; the letters PD 10 into a little table of it's own. I used the Advanced
gt; Filter to do this and recorded a marco to update the filter and repopulate
gt; the table, but it gets messed up because of the rolling info. Is there a
gt; better way to do this?
gt;
gt; Second question concerns Offset - I have had to use offset in everything I
gt; have done.
gt; How do mix the two equations
gt; =IF(OR((LEN(B27)=10),(LEFT(B27,4)=quot;PD 5quot;)),H27,NA()) and an offset equation
gt; to keep this equation in place?
gt;
gt;
gt; --
gt; Thanks,
gt; Nikki