noobie
01-09-2007, 06:42 PM
Hi all,
I'm sort of stuck at this. Tried to find something close to it but no avail.
Here's the problem..
when i click the ' Add new button', a dialog box would appear asking for : Description,Opening stock and specifications. After inputting, the values/ words should go to their respective cells.
The macro should also paste
- after the last row
- with the similar format and formula.
I don't if this is actually possible cause it seems too complicated. But i attached a workbook hoping it will sort of convey my idea.
Pls guide me. Thanks!:bow:
I'm sort of stuck at this. Tried to find something close to it but no avail.
Here's the problem..
when i click the ' Add new button', a dialog box would appear asking for : Description,Opening stock and specifications. After inputting, the values/ words should go to their respective cells.
The macro should also paste
- after the last row
- with the similar format and formula.
I don't if this is actually possible cause it seems too complicated. But i attached a workbook hoping it will sort of convey my idea.
Pls guide me. Thanks!:bow: