Rolling Information
 

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

Rolling Information
 

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