Sales Report From Sales Data Sheet If Select Date

Feb 4, 2013

I wanted to get the data from data sheet where i have entered the data manually for sales what have done

Now I wanted is when i enter date i should get the product and price in other sheet

Example:

If I enter date in a1 cell

I should get the detail of product in b1-b10(if i sold 10 item )which is in data sheet

And c1 - c10 price (if i sold 10 item @that price)

View 4 Replies


ADVERTISEMENT

Sales Summary Sheet - Consolidate All Data In Sales Order Number Wise

Jan 5, 2012

I have an excel sheet which has 70 sheets in it...All of them are numbered but not in a sequential manner (eg : 210,211,201,202,215 etc..).The numbering is nothing but the sales order number....

All the sheets have same data (i.e Column A contains Product Sold, Column B contains Sale Value)...The thing is i want to consolidate all the data in sales order number wise. i.e.

Column A Column B
201 $200
202 $300
203 $450

View 8 Replies View Related

Excel 2010 :: Sales Daily Sales Data To Be Aggregated Into Monthly Data (not Using Pivot Table)

Mar 27, 2013

I cannot solve with Excel 2010 and I have searched all over for the answer.

I have sales data that is approximately daily and would like to count the monthly data and summarize it as an average for the month in a separate column.

For example, I would like to turn this:

3/2/2005 $xxxx
3/5/2005 $xxxx
3/20/2005 $xxxx
4/2/2005 $xxxx
4/10/2005 $xxxx

Into this:
March 2005- $xxxx (monthly average)
April 2005- $xxxx (monthly average)

I have a feeling some 'countif' formula would work but I am not sure how to do this.

View 4 Replies View Related

Determining Top Contributors To 50% Of Sales Based On Cumulative Percent Of Sales

Jul 2, 2009

I am trying to determine the top contributors to 50% of sales based on cumulative percent of sales (see attached file). I can determine if percent of sales is less than 50%, but I need to include the person that pushes the group of top performers over the 50% mark.

View 3 Replies View Related

Pivot Table: Calculate Percentage Of X Sales To To Total Sales

Feb 20, 2008

See the attachment. I want the percentage of Car Sales to total sales of different countries automatically.

View 2 Replies View Related

Using Rolling 12 Month Sales And Minimum Monthly Sales?

Oct 17, 2013

I have a sales level that I need to track...My rolling 12 months' sales must be $85,000 and my currently monthly sales must be $7,000. I have a sheet that tracks the $85,000 and tells me what I need to achieve that, but I haven't figured out how to include the $7,000 monthly minimum....

The chart below is what I have. So for example, this month it's telling me I only need to sell another 3016.46 to hit the $85,000 rolling 12, but I actually need to hit $4821.79 to meet the $7k minimum.

Actual Rolling 12 Goal
Sep 2012 5,367.24 73,663.30
Oct 2012 5,649.93 69,496.28
Nov 2012 14,163.38 73,451.30 [code]....

View 6 Replies View Related

Finding Current Month Total Sales Using Current Month To Date Sales In Formula / Macro?

Aug 20, 2013

Basically, I'm doing a recorded macro for work where I take an export and manipulate the data to show differences between sales from last year and this year. Also comparing this months projected sales to avg of last 6 months and also against last years this month.

The problem I'm running into is in automating the this month sales for mid-month exports. I can do it individually but I can't find a formula that will do it. Data is in one cell per month, so ex. 130 sales this month so far. I need to have it convert that to projected sales for total month based on what day it currently is.

View 1 Replies View Related

YTD And Period Sales Report

Feb 2, 2008

I have an Access DB that I query with excel and I pull two years worth of sales data. I have tried using a pivot table report to display the following data, but I can't figure out how to display the data in the following format.

The pivot table will give period and YTD but the totals for YTD are not cumulative for the year up to that period (it seems to total the period only).

For the current Year- period (month) and YTD (only up to the period displayed).

For the last year- period and YTD (only up to the period displayed).

The fields I query are Customer, City, Product, Salesperson, Period(month), Year and Sales

I have tried putting the queried data on one sheet and then using formulas on another but I am not having any luck.

I would also like to be able to select which period I am viewing but this is secondary.

I can upload an example if necessary.

View 5 Replies View Related

Summarize Monthly Sales From Daily Sales

Jan 5, 2010

