excel+courses - Images

Resolved · Low Priority · Version Standard

Images

Stuart has attended:
Access Consulting course

by - delegate Stuart [4 posts] (2007 Dec 19 Wed, 09:54) Reply

Hi,

I'm mostly ok inserting pictures into Excel sheets but I'm wondering if there is a way to embed them into the cell so I can perform a V-Lookup or simmillar calculation to pull it through to another worksheet?

For example, I work for a shoe company and we have a catalogue of Shoes. I produce various line reports for the company and would like to be able to easily link a cell in my reports to show an image of the line - say in a list of the weeks bestsellers etc?

Apologies if this question has already been answered, I couldn't see anything in the first few pages!

Many Thanks,

Stuart

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Images

by - delegate Paul gold contributer [121 posts] (2007 Dec 19 Wed, 11:40) Reply

I don't think it's possible without some hefty code

RE: Images

by - trainer Rich platinum contributer [744 posts] (2008 Jan 24 Thu, 15:12) Reply

A database would be better suited for this type of application.

Regards, Rich

· Microsoft Excel Training Course
· Excel Macros for the Non-Programmer
· Training Budgets In A Bad Economy
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· How to check for and reduce errors in Microsoft Excel

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Rate this page: