Ask Experts Questions for FREE Help !
Ask
    pradeepm08's Avatar
    pradeepm08 Posts: 3, Reputation: 1
    New Member
     
    #1

    Dec 15, 2008, 11:42 PM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Dec 16, 2008, 12:07 AM

    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.
    pradeepm08's Avatar
    pradeepm08 Posts: 3, Reputation: 1
    New Member
     
    #3

    Dec 16, 2008, 03:24 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #4

    Dec 16, 2008, 09:25 AM

    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.
    pradeepm08's Avatar
    pradeepm08 Posts: 3, Reputation: 1
    New Member
     
    #5

    Dec 16, 2008, 09:48 AM
    Hey thanks JB.. the portfolio sheet u've sent seems to be quite helpful..
    Thanks a lot again :)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Auto-Macro in Excel [ 4 Answers ]

Hi, I have a lot of macros built-in Excel, but when I want to update the certain data , I have to run them individually each time. Do you know anyway I can auto-run these macros? Thanks for any help.

Recording a macro in Excel [ 2 Answers ]

Need a macro that will select the cell one place to the left, edit the content, hit enter, and then move to cell below where started and repeat to end of column (last cell with a value). Example: 123-456789 is format of cell to be edited - need to remove the hyphen. Someone had created it...

How to Automate a macro in excel [ 4 Answers ]

A program logs files at random in txt. abc_log.txt (example) When new info. Is added to the txt file,manualy activate macro and it does what it suppose to do, all OK there. Is there a way a macro code or excel, or perhaps a BAT program can be made to simply "detect" when new data is added...


View more questions Search