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