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
Microsoft ExcelVB ScriptSpreadsheets

Avatar of undefined
Last Comment
Bill Prew

8/22/2022 - Mon
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
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
Bill Prew

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
joeserrone

ASKER
Exactly what I was looking for! I appreciate all your help on this
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Bill Prew

Welcome!

~bp