I have a worksheet containing raw data, (see attached) in this file I created a new worksheet called Upload. Here I want to basically extract for each line in the Raw Data I need to extract the Total Product Charges line and then the sum of column F+G+H in the Raw Data and add them below the result from column E.
Take a look at like 2 of my Raw Data sheet and then how it should look in the Upload section, I am at a loss how I can obtain this, considering that the raw data can change in length.
Is this a one time need, or will you need to repeat it every so often as new data sheets are provided?
Will the input always come from the first sheet of the specified XLS file, and do you want the output in a new second sheet, or in a separate XLS file.
~bp
joeserrone
ASKER
Hi Bill, this would be an ongoing repeating task, and I would like it to output to the second sheet in the same file. Yes the template in the Raw Data will always be the same but the number of records might change.
Will the input always come from the first sheet of the specified XLS file, and do you want the output in a new second sheet, or in a separate XLS file.
~bp