Using Excel to create a customizable catalog

I am attempting to create a type of customizable catalog using Excel. This idea is to have one worksheet in the workbook contain a standard set of info for all products, including a picture of the product. Another worksheet would be the "selection" page where a user puts an "x" next to the model number they want in their customized catalog. The third worksheet would contain the customized catalog entries.

I have been able to get all the data info to assemble correctly on the third worksheet using the IF function (data like model #, price, availability, description etc.) but the master data also contains a picture of the product. Try as I might, I cannot find a way to get the image to move over with all the other data.

Is there a way (functions or VBA) that I can keep the image from the master worksheet with all the data when it copies over to the customized catalog page ?

I've probably described this in a very confusing way, but any thoughts would be appreciated.

THX -

Eaglestl

Here is a sub and function that you can use to transfer pictures from one page
to a specified cell on another page. Paste them into a new or existing code module.

Sub TestIt()
Call TransferPicture("picProduct1", "DataAndPics", "CustomCatalog", "D6")
End Sub

Function TransferPicture(ByVal PicName As String, ByVal FromPage As String, ByVal ToPage As String, ByVal TargetCell As String)

Application.ScreenUpdating = False
Sheets(FromPage).Activate
Sheets(FromPage).Shapes(PicName).Select
Selection.Copy
Sheets(ToPage).Select
Range(TargetCell).Select
ActiveSheet.Paste
Application.ScreenUpdating = True

End Function

Great - I'll give it a try.

Thanks,

Eagestl

Let me know how it turns out.

Originally Posted by eaglestl

I am attempting to create a type of customizable catalog using Excel. This idea is to have one worksheet in the workbook contain a standard set of info for all products, including a picture of the product. Another worksheet would be the "selection" page where a user puts an "x" next to the model number they want in their customized catalog. The third worksheet would contain the customized catalog entries.

I have been able to get all the data info to assemble correctly on the third worksheet using the IF function (data like model #, price, availability, description etc.) but the master data also contains a picture of the product. Try as I might, I cannot find a way to get the image to move over with all the other data.

Is there a way (functions or VBA) that I can keep the image from the master worksheet with all the data when it copies over to the customized catalog page ?

I've probably described this in a very confusing way, but any thoughts would be appreciated.

well, I know such one tutorial for you to learn: http://www.xflip.com/tutorials/creat...rom-excel.html

THX -

Eaglestl

Well, great topic, our company would also try the solution, thanks for sharing!