I have daily basis monthly sales. Now I want to summarize into monthly gross. Pls look attached file. I am looking for a formula to summarize January daily sales from date 1st to 31 st as of just January and and sum of each day gross.

View 4 Replies View Related

Formula To Calculate Sales Tax From Total Sales

Jan 4, 2005

I have created a chart on excel for us to track daily sales but also to figure sales tax so we know what to send the IRS each month. We have been figuring the sales tax ourselves and
filling in the chart on excel but I would like to create a formula that
automatically does it for me based on total sales.

View 9 Replies View Related

Sales Budget Variance Report

Mar 16, 2014

I am trying to do my homework for college and the below excel grid was given to us to complete. I do not understand where to get the information it is asking. the first grid is the numbers we are suppose to use to input in the other grids. We are suppose to put a formula in on the last to two columns on each grid but I do not even know where to start.

Budget

Actual

Product
SaleUnits
$/Unit

View 7 Replies View Related

Creating Sales Report / Template

Jul 24, 2013

I need taking thousands of line items of raw data and creating a model that can present the totals in an easy to read format. I've attached a sample of what my data dump looks like....though the actual dump is thousands of line items.

Data.xlsx‎

View 1 Replies View Related

VBA To Automate And Email Sales Report

Jul 24, 2013

I have the task of pulling results of an Access query into Excel, formatting them in a "standard" way (the data will be formatted the same everytime in every report), then AUTOMATICALLY emailing them at a pre-determined time everyday.

1. I have tried using the record macro function, and it works as far as pulling in query results and formatting them
2. Then, using the macro i recorded, i added onto it so that when I manually run this new macro, the whole thing gets emailed, but it is not automated. My issue is not having to manually run these macros and have them run as scheduled tasks.

View 2 Replies View Related

Sales Report- Copying And Pasting One By One

Jun 11, 2009

I have multiple customers in a list that I would like to create individaul tabs for each, with customer name and store #, and at the same time utilizing my sales sheet template for all customers. Is there a way to do this without copying and pasting one by one.

View 9 Replies View Related

Get 5 Top Sales People Names And Their Sales?

Oct 3, 2012

In cells A4 to A54, their names are displayed.
In cells I4 to I54, their total sales are displayed.

Starting in cell B59 and C59 I'd like to display their name and sales respectively.

Also in column I I'd have a second value which would be a total of each department. Would it be possible to leave this data out of the formula? No big deal if I have to put that value in the next column.

View 9 Replies View Related

How To Create A Report To Show TOP 20% Based On Sales To Grand Total

Mar 5, 2012

Let's say I have a list of 200 customers with their business name in column A and their total 2011 purchases from my company.

How can I create a report to show the TOP 20% based on sales to grand total.

Basically, of my total business last year... I want to see the top 20% of this customer list that contributed to my total business.... and so on... to show top 40%, top 60%, etc. So, did 5 customers contribute to 20% of my total... or was it 10, 15?

Let's start with the above 1st.... but I want to also know if I can make this report (or maybe dashboard) dynamic? I'm pulling my sales from a database, and want to be able to refresh this report periodically throughout 2012. The list of customer will grow throughout the year too.

View 3 Replies View Related

On Weighted Percentages - Create A Report That Rank Top Sales Agent For The Month?

Jul 29, 2014

I have been asked to create a report that rank top sales agent for the month with the following variables:

Total # of sales-35%
Total $ of sales-45%
Number of calls made-20%

Given that there is more than one variable they have placed percentage weight on each. Thus my task is to cull said percentage and add their total thus getting a figure which would represent their ranking depending on how higj or low the total is.

View 3 Replies View Related

Copy Week Total In Weekly Sales Worksheet To Appropriate Week In Monthly Sales

Oct 14, 2009

