[Dleo]

Mission:

Save me hours and hours of data entry, you know, copy and paste, copy and paste,....... copy and paste.

Brief:

Its basically a very big excel workbook right now, it has current customers for each different brand our company has *Note not all customers carry every brand.
For each customer there is 12 empty boxes next to the name (months of the year)
Every month we get a monthly depletion (also another excel worksheet), saying who bought what and how many.
The problem is, sometimes theres more then 1,000 orders that need to be inputed and also tons of new accounts that need to be added for the specific brand.

Reward:

If you except to choose this mission and help me automate this process somehow, i will ship you a bottle of either vodka, rum, whiskey. (Depending on your preference of course)


Anyone??


If anyone is truly interested and capable of helping me automate this process I will send you the files I am working with to help you understand exactly how its setup.

[jumpingjz]

if it's in excel what you can do is

1. create a search key custname_brand_month
2. create the same search key at sales spreadsheet
3. use sumif fomula to sum up sales.

hope that helps.

JZ

[Dleo]

Originally Posted by jumpingjz

if it's in excel what you can do is

1. create a search key custname_brand_month
2. create the same search key at sales spreadsheet
3. use sumif fomula to sum up sales.

hope that helps.

JZ

Thanks for the input, i will try messing with it, the problem is my experience with excel is limited to entering, formating, and organizing data

[TurboFan]

Send it to me. PM me for my address. I'll either figure it out in 20 minutes or say no f'ing way. Anything up to a macro is pretty easy. If I need to write a macro....well I'm a little rusty!

[MCS]

use a sumif or a vlookup on the cusomer name to get the orders.

An Excel for dummies book (MS help sucks) can explain the vlookup funciton.

[Hawkeye]

I might be able to help, when do you have to have this done by? I write programs in VBA for my job all the time.

Sounds like it should be pretty easy to do, maybe 15 minutes. It would be easy to write a code to search for a company and if it exists make sure it has that brand, if not add it. If the brand doesn't exist you could tack it on the end. If you wanted to send me some examples (smaller files but set up the same please) I could probably hack something together and tell you how to finess it.

I'll pm you my info.

[Hawkeye]

Originally Posted by MCS

use a sumif or a vlookup on the cusomer name to get the orders.

An Excel for dummies book (MS help sucks) can explain the vlookup funciton.

sumif and vlookup will not help adding new companies. sumif would be good if you were just looking for stuff you had to match. (customer on the side and brand along the top) and only if you didn't have a starting quantity you had to worry about. Otherwise you would have to make a presentation tab and a prior month tab or something similar.

[O-cha]

Does everything follow the same characteristics? Like the monthly depletion order and new customer additions? If so it's a very easy job for a programmer to write a program that will take your order depletions and input them into the other excel sheet. Same with the new customers as long as it follows the same pattern with each entry and each month.


Thing is, programmers aren't cheap even if it's a super easy job like this one, but the bonus is it would nearly fully automate the job you just described. Upload the two spreadsheets, or an example of them if it's confidential.

[ren]

I can give it a shot if you still haven't figure it out. I'm not bad with Excel modeling. If you want send me a PM I'll send you my e-mail address. Good luck!

[Hawkeye]

Originally Posted by O-cha

Does everything follow the same characteristics? Like the monthly depletion order and new customer additions? If so it's a very easy job for a programmer to write a program that will take your order depletions and input them into the other excel sheet. Same with the new customers as long as it follows the same pattern with each entry and each month.


Thing is, programmers aren't cheap even if it's a super easy job like this one, but the bonus is it would nearly fully automate the job you just described. Upload the two spreadsheets, or an example of them if it's confidential.

Yeah, what he said. I am really expensive....when at work. But I'd do it for a bottle of booze (just don't tell my company that!)