customer

Ok, I have been unable to solve this formula. I have a list of financial transactions on a sheet named Income Stmnt Transaction. In Column I is the customer name, Column M is the revenue earned for a single transaction, and Column N is the account type. the customer who earned the most...

All, Need help reformatting a data dump from my work system. Unfortunately when trying to get a dump of orders by day, with customer name, product and quantity, it puts the customer name in the same column!! I need to download 3 months worth of orders, please help! Cheers PS example attached...

Hello all i have this formula :{=LARGE((ROUND('Customer Data'!$Q$2:$Q$5000,5)+ROW('Customer Data'!$Q$2:$Q$5000)/10000000),ROW(K3)-ROW($K$3)+1)} this gives me a list of the top 50 spenders of a certain product group. (3 different groups all up so i have 3 different lists) my problem is that...

I am new to writing macros and am struggling with this one. I would like the following to happen automatically: If Cell "C8" equals "NEW" then unlock Cell "F8" and allow someone to type in any value in Cell "F8". If Cell "C8" does NOT equal "NEW" then lock Cell "F8" and run this formula...

I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate...

My question is, how do I find which consecutive rows are grouped then store those rows and use them for other columns. I'm trying to create a macro that allows me to take data from an excel sheet and place it in bookmarks of a word document. Below is the code I already have Sub DocGenerator()...

Dear excel colleagues I have a monthly report which is completed during the current month by people with some key data, basically "customer account with format A1234," purchase Id" and if "fully paid" or "instalments" in three different columns. In the other columns data is almost the same...

Hello everyone. I am back again. The code bellow is working to an extent. However, when I click OK to the Error I get, it clears the field BUT the customer name field (tbnbna) does not get the setfocus. Private Sub tbnbna_AfterUpdate() If Application.WorksheetFunction.CountIf(Range("A:A")...

Good Morning, I am attempting to combine a Dynamic rolling chart with aCombo box to select different data streams. For example: The data sheet has sales volumes for 3 customers frompast 36 months I have been able to produce a rolling chart using OFFSETformula and named ranges which...

Below is the beginning of my code, the only issue I'm having is that the below list when deleting should only delete on an exact match. So for example if I have 'carrier name' as a column header and 'carrier name 2' as a column header by the list below only carrier name column should be...

I have a large data set - 1,600,000 rows. I am using powerpivot so I can use all the data set. The pivot table itself however is still limited by the 1 Million lines. Most of the time this is not an issue. However I have one report where I want to display in the pivot itself more than the limit...

Hello, I have a Customer table that I would like the first column to autonumber to the next higher number. When sorting the table can that number remain with the Customer? What I have tried so far doesn't keep that ID with the Customer when sorting the table columns. Thank you

Hi all, again. If I can't do the simple thing, I will NEVER ever stand a chance at learning how to correctly code. Ok. There's a form that loads when a spreadsheet is clicked; Private Sub Worksheet_Activate() CustForm.Show End Sub This form has 4 command buttons. One of these buttons...

See table below for examples I have a data set with customer order dates Col (1,2,3) - Values I need to analyse the weekly order patterns over a 3 month period, this can be 60,000+ rows of data The array formula looks at these 3 columns and returns a binary pattern for that week. Example...

Hello, Is there a way to keep the assigned ID with each customer ? I want to be able to sort the table but when doing so the ID numbers for the customers change. Thank you very much Excel WorkbookABCDEFGHIJ1IDContact NameCompany NameStreet AddressCitySTZip CodePhoneEmailNotes2101JohnBank12...

Customer produces and sells widgets (CW). We sell a report about the performance of the widgets. I have a spreadsheet of customers with one report sale per row - Customer Name in Column A, Product Name in Column B, other data (irrelevant to my question) in other columns. Customer may have...

Ive only done tables in one column. I have some customers details as follows. Column CV Name Column CX Address Column CZ Grass Paid Column DB Grass Mileage I needed to delete a customer so right click delete rows only deleted there name leaving the other 3 cells to the right filled. I then...

Hi all, So I've started working with VBA a bit and have figured out what I'd like to do and that it is possible, I'm just not skilled enough to be able to write it from scratch. I've always found it easier for me to work with existing code and learn what everything does by modifying parts of it...

Hi everyone Please could someone try and help me? I am using the below code which works, it essentially is importing a set range of data from one worksheet into my main worksheet. What I need to do is set the worksheet name as currently it just imports the data into the activework sheet...

Hello, I would like to know how to create an IF query for multiple criteria. Basically I need to calculate commission based on the following criteria, brand type min margin if the type is used, then look at the sell price the answer to all of these will then need to look to know if what...