Rolling Information

[Nikki]

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)="PD 5")),H27,NA()) and an offset equation
to keep this equation in place?


--
Thanks,
Nikki

[Nikki]

I just wanted to say I figured it out-
--
Thanks,
Nikki


"Nikki" wrote:

> 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)="PD 5")),H27,NA()) and an offset equation
> to keep this equation in place?
>
>
> --
> Thanks,
> Nikki