Solved Formula in excel Header

June 29, 2014 at 23:54:13
Specs: Windows 8
I want to add excel formula and picture link in excel header.

I have person information in my first excel shhet of workbook like name, Bar code image, sex, age etc.

I have to link these cells name & Bar code image in header of second excel sheet of the workbook. Is it Possible.

Thank you.

See More: Formula in excel Header

Report •

June 30, 2014 at 04:46:46
✔ Best Answer
It is possible, but you'll need to use VBA - in other words, a macro.

Using a value from a cell is pretty straight forward, as explained here:

The image might be a bit more difficult. Can you give us some more info about the image and how it is stored in the worksheet?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 30, 2014 at 21:47:13

Thank for the reply.

It worked Properly.

I have an jpeg image of Bar code which is imported using Insert image which is in the first worksheet in excel say suppose (sheet1! B2) i want to link this image in header bellow name of person in second sheet.

message edited by gauravk

Report •

July 1, 2014 at 09:40:18
The one thing I'm still curious about is what you mean when you say "suppose (sheet1! B2)" AFAIK, a picture inserted into an Excel spreadsheet isn't really in a cell, it's just "on" the sheet. However, I'm always willing to learn so if you tell me otherwise, I'll believe you, after I test it. ;-)

However, the following thread discusses using VBA to insert an image - directly from a file - into the header. The code could be modified to pick up the path and filename from a worksheet cell or cells, instead of having the path/filename hardcoded into the macro. There are multiple ways to build the path/filename within VBA, so with some more detail I might be able to offer some suggestions.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question