+ Reply to Thread
Results 1 to 2 of 2

Sort Daily Sales Item by VB Code

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Sort Daily Sales Item by VB Code

    Hello:

    Please refer to attached file.

    Every day I get report data as shown in column A thru E
    Column A : Date
    Column B : Item
    Column C : Qty
    Column D : % Items
    Column E : Amount
    Column F : % Amount

    I need a VB Cdoe to summarize daily data as shown in column K thru AP.
    Cell L2:AP2 list the items
    Cell K3 down shows each day of the year.

    Basically the code need to ask :
    Which data do i need to use:
    1 Qty
    2 % Items
    3 Amount
    4 %Amount

    Depending on above selection, code would need to use data from column C,D,E or F.


    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Sort Daily Sales Item by VB Code

    I took the liberty to calculate all 4 reports since for the % qty and the % amount you would need the daily totals anyways
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Making Daily Sales Planner recognize which month and which week to pull sales data from
    By Topher53180 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-30-2014, 10:33 AM
  2. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  3. Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  4. [SOLVED] How to sort the data by item code first, then sort them by date?
    By Zecond in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-04-2013, 01:55 AM
  5. [SOLVED] cumulating by adding previous sales to daily sales
    By kish_gv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2007, 03:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1