Link to home
Start Free TrialLog in
Avatar of joeserrone
joeserrone

asked on

Extract information from Worksheet

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.

Thanks.
Sample-Worksheet.xlsx
Avatar of Bill Prew
Bill Prew

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
Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Exactly what I was looking for! I appreciate all your help on this
Welcome!

~bp