Calculate Cost Basis of Inventory

Thank you so much for your help...works great..
Will inform you if needed any further help on the same macro

This will save me tons of time...

Riz Momin

I thought i would be able to implement the macro in my original sheet which is hereby attached (Sample2)

I am having some difficulty.

In Sample2 worksheet, Brokerage sheet has all transaction.

i have created CostAve sheet in the same format as Sheet2 of Sample1 worksheet.

The calculated cost basis in need to go is in ShareCalc sheet of Sample2 column I..

Please see if you help me accomplish...


Help greatly appreciated...

Thank you,

Riz Momin

Riz

some things to try

1) Brokerage!F865 - Should be 1000
2) Brokerage!G865 - should be Microsoft
3) Turn on the sorting - this is a necessary step to getting the FIFO action working
4) Change the autofill line (second last row in the code) to be

  Range("M3").AutoFill Destination:=Range("M3:M" & Cells(Rows.Count, 1).End(xlUp).Row)

See how that goes.

rylo

I think this is working..

Once again thanks a lot for the help and will inform you for any furher needs..

Thank U,,

Riz Momin