Richard U
Active Member
- Joined
- Feb 14, 2006
- Messages
- 406
- Office Version
- 365
- 2016
- 2010
- 2007
- Platform
- Windows
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?
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?