Pasting Signature in Cell

[bobnplano]

I am using MS Excel 2000 on Windows XP (OS). I have created some information on an Excel worksheet that I have linked to another Excel worksheet (= 8 1/2 x 11 page) within the same workbook. The first worksheet is a simple list of addresses and (for all instense & purposes) case numbers & MAPSCO location. On the second worksheet, cells of information (on each row) from the first worksheet are then linked to a corresponding cell on the second worksheet on different rows. For example, cells of row number one (worksheet # 1) are linked to one or two rows & different cells of worksheet #2 (See Below). Each 8 1/2 x 11 sheet is then printed onto a preprinted form. One area of this form requires my signature. I want to scan my signature & paste it in a cell on worksheet # 1 & have it linked to a cell (in proximity of the space for signature) on this second worksheet (on subsequent pages) , so that each page that is printed already has my signature. I have tried using MS Word & MS Paint & Jasc Paint Shop Pro v. 7 but not able to get it to correctly select the signature & paste it in a cell. Can you help me or offer some suggestions? Thank you in advance.

Bob

Example:

Worksheet # 1 Address City State Zip Case Number Mapsco #

Worksheet # 2 Address City, State Zip Case Number
My Office City Mapsco #
Signature at bottom of page

 

[byundt]

Bob,
I just created a signature file in MS Paint, and saved it as .bmp, .png, .gif, .jpg and .tif file formats. All five imported into Excel 2000 using the Insert...Picture...From file menu item.

Note that the picture is attached to the worksheet at a certain point--it is not the cell contents. So you can't use a worksheet formula to transfer the signature from one cell to the next.

If you duplicate the worksheet, then the signature is duplicated along with the rest of the sheet. This suggests creating a "template" worksheet that you copy to make new worksheets.

One lesson learned from this exercise is that you should crop the frame to fit the signature prior to saving the file in MS Paint.
Brad