Question

Locked

Stock sheet

By mickydm ·
Hi I want to link my invoice to my stock sheet so that when creating the invoice in excel I type in the code name for the goods and the name of item and price will pull through to the invoice and I would also like it to take it off the stock list. Is this possible. Pleeeeeaaaassse help. Thank you.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Check the Excel Wizards

by Tig2 In reply to Stock sheet

I am fairly certain that there is a template for that kind of thing built into Excel. Of course this depends on the version of Excel you are using.

Depending on the size of your baseline stock sheet, Excel may not be the best tool. Access may be better. I want to say that there is a template for this in Access as well but haven't used an Access template in years so can't say with any certainty.

Finally, Google is your friend. Check the web for templates. The operation that you are describing is a fairly common one.

Good luck!

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums