I'm doing some work in excel, and I need to create a stock file and ordering system for my course. I have a stock file worksheet, and a purchase order worksheet. When a purchase order is placed the user enters the amount of an item that was ordered, I need a way of having this number add to the number in stock column in the stockfile worksheet. The problem is, it needs to add the number only once, as the number ordered in the purchase order worksheet is cleared to "0" for the next order to be placed. This then takes the number in stock back down. Hope that makes sense. Please help :D

the way i think : u make a list in a part of ur stock sheet , with a sum on the top, including the 1 to 500or + lines below. With an autoexec macro, u reach the top of this list, just down ur sum and make a research (for example as long as isempty lc"" select l(+1))to reach the 1st empty field, and next u take the order field concerned to put in it. Ur macro saves ur stock sheet and is ready for a new order. In ur stock sheet, u only bring the sum from the top of ur list.

Sorry, but i'm lost there.. can you describe exactly what I have to do to make it work.

shortest way could be: open ur folder. with 2 sheets "order" and "total order" go in ur "order" sheet. Register a new macro select order cell wich contains ur order number u want to add to the total copy select "total order" sheet, select the cell which contains the total, then special paste / add then select "order sheet" and ur order cell and tape "0" then end of macro. Each time u'll execute this macro, it 'll take ur order number and add it to the total . That's what u want?

Thank You very much!!! I can't tell you how much help that is! I had never even used paste special :) Thanks again..