Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel-stock calculation macro (https://www.askmehelpdesk.com/showthread.php?t=292691)

  • Dec 15, 2008, 11:42 PM
    pradeepm08
    Excel-stock calculation macro
    I have an excel sheet which has columns- Item name, cost price, selling price, profit, buying price, no of articles sold, no of items bought etc.. If I purchase an item, I make an entry in a row with values only in Item name, buying price and no of articles bought. It I sell an article, I make an entry in the item name, no of items sold, cost price, selling price and profit. In another worksheet, I am maintaining the stock. If 10 pieces of item A are bought and 8 are sold, there should be an entry made in the 2nd workbook saying 2 items of type A are available. The sales and purchasing of the items is random.. i.e. the item A can b bought first with an entry in the 1st row, the item B can b sold with an entry in 2nd row and then Item A can b sold with an entry in the 3rd row. Please help me in writing a macro for this.plsss
  • Dec 16, 2008, 12:07 AM
    JBeaucaire

    It's not a macro that does this best, it LOOKUP or VLOOKUP... Post up a sample of your workbook, or email it to me and I'll give you a standard worksheet formula to lookup the data for you as you go.

    Jbeau AT madrocketscientist DOT com is my public email address.
  • Dec 16, 2008, 03:24 AM
    pradeepm08
    Hey JBeaucaire. I ve emailed u my sample spreadsheet. Please do have a look at it..
    It would be of great help
    Thanks in advance
  • Dec 16, 2008, 09:25 AM
    JBeaucaire

    Looks like you're reinventing the wheel, here. There are SO many ready-to-use portfolio tracking spreadsheets out there...

    I'm emailing yours back with one I recommend as an out-of-the box portfolio tracker.
  • Dec 16, 2008, 09:48 AM
    pradeepm08
    Hey thanks JB.. the portfolio sheet u've sent seems to be quite helpful..
    Thanks a lot again :)

  • All times are GMT -7. The time now is 03:42 PM.