Alright... this question is pretty tough and I have tried spending a decent
amount of time on it but cannot come up with an answer. hopefully you will
have better luck:

I am building a template which needs to pull values from an excel sheet that
will be copied and pasted into one of the worksheets in the template. These
values are always in the same columns but not always in the same row as the
length of the file varies. One of the main problems I am having is that there
these values are sums (located at the bottom of the table) but they do not
have any indicator in the first column (it is blank so I cannot use vlookup).
Also there may be multiple tables (each under the privious one) and in this
case I need to be able to extract the sum of each of the sum value for each
table.

Also, I was thinking of taking another route. Instead of looking up the
already calculated sum values I was thinking there might be a possibility to
sum the values my self and pull that value for the coumns needed into my
template. The first lign of each table begins with "Asgn" and ends with "End"
and I was wondering if there is a way to sum the values between (and
including) these two markers for the columns needed.

Hopefully you can help!

thanks

Here is what the table looks like:

First
Selectio n Rtl Case
Location Produ ct Qty Weight Cube Time
-------- - ----------- ------ --- ------ ----- -------
Asgn T ime 0 0 0 0
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 1 20 0.02 0.15
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 3 61.02 0.06 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34610 508589 1 19.82 0.02 0.149
15-37319 507796 12 6.97 0.01 0.137
13-37020 413938 12 4.41 0.01 0.134
Cube T ime 0 0 0 0
End A sgn 0 0 0 0

454.9 0.1 2.373

I need to pull some the values at the bottom - 454.9, 0.1 or 2.373

"MIKE D" wrote:

Here is what the table looks like:

First
Selectio n Rtl Case
Location Produ ct Qty Weight Cube Time
-------- - ----------- ------ --- ------ ----- -------
Asgn T ime 0 0 0 0
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 1 20 0.02 0.15
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 3 61.02 0.06 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34610 508589 1 19.82 0.02 0.149
15-37319 507796 12 6.97 0.01 0.137
13-37020 413938 12 4.41 0.01 0.134
Cube T ime 0 0 0 0
End A sgn 0 0 0 0

454.9 0.1 2.373

I need to pull some the values at the bottom - 454.9, 0.1 or 2.373

Hi,

The real problem here is that you many have many groups or not. You can
return the last cell containing numeric data in a column using something like:

=LOOKUP(9^9,Sheet2!C3:C21)

If you entered a unique code, 1 character in column A on the row of each
sum, you could then use

=VLOOKUP(A1,Sheet2,$A$1:$N$1000,3,False)

If this helps, please click the Yes button,

cheers,
Shane Devenshire
"MIKE D" wrote:

Here is what the table looks like:

First
Selectio n Rtl Case
Location Produ ct Qty Weight Cube Time
-------- - ----------- ------ --- ------ ----- -------
Asgn T ime 0 0 0 0
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 2 40 0.04 0.15
17-34018 506385 1 20 0.02 0.15
17-34018 506385 1 20 0.02 0.15
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 3 61.02 0.06 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34319 503580 1 20.34 0.02 0.150
17-34319 503580 2 40.68 0.04 0.150
17-34610 508589 1 19.82 0.02 0.149
15-37319 507796 12 6.97 0.01 0.137
13-37020 413938 12 4.41 0.01 0.134
Cube T ime 0 0 0 0
End A sgn 0 0 0 0

454.9 0.1 2.373

I need to pull some the values at the bottom - 454.9, 0.1 or 2.373