Vba macro

[mamtasarkar]

Hello,
Someone guide me, i create stock inventory management with two userforms for inward and outward and four sheets for opening stock, inward stock, outward and net stock with A:G rows A stands for items , B= MAKE, C= GRADE, D= OPSTOCK Quantity, E= Inward qty, F= outward and G= bal.quantity, i execute formula for import qty from op, inward and outward but i can't import items, make and grade rows without repeating from opening stock sheet and from inward sheet, please guide me how can i call three rows from two sheets

 

[sijpie]

WHat can be done is that the macro adds an extra column to the inward sheet table. Then when a line is processed, this is recorded in this column. When you want to copy the new items to the stock table, then only items which have not been processed yet are then copied (without repeat).

Is that OK?

 

[mamtasarkar]

WHat can be done is that the macro adds an extra column to the inward sheet table. Then when a line is processed, this is recorded in this column. When you want to copy the new items to the stock table, then only items which have not been processed yet are then copied (without repeat).

Is that OK?

Yes, i understand but if i buy the same stock again then quantity should added but there is debug error and that time which formula is calculated qty in stock inventory sheet if macro run also for same stock inward entry, if its possible then please give me solution. If any formula you know without vba macro if you know