View Full Version : Find Value in Row, and delete rows above/below


ezykiwi
12-07-2006, 11:52 PM
Hello everyone,

Ive got a sheet which draws data in via a web query,
It then pull all the info and puts it into my sheet down the sheet in
rows....
Depending on which page of my site it draws it from.. depends where the
starting point in.....

for example... Page 1 =

A1 = blah blah 1
B1 = blah blah 2
C1 = Start
D1 = Data
E1 = Data
F1 = End
G1 = blah blah 3

Page 2 =

A1 = blah blah 1
B1 = blah blah 2
C1 = blah blah 3
D1 = Start
E1 = Data
F1 = End
G1 = blah blah 3

Is there a way I could get it to strip out everything from the START and
above, and everything from END and below no matter how many differant things
there are above or below, and no matter how much data inbetween there is.

Thanks for your help, any advice would be awesome.
Cheers Ezy

ezykiwi
12-08-2006, 03:22 AM
I got a reply on the newsgroup and am working on it at the moment, I think ive found the answer,

Cheers Ezy