Listing with picture on Excel

[HoMyGod]

Hello,

Probably a stupid question, but I am trying!

I would like to use Excel to create a list of the staff in my company and I would like to add a picture of these people. We need to have :

Picture1 username1 lastname1 flor1
Picture2 username2 lastname2 flor2
...

I would like to insert the picture so that i am able to order by username or by lastname and the picture follow the sort!

Problem...pictures don't follow the sorting...How can I do that?

Thanks and regards

 

[xlbo]

hmmmm - I would use a proper database for this. Storing and displaying pictures is not excel's forte

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[01Patrik]

If you slect all pictures /F%/Spcial/"Objects") and make sure that the pictures move with cells ('Format picture', properties tab) and the fill the cell with something (a space would be sufficient). Now try sorting again, make sure the column with the spaces are sorted as well.

Should do it.

// Patrik
______________________________

To the optimist, the glass is half full. To the pessimist, the glass is half empty. To the IT Professional, the glass is twice as big as it needs to be.