sales

Hi All Probably very simple but just cant find the right way to ask the question in google to get the desired response. I have a workbook that gets updated weekly based on current sales forecast. At the beginning of the sheet are several formulas which I currently adapt each week to point at...

Hey guys, I am trying to write a VBA way of filtering between two dates and by one criteria. For exmaple, I have a data on a sheet called "Sales Data" and date fields that are set in two different cells and a name in a third cell on "Dashboard". I want to be able to filter "Sales Data"...

Hi, I have created the following formula to calculate the ratio of monthly growth rate of sales of Product A (in row 3) when the sales of Product B (in row 4) are growing, to the positive growth in sales of Product B...

Hi, I have monthly sales data for two products arranged as follows: Column A: Consecutive month-end dates (e.g. 31/12/2018, 31/01/2019, 28/02/2019 etc) Column B: Monthly sales values for Product A Column C: Monthly sales values for Product B I would like to create a formula that will...

Hi all, I'm working on a workbook containing 150 sheets, 50 of which has "sales" in the sheet name. Is there a function that sum the same cell (like D3) of those 50 sheets? They are not in sequence, the 150 sheets are mixed up. Can we use a formula like - =sum( "'Sales" & "*!'" &"D3" )...

Hello, I have a spreadsheet, on the first tab is a large amount ofaccounts showing existing and new sales. Each account has also has a separate tab within the samespreadsheet. Where data (existing sales and new sales) is available onthe first tab, I would like a graph to automatically...

Hi all I've been trying to come up with a solution for a little while but am just not seeing what I need to do to get there... I was hoping someone on these excellent forums may be able to assist? Background: I have 5 tables with 12 columns each (i.e. months) in my back pages. The 5 tables...

I would like to add an additional row in my pivot table for percent of Gross Sales below each of the following categories. Any idea if this can achieved? Gross Sales POD Expense Commissions Rebate Discount Freight Costs Net Sales $4,69,655 $293,212...

I have tried to apply CF to use fill color Blue to Highlight Col A:C where "Total Sales WIP" appears in Col A It would be appreciated if someone could assist me, by providing the steps to do this

Hi I have "dept" as ListBox and I am trying to initialize it using With-End With but I got compiler error. Thank you so much. Private Sub UserForm_Initialize() With dept .AddItem = "hr" .AddItem = "it" .AddItem = "marketing" .AddItem = "sales" End With...

Hello, I am trying to calculate the percentage change between two columns of data. Everyday I get sales data and I am trying to compare today's sales to yesterday's sales. The pivot table is simple: The sales item and division that sold it in the Rows, Date (Yesterday and Today in Columns)...

i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when the criteria is changed. i am able to highlight one cell using conditional formatting, but is...

just a little help needed. 3 tables on one worksheet that change depending on what is selected from drop downs. is it possible to look up the values from the first table (sales for advisers at a selected site) and then highlight certain fields in the other two tables? so id like it to look at...

Having a lot of issues trying to resolve this problem. so i currently have 3 league tables. each league table is then automatically changed depending on the options selected from some drop downs. shows the sales of staff at a particular site. You have an option of new sales, used sales and...

Hi everyone. Long time lurker, first time poster, this site and the users have provided me with great knowledge over the past few years, so thank you to everyone. I'm getting a bit deeper than I have needed in the past and need a little assistance b/c I could not find what I was looking for...

Hey team! I'm working with some hierarchical data output from our ERP system's vanilla reporting software and my finance team wants a low maintenance excel spreadsheet that identifies all of the levels of a hierarchy as attributes / dimensions. Our hierarchies are built as parent/child combos...

I have a PowerPivot table similar to the following (obviously thousands more lines): <tbody> P&L Category Amount Something else I may Pivot on Sales 100 A Sales 100 A Discounts 20 A Discounts 30 A Returns 10 C Sales 200 C </tbody> I want to get a summary of Net Sales in a Pivot...

Hi, I need to be able to summarise the table below to show who was doing what hour by hour so that this can be used in a database. Essentially I need to extract an hour by hour view from the large table below to just return this: <tbody> 08:00 name.1 SALES 2 08:00 name.4 TRAINING 08:00...

HI Guys i have the data below <colgroup><col span="2"><col><col></colgroup><tbody> group ID Department products A 1 sales pc A 2 marketing pc A 3 marketing ons A 4 HR pc A 5 marketing tons A 6 marketing pc B 7 sales pc </tbody> I want to do a count if , using this logic...

Hi all, I am relatively confident an answer for my question already exists, but my googlefu/excel vocabulary has proven too weak to find it. I apologize! I am working on pulling in sales data and creating a chart. I have about 200 SKUs, and Prior Year sales data (by month), YTD sales (by...