+ Reply to Thread
Results 1 to 3 of 3

daily sales extract from stock

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Exclamation daily sales extract from stock

    i wana macro code help me in subtract daily sales from my stock daily
    when i put the daily sales codes in sheet 1 and hit enter
    it subtract these codes from stock in sheet 2

    thank you...

  2. #2
    Forum Contributor
    Join Date
    08-23-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: daily sales extract from stock

    Hello, would you be able to answer a couple of questions for me?

    Is your sales sheet on sheet 1 a list of all the codes just like the one in sheet 2, and you just put a +/-1 in the cell next to it if you sold it that day? Or do you write the codes in when you sell them and want the macro to have to match the code to the one in sheet2?

    Do you mean you would like the macro to delete the code from sheet 2, or to subtract 1 from the existing stock of that code?

  3. #3
    Forum Contributor
    Join Date
    11-18-2014
    Location
    alex
    MS-Off Ver
    excel
    Posts
    135

    Re: daily sales extract from stock

    i mean when i write code in sheet 1 or i scan it by scanner it subtract 1 from the quantity of its stock "the same code and the same size " in sheet 2... if i can subtract it once i scan it it will be very helpful

    thanks alot

+ 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] Stock Inventory from Daily Sales, when a single product has various descriptions
    By barnesy1977 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-28-2017, 12:39 PM
  2. [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
  3. Would like to update stock list from daily sales list
    By DIPPYDOR in forum Excel General
    Replies: 6
    Last Post: 05-29-2014, 10:53 AM
  4. Extract first and last time of daily sales
    By sans in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2012, 12:48 AM
  5. Stock Inventory from Daily Sales, when a single product has various descriptions
    By barnesy1977 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-30-2012, 10:37 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