Finding and copying info

  • Thread starter Thread starter HBruceP
  • Start date Start date
H

HBruceP

I'm building a Summary sheet (pretty spreadsheet for
executives) that will take information from a raw data
sheet that is downloaded from a database. I don't know
which exact row the information will start but I do know
the column. I can find where it starts by looking for the
column heading with the equation

ADDRESS(MATCH("Apple Numbers",DailyActivityReport!
C1:C200,0),3,1,1,"DailyActivityReport!")

This will return the cell location. From that point, I
want to copy the information from the cells that are in
the same column but starts two rows down for 10 rows. I'm
probably being brain dead about this but can anybody help?
 
Assuming the text "Apple Numbers" is in cell C6 of the sheet
"DailyActiveReports" and you want a formula to return the range C8:C17 then
try.....

=ADDRESS(2+MATCH("AppleNumbers",DailyActiveReport!C1:C200,0),3,1,1)&":"&ADDR
ESS(11+MATCH("AppleNumbers",DailyActiveReport!C1:C200,0),3,1,1)


--
XL2002
Regards

William

(e-mail address removed)

| I'm building a Summary sheet (pretty spreadsheet for
| executives) that will take information from a raw data
| sheet that is downloaded from a database. I don't know
| which exact row the information will start but I do know
| the column. I can find where it starts by looking for the
| column heading with the equation
|
| ADDRESS(MATCH("Apple Numbers",DailyActivityReport!
| C1:C200,0),3,1,1,"DailyActivityReport!")
|
| This will return the cell location. From that point, I
| want to copy the information from the cells that are in
| the same column but starts two rows down for 10 rows. I'm
| probably being brain dead about this but can anybody help?
 
Thanks alot!

-----Original Message-----
Assuming the text "Apple Numbers" is in cell C6 of the sheet
"DailyActiveReports" and you want a formula to return the range C8:C17 then
try.....

=ADDRESS(2+MATCH("AppleNumbers",DailyActiveReport! C1:C200,0),3,1,1)&":"&ADDR
C1:C200,0),3,1,1)


--
XL2002
Regards

William

(e-mail address removed)

| I'm building a Summary sheet (pretty spreadsheet for
| executives) that will take information from a raw data
| sheet that is downloaded from a database. I don't know
| which exact row the information will start but I do know
| the column. I can find where it starts by looking for the
| column heading with the equation
|
| ADDRESS(MATCH("Apple Numbers",DailyActivityReport!
| C1:C200,0),3,1,1,"DailyActivityReport!")
|
| This will return the cell location. From that point, I
| want to copy the information from the cells that are in
| the same column but starts two rows down for 10 rows. I'm
| probably being brain dead about this but can anybody help?



.
Click to expand...
 
Back
Top