Help with a complex formula

[Richard U]

I'm trying to break out customer data to several spreadsheets

It's working, but I think there must be an easier way


Here's what I have so far.....
The customer name is in column "E" and I want to pull the customer data into it's own sheet


=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,1)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,2)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,3)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,4)

=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),0,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),1,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),2,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),3,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",COUNT!$E$1:$E$5001,0)+0),4,0)


et cetera....

Is there a way of designing the formula where the offset rows and columns will automatically increment?

 

[Richard U]

ugh, sorry....

Correction...

=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,1)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,2)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,3)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,4)

=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),0,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),1,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),2,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),3,0)
=OFFSET(INDIRECT("Customer!A" & MATCH("AB*",Customer!$E$1:$E$5001,0)+0),4,0)