Button for adding a new line across multiple sheets, inputting data to certain cells

Hey Everyone,

Here's my situation. I have a liquor accounting and ordering system I'm introducing for a small chain of restaurants and bars, and there are many different products across them all. To implement this system, one hurdle we are looking into is an easy way for a certain location to add a new product into their inventory.

The system is a 4 page worksheet, and what I'd like is to be able to push a button and have a dialog box pop where they could fill in the information needed to add a product. They would select a row in the section they want to add a product, fill in some info about the product, and it would insert that data into a couple different cells across the workbook, always on the same row.

This is what I have so far, I copy and pasted something from someone else who was doing something similar and tweaked it, but I'm not sure how to paste different information into different cells on the different sheets. It is also copying any information that doesn't have something to input from the line above it.

Please Login or Register  to view this content.

So an example of where I would want the data to go would be something like in the first page, the order would be Cell 1 NewName, Cell 2 Packsize, Cell 3 BtlCanOz. Then on the worksheet labelled "order par sheet" I would need the same row to have Cell 1 NewName, Cell 2 Packsize. On Worksheet labelled Order, I need Cell 1 CSPC, Cell 2 NewName

Thanks Everyone, any help is really appreciated!

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(Because you are new to the forum, I have added them for you today. Please read all Forum Rules and comply in the future.)