Inserting pictures then sorting

[Dav]

I have a sheet containing data in the first few columns then a column containing references to pictures. Can these pictures be imported into the cell next to the reference eg data is in columns A & B a reference to a picture in columnC. If the pictures refered to in column C can be imported into column D.

I can then sort by the data in columns A & B and print out the pictures I am interested in.

Obviously this is a simplified version of what I require as there are hundreds of lines of data but hopefully you will get the picture. I could use file insert picture, but this would be highly time consuming and hopefully the task can be automated with a macro, but I am fairly new to writing macros




If anyone could help that would be great

Thanks

Dav

[Dave Peterson]

Something like this might work for you:

Please Login or Register  to view this content.

Dav wrote:
>
> I have a sheet containing data in the first few columns then a column
> containing references to pictures. Can these pictures be imported into
> the cell next to the reference eg data is in columns A & B a reference
> to a picture in columnC. If the pictures refered to in column C can be
> imported into column D.
>
> I can then sort by the data in columns A & B and print out the pictures
> I am interested in.
>
> Obviously this is a simplified version of what I require as there are
> hundreds of lines of data but hopefully you will get the picture. I
> could use file insert picture, but this would be highly time consuming
> and hopefully the task can be automated with a macro, but I am fairly
> new to writing macros
>
> If anyone could help that would be great
>
> Thanks
>
> Dav
>
> +-------------------------------------------------------------------+
> |Filename: Example.txt |
> |Download: http://www.excelforum.com/attachment.php?postid=3982 |
> +-------------------------------------------------------------------+
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=480860

--

Dave Peterson

[Dav]

That has saved a colleague a huge amount of work and will greatly add value to our survey process as pictures of handwritten text can be included with parts of the survey. Its made my day!

Dav