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
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
Last Comment
Bill Prew
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
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.
SOLUTION
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.
ASKER
Exactly what I was looking for! I appreciate all your help on this
Welcome!
~bp
~bp
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