I need to copy the values of a range on the weekly sales worksheet to the monthly sales worksheet. The last column is the total on the weekly sales. Part of the heading of the total column is the week ending date (e.g. 10/17/2009. On the Monthly Sales I have the months in columns by week ending (e.g. 10/17/2009).

Range I4:I28 to the monthly sales worksheet by date.

View 10 Replies View Related

Data Validation: Restrict The Value Entered On A Sales Sheet To Force The Value To Be Over 15% Margin

Mar 12, 2009

I want to restrict the value entered on a sales sheet to force the value to be over 15% margin. In column M you enter a value in column N it report the margin. I want to force the value in M to give a minimum 15% in column N or report an error.

View 3 Replies View Related

Sales Order Sheet

Feb 13, 2009

I want is for the the cover sheet to provide a simplified version of the price list for people to use that will auto complete price to customer once product has been selected.

- how do I create a sublist? so if a user selects a product group from a drop down list in cell b1 then cell b2 will automatically display only the items from that groups subset.

- how do I link prices? If a user selects data from a drop down menu in b2, is it possible to display the price for that item in cell b3?

View 4 Replies View Related

Sheet For Daily Sales

May 18, 2009

I have a query regarding making a Excel Sheet for Daily sales.

here I go,
Well i want to make an Excel Sheet where in I just need to enter the Date, Invoice Number , Product , No of Product and rest it should calculate the VAT (Rounding Off) amount N den the Grand Total..

M givin you an example in the Below Sheet.

View 9 Replies View Related

Daily Sales Sheet To Refresh With Every Day

Jul 15, 2014

I am trying to build a sales sheet that will keep all the records during the month but every day it refreshes to a blank sheet, then allowing users to flick back to a previous day and all the data from then is still saved?

I think this is possible in excel as I am sure I have seen a working sheet before but I don't know where to start or even what the process would be called in excel?

View 1 Replies View Related

Create List Of All Sales Older Than Specified Date

Jan 26, 2012

Code that will do the following,

In sheet2 cell B2 i have a date (for example 12 Jan 2011)

I want to look at sheet1 columB and if the date is older than the date in sheet2 cell B2, then copy then all the data from that line in sheet1 be copied over to the first free line in sheet2 I need the data from colums B to ZZ to be copied.

View 1 Replies View Related

Counting Week To Date Sales By Branch

Jun 9, 2009

I have to produce a report which shows how many sales each of my company's eight branches has sold this week. The problem lies in the fact that my manager wants the week to start on a Friday, so effectively I need to count the number of sales for each branch since the last friday (including Friday but not today, ie today's report would count all sales from 05/06/2009 to 08/06/2009).

Is this possible?

My data is as follows: Branch name is in column P, Date Sold is in column S. I have added a column which is next to Date in column T which has "=WEEKDAY(S2)" to give me the week number which I was using to try and count but failed miserably!

View 9 Replies View Related

Line On Sales Tracking Sheet To To Transfer To Sheet 3 Automatically

Mar 20, 2014

Once a job is complete on a sales tracking sheet I created, it needs to transfer automatically once I click on a "completed" section of my work sheet.

View 1 Replies View Related

Creating Auto Costing Sheet For Pre-Sales Function?

Oct 9, 2013

I am trying to create a spreadsheet that uses a selection criteria based on different sheets within a workbook to output a costing quote, anything i can use as a template? I will post the sheet that i am working on that I need to combine into a working book.

View 2 Replies View Related

Predicting Sales Data

Jan 10, 2009

I have data for average turnover per hour of a business and have fitted it to a polynomial (order 6) trendline. So I have for example, running along the x-axis i have 8am-9am, 9am-10am, 10am-11am etc and on the y-axis the average turnover for the relevant hour.

What I would like to be able to do is use the trendline's formula to be able to predict sales for any given day. So if I were to enter the first few hours of turnover on any given day, I would like excel to predict the rest of the day's turnover based on the trendline.

View 10 Replies View Related

Summarizing Sales Data

Feb 26, 2009

I'm stumped on what I know is a pretty basic problem. Maybe i'm just trying to over think it.

I have a table of sales data...One field is the date it was sold, one field is the amount it sold for. The date field isn't in order and it contains dates over the past 12 months. I need a way to total the amount of sales in each month and not through a pivot table. I am able to count how many entries there are, but I can't find a easy way to do a count of how much was sold in each month.

View 6 Replies View Related

How To Chart Sales Data

Aug 28, 2012

I am trying to create weekly sales charts from my worksheet. The variables I have are the items in inventory, their respective price points, and units sold week by week (for about 5 weeks so far). I am having trouble formatting all of this information in the correct way to get accurate charts conveying the movement of our inventory.

View 1 Replies View Related

Extrapolation: Sales Data

Aug 18, 2008

So I have a Sales Data Extrapolation question.

I have August sales data up until August 17th. I need to extrapolate the data to determine what my sales numbers will look like for the entire month.

Here are some of the specifics: 17 days of sales so far, sold 12,598 units. Total stores 1,500

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved