Forum

Notifications
Clear all

address pictures from on sheet to another

6 Posts
2 Users
0 Reactions
69 Views
(@lbcowanbell-net)
Posts: 3
Active Member
Topic starter
 

I have started a picture directory, (limited knowledge) and have personal information on one sheet and picture on another.

I want to populate the residents picture in a cell based on another cell (Lot #) on the first sheet

Can you help me out

 

not able to load my file

 
Posted : 22/04/2023 11:06 am
(@lbcowanbell-net)
Posts: 3
Active Member
Topic starter
 

https://www.dropbox.com/s/gky77ds24piy1dk/OMS_IMAGE_SentOut.xlsx?dl=015

 
Posted : 22/04/2023 11:21 am
(@keebellah)
Posts: 373
Reputable Member
 

I'd like to help but cannot download the file, just see text and pictures but I need the file to help.

Login to dropbox is denied

 
Posted : 25/04/2023 1:59 am
(@lbcowanbell-net)
Posts: 3
Active Member
Topic starter
 

File attached.

 
Posted : 25/04/2023 9:42 pm
(@keebellah)
Posts: 373
Reputable Member
 

First of all the file you sent me has a for me unreachable link (C:VolumesOMS_DIRDirectoryBackupMarch2023 2 copy.xlsx) so the value in column O in the Master Sheet is #REF.

 

What I see as a serious issue in the Image sheet (which I assume is the sheet where you want to read the pictures from ) is in mho entirely unmanegeable due to the picture's names. I would name these according to the Lot number

Take Picture2 in B3 why not name it lot_1 in this way when you place the number in Dirprint F5 if will lookup Lot_1 and place it there.

As far as I know it has to be done with macro's so I'll look it up and see if I can do something for you.

 
Posted : 26/04/2023 2:34 am
(@keebellah)
Posts: 373
Reputable Member
 

Just an update: time was out of my hands so could not work on my idea.

Will try to work on it and update ASAP

 
Posted : 29/04/2023 2:32 am
Share: