I have been using excel for this, but I am not sure it is the right program.

I disassemble a lot of very complex parts. As a part is removed, it is written down. The fasteners are placed in a ziplock bag, and a label is put in the bag saying where these fasteners are used. Often pictures are taken to facilitate reassembly that may take place a month or more in the future. Often I will have as many as 100 lines for any particular project. then upon reassembly, every removal line is verified to ensure that nothing was over looked.

Now I am trying to automate a lot of this. What ever data is typed into a cell, I would like to click a macro button and have just that cell printed to a 1 inch by 4 inch label. I have a dedicated dot matrix printer just for these tractor fed labels. Basically, what ever cell I am in, that is the cell value that I want sent to the printer. the labels have to be printed one at a time as the removal line is entered. If I tried to print all the labels at once, there is no way I would remember which label fit which ziplock bag. Is it possible to set up a macro that sees what cell I am in, and sends that cell data to the printer? It would actually be better if I could have a heading field that would list the project number and the date, and then the label would have the project number, date and item printed on it. Is this possible?

Another macro button I would like is to insert a jpeg. I would like all the jpegs the same size. If there is a difficult area, for clarity, I would like to enter a jpeg for what ever item I am on. I am hoping to click the button and have an insert pic pop up with a browse screen. Then I would just select the pic and it would be inserted in to a cell for the particular line I am on. Any advice/help setting this up would be appreciated.

Is excel the right program for this? Help setting up the labels to print would really be appreciated.