Please Login or Register  to view this content.
I currently have this code, but it isn't working as I desire.

I have 4 sheets, but this part of my VBA is only concerning two of them: Sheet1 and Sheet3.

In Sheet1 I have a table where the user can enter up to 10 products to purchase goods. The user enters a "MemberID" into cell "B1". The user then enters up to 10 product names from cell "A4" up to cell "A13". I want the user to press a command button and the data will be sent to Sheet3....

Sheet3 is essentially a logging table, where a log of all the products are kept. If a product is in cell "A4" in sheet1 then it will be put into the next available cell in Sheet3 in column "C". If there isn't one then it will check cell "A4" and put it into Sheet3 and so on... However, I am not concerned about that yet, if this first problem is fixed then that can be fixed easily too. In column "A" in Sheet3 I have a PurchaseID, essentially a primary key. I want this command button to find the next blank cell in column "A" Sheet3, and then insert into it the next integer in the PurchaseID sequence. I have had a stab at it, but I cannot get it to work - what is going on? I can only seem to get it to put the PurchaseID for the first product (into row 2 Sheet3)and that is it.

If you still don't understand then post and say so.