Thread: Template Wizard with data tracking

If it's a sheet in the workbook then once you have established your database(table) you can use the inbuilt Form. You need to add the Form button to the QAT

Click a cell in the range or table to which you want to add the form.
To add the Form button to the Quick Access Toolbar, do the following:
Click the arrow next to the Quick Access Toolbar, and then click More Commands.
In the Choose commands from box, click All Commands, and then select the Form button in the list.
Click Add, and then click OK.
On the Quick Access Toolbar, click Form .

no, that lets me add to the existing database which is fine but not what i need

what i have is three sheets

sheet one - form
sheet two - database
sheet three - new data

i use the database to pull the info into the form via vlookup then i have to add a quantity field, this is then transferred to the new data sheet and that sheet is used as a database to print labels - i need to be able to add to the quantity field in order to be able to print labels with a variable quantity

i may be going about this the wrong way or making it a lot harder for myself i think

my original mission was to be able to print labels in Word with a variable quantity for each label - in order to do that i need a database with those quantities listed that way in can incorporate a field code to create the extra labels. the database this is feeding from has thousands of items so i figured the easiest way to do it was to use a simple form to create the scaled down list of just the items that need labels

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!