I have a jpeg on top of the words "picture a" in Tab #1 of a workbook. I would like this jpeg and "picture a" to be connected so that I can copy them in tandem via a cell formula to other tabs within the workbook. How can I do this?
Whats the difference between CONCAT and CONCATENATE?
I can think of no way to link cell text to a jpeg and call it via a formula.
You might however like to try something like this:
Right click each sheet tab in turn, left click View Code to open the VB Editor and paste this in the large code window:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
"C:\Documents and Settings\DEREK\My Documents\My Pictures\" & Target.Value & ".jpeg" _
Selection.Left = Target.Left
Selection.Top = Target.Top
You will need to change this part of the above code to the pathway to your own jpegs:
C:\Documents and Settings\DEREK\My Documents\My Pictures\
Alt+F11 allows you to exit from the VB Editor. Now when you enter the name of a jpeg in a cell, if it exists, it will be inserted into the worksheet with its top left corner covering the cell.