customer

Would like to reach out to this community to ask for help. I have been creating some user forms in Excel but I am stuck when it come to creating user form to enter customer orders. Any recommendation would be greatly appreciated. User Form would generate a SO auto number 1234, however would...

I have two columns, on the first 1000 customer numbers and in the second an account number. About 500 customers have multiple account numbers. I want to reduce the lines. I want only one line per customer number and in column two a string of the corresponding account numbers delimited by the &...

I'm scratching my head with this conundrum I have two similar reports that mine the same data which lists transactions. In my first report I have a column which shows the date of the last invoice raised to a customer: {=max(if(Retailer=A1,InvDate,"None"))} In my first report, if there...

Hey there, I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work? =IFERROR(INDEX(Number; MATCH(0; COUNTIF(F$14:$F14;Number)+IF(Priority<>$C$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "") I want the selectedcustomer to...

Hello Experts,i have a little challenging question but not challenging for you for sure , i have some customers data and stock and prices , i need to fill in a table for invoices and distribute the stock randomly between the invoices so that each invoice value does not exceed 5000, same...

I have a list of customers each with a unique ID number Each customer can show up multiple times on a very large report. The customer ID stays consistent throughout and does not change. Each Customer can have a status of Ordered or Ordering or None Using the customer number I need to know which...

I have an invoice called (Invoice). I would like a script to get the invoice number, customer number and each line item, including Quantity and Amount for each item. I would like to get this information into another sheet in my workbook called (Invoice List 2).I have found some scripts online...

Here is the formula: =AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days I tried =IFERROR(AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days],"") it will not calculate.

Hi all. I am new to this forum. I don't waste time and just raise my questions now, I am a very lack of Excel knowledge. I want to create an invoice for my clients Where every time I enter a new name of customer or customer ID (to be defined by me), then it will generate a customer list and...

Hi Guys Im looking for some help on a formula in a powerpivot to bring back the latest date for each Customer I am currently using =Maxx(filter(query,query[Customer]),query[Last_sale_date]) but doesn't seem to work Any advice Regards Soph

Good Morning Everyone; I am somewhat proficient in excel. I have an workbook that I am working on. I have a invoice template on one sheet with 2 columns that have a drop down box. The other 3 have qty., unit price and total. The second sheet has a list of products and the fragrance they come...

Previous thanks goes to Fluff for figuring out the code I have posted below (about a year ago I did this.) The code works brilliantly, but i am looking to further 'drill down' on the criteria... here is how it currently works: I have a spreadsheet as shown with columns containing the different...

Hi everyone. I run a window cleaning company. I have two pages on my spreadsheet, one with a list of invoices, the other with customers. They usually have regular work. So I want a column in the customer sheet to be constantly looking at the invoice list. Everytime a new invoice is...

I want to hyperlink two numerical lists on different worksheets. Is this possible? For example, each person in this test worksheet is assigned a number (18-01, 18-02, etc.) WORKSHEET # 1 <tbody> Customer # First Last EMAIL 18-01 Ted Mosby 18-02 Chris Smith 18-03 Tony Adams...

Hi all, This may be a bit of a long shot but I am trying to create or put together a VBA Macro for package distributions that will send out multiple email notification emails at once to the approriate point of contact each with slightly different subject header based on their location and the...

Hi all, I don't speak english very well but I will try to describe my problem. I have a combobox with names of customers on "Sheet1". The name of corresponding contact person and his email will show in C24 and C25 after choosing a customer from combobox. I have list of customer on "Sheet2"...

I'm having a hard time figuring this one out. I am building an exhibit where I display a list of brokers groups by the employee that they work with. my source data looks something like this Broker Contact customer 1 employee 1 customer 2 employee 1 customer 3 employee 2 customer 4...

Hello all, I'm completely stumped with something on excel. I'd like to think of myself as a decently proficient user but I just cant get to the bottom of this. I've started a new job in a call centre and we have data that is annoyingly formatted. We have multiple customers and it is formatted a...

Hi All we are wanting to calculate the lifetime value of a customer. I have history table of 3 columns (10k of entries) with the customer name appearing every time they have ordered over the past two years. Is there a way I can count the number of times a name appears in a list. Ideally...

Hello Everyone, Could someone let me know if there is a way to add the results of a calculation into the comment for a selected range? if so, could the results in the comment change if any of the values change? GM% Formula:(Customer A Price - Cost) / (Customer A Price) <tbody> Cost Customer...