Sorting with pictures

[Secret Squirrel]

I have a spreadsheet that has pictures along with other employee data below
it that I would like to sort. The first cell has the picture in it, the next
cell has the employees name, and the next cell has the employee's hire date.
Then a cell is skipped and then there is another employee's picture along
with the data below it. This happens 10 times down the column. Then a column
is skipped to the right and then a new column is started. I have 7 columns
total across. When I add a new employee to the bottom of the list I want to
be able to sort it by the employees name cell and have it put everything in
order alphabetically and take the picture along with the hire date cell as
well. How can this be done?

 

[Jeremy]

Does Highlighting all and sorting by a second column not work?

 

[Secret Squirrel]

I don't think so because how will it know which employee name and hire date
go with which picture? That's the problem. I want to keep the hire date and
the employee name tied to their picture but since they are all in separate
cells there is no way of linking them together.

 

[Gord Dibben]

Pictures cannot be inserted into a cell but if you size the picture so's it lies
entirely within the cell boundaries, it will move with the cell if you have
formatted it to "move and size with cells"


Gord Dibben MS Excel MVP

 

[Secret Squirrel]

I'm aware of that but how do I sort my pictures along with 2 cells below each
picture? I want the picture to be sorted along with the employee name and
hire date which is the 2 cells below the picture.

 

[Gord Dibben]

My mistake. Did not read properly.

I assumed that your data was across one row.

For the purposes of sorting and filtering I would suggest each person's data be
entered on one row.

Name Picture HireDate Otherdata

Otherwise I don't know how you will sort or filter by name or whatever.


Gord