LF code to sum multiple rows of data and combine into one row

**Granite-Granny** · 06-19-2014, 05:15 PM

The spreadsheet attached shows 2 worksheets. Worksheet "Sales-Original" is how I receive the data. I need to convert that data to the format in Worksheet "Sales-Final".

The workbook only contains a sample of de-identified data with some random numbers I'm using to develop a process. The actual sheet is several hundred lines long.

The conversion I'm looking for needs to do a couple of things:
1) Sum all the sales for 1 location for all sales people.
2) Determine when the last time there was sales at that location
3) Determine total sales in 2014 for all sales people (if there were any sales)

Thanks,

GG

**humdingaling** · 06-19-2014, 09:32 PM

was actually last that caused the most issue
created total column as helper...just makes life easier

location done by simple if formula

Formula:

Please Login or Register  to view this content.

the last i did with a macro, could be done with some sort of array formula but this macro is simple to understand

Please Login or Register  to view this content.

the tables themselves is combination of sumif or Max/if using CSE formula
could probably stream line the setting up of total and location into the macro was well if this solution found to be useful

**humdingaling** · 06-19-2014, 09:42 PM

Please Login or Register  to view this content.

Code refined to do data entry at once

**Granite-Granny** · 06-20-2014, 02:19 AM

Humdingaling,

That's a smart way to approach it. I think I'll start with your code and see if I can roll it all up into a macro. It's a sheet that will be run by someone else and I'd like to just put a button on the sheet to do the conversion. I'll think about it some more tomorrow but you have given me an awesome start. Thank you.

GG

**humdingaling** · 06-20-2014, 02:34 AM

not problem
i the only part left filling out the sales final section (just because i dont know how you want it in the end) or you can just leave it like i have as 0 and the formulas update when you run the macro

if you have issues with it, please come back to this thread i will leave it subscribed

else if you find solution just mark it solved

Cheers
hum

LF code to sum multiple rows of data and combine into one row

LinkBack

Thread Tools

Rate This Thread

Display

LF code to sum multiple rows of data and combine into one row

Re: LF code to sum multiple rows of data and combine into one row

Re: LF code to sum multiple rows of data and combine into one row

Re: LF code to sum multiple rows of data and combine into one row

Re: LF code to sum multiple rows of data and combine into one row

Thread Information

Users Browsing this Thread

Similar Threads

How to combine multiple rows of data into a single row (with multiple columns)?

How to combine multiple rows of duplicate data and one cell of unique data

Macro to combine data from multiple rows

Trying to combine multiple rows of data into one

Combine Data from Multiple Rows

Bookmarks

Bookmarks

Posting Permissions