acme

Good day Firstly, I am very grateful for the help I received last time round. Whoever helped me thank you. I had a mail glitch so I cannot do it personally. I am trying to help my wife with managing a ******* etc I have managed to construct some stuff but now I am struggling to extract the data...

I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...

I've been hunting around google and forums trying to figure this out out using a formula vs VBA. I'm using google sheets currently for this. ColA - Account ID / ColB - Customer Name / ColC Customer sub accounts (ranges from 1-15 separate names) Another sheet contains all the customer record...

Hello, I am trying to do a spreadsheet where if one column range (A10:A100) have a certain word (such as Acme, Inc), then calculate the total of column range B10:B100 and put that total in cell A2. I've got dropdown menus of various bills that need to be paid, across multiple vendors, but it...

Hi all, I work for Acme Inc. Acme Inc. is a box filled with the type of people who live and breath excel and use it like a swiss army knife. I'm a vba developer. Swiss army knife is fine, except lots of the sheets these folks work in are presented to clients and crossed referenced to other...

I have two tables TransactionsTable InvDate CustomerName SalespersonTable CustomerName SalesID SalesPerson EffectiveFrom The SalespersonTable has multiple records for the customer - the records are made unique by the SalesID EffectiveFrom columns Eg I want to create a column in the...

I am trying to look at several years of sales data by customer in order to compare year to year sales and possibly monthly or quarterly as well. I have no problem getting it into a pivot table and shown exactly like i want, but the problem is trying to consolidate various customers from the same...

Hi Excel Wizards, I am trying to figure out how to cycle through a column of dates whereby if there are duplicate dates the code runs some If/Then statements and adds data into offset cells. Then I would like to skip over the duplicate dates and start the compare and If/Then process again on...