+ Reply to Thread
Results 1 to 1 of 1

macro to get sum of sheet 1 subtract with sum of sheet 2 and input value of sheet 3

  1. #1
    Registered User
    Join Date
    06-26-2015
    Location
    Brazil
    MS-Off Ver
    O365 Win
    Posts
    63

    macro to get sum of sheet 1 subtract with sum of sheet 2 and input value of sheet 3

    Hi Everyone, again, sorry for a confusing topic.

    I am creating a spreadsheet for my mother-in-laws croassant bar (you might have seen my first request of help here yesterday).
    The purpose for this is to help her control what is being sold and whatnot since we cannot trust the employees of this very small business of hers.

    I had the help of Alpha Frog here on my first request, thanks again Alpha Frog. Here he helped me to create a macro where all sales would be added onto another sheet called Short (for sales).

    I am not sure who can help me on this second request, but appreciate all help:
    Macro 1) By the end of every week (Saturday) have the values of "Short" automatically sent and subtracted on sheet called Estoque (stock in Portuguese). All croassant flavors will be added, we just want to know the total number of croassants sold (either normal or whole grain - integral). The names of the products in "Estoque" are on column A and should match names on the rows "Short", value should be subtracted on Column B.

    Macro 2) Every time she goes to purchase something, she goes to sheet Compras (purchases in Portuguese) and inputs whatever she bought on column B. Column A has the names of the products that matches sheet called 'prices', when she has finished inputting, a button is pressed where all the values will be added to column B in estoque.

    With the above macros, I am trying to achieve a kind of stock control, where at the end of the week she will know what needs to be bought, what was sold, what was missing. Does it make sense to any of you? Can someone help me? :D

    Attached is the spreadsheet. Again, most macros were made with the help of Alpha Frog, I am not good in programing at all.
    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] Issue regarding recorded Macro to transfer data from Input sheet to Storage sheet
    By Hirad001 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2015, 04:26 PM
  2. How to transfer data from a daily input sheet to a separate monthly total sheet
    By Jcooper71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2014, 02:37 PM
  3. Macro: Create an input sheet an copy the data onto a new row in another sheet
    By bernardnoel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2013, 09:23 AM
  4. [SOLVED] Particular data taken out form input sheet to desire sheet by macro
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2013, 01:52 PM
  5. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  6. Replies: 1
    Last Post: 07-30-2012, 02:35 PM
  7. Replies: 9
    Last Post: 04-04-2011, 12:03 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