Dear all,
Except writing some html in my youth I'm pretty new to programming. I've searched for an Excel template for my business needs, but I couldn't find what I needed. That's why I've started altering a allready existing template a couple of weeks ago and it's going pretty well, untill recently.
In the first "stock" sheet I have a summary of (used) items I have in stock. In the other "selling" sheet I select the items and quantity I'm selling. Now I need the entered the quantity of items in the "selling" sheet to be substracted from my "stock" sheet when I click a button (I already have a working button linked to a macro). When the quantity reaches zero in my "stock" sheet the row needs to be partial removed (the first 11 columns) because there are references in the other cells. Finally the empty rows have to be deleted to avoid getting a immense list.
I would really appreciate it if you can help me with this. Despite the fun I've had learning to program vba and the information I've found on the internet I'm starting to get desperate. I just can't get it working.
Kinds regards,
Rutger
Except writing some html in my youth I'm pretty new to programming. I've searched for an Excel template for my business needs, but I couldn't find what I needed. That's why I've started altering a allready existing template a couple of weeks ago and it's going pretty well, untill recently.
In the first "stock" sheet I have a summary of (used) items I have in stock. In the other "selling" sheet I select the items and quantity I'm selling. Now I need the entered the quantity of items in the "selling" sheet to be substracted from my "stock" sheet when I click a button (I already have a working button linked to a macro). When the quantity reaches zero in my "stock" sheet the row needs to be partial removed (the first 11 columns) because there are references in the other cells. Finally the empty rows have to be deleted to avoid getting a immense list.
I would really appreciate it if you can help me with this. Despite the fun I've had learning to program vba and the information I've found on the internet I'm starting to get desperate. I just can't get it working.
Kinds regards,
Rutger