Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-21-2009, 03:43 AM
skoz55 skoz55 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2009
Posts: 14
skoz55 is on a distinguished road
Default Automating Cel Population of .jpg

I am attempting to create a workbook that will populate cells with .jpg pictures based on the selection in another worksheet.

I have clients that choose items to purchse from a selection of 20, and there are 10 of the these categories. Thus 200 .jpgs Currently, my clients fill out a sheet by hand, I then place the .jpgs in a Word document based on what they selected. I would like to send them an excel spreadsheet that has 10 drop down menus. These lists contain the 20 items.

As they select the item, the corresponding .jpg is inserted on another worksheet in a cell. I can then print one page that has all of the pictures of what they picked out.



I've been messing around with if then statements, however can not associate the .jpg. Ideally, all the picture files will be on another worksheet so that everything stays together in one workbook.

Thanks
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -7. The time now is 08:03 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft