Insert images in second sheet of Excel with specified range
Create a name range ‘getChart()’ with formula
=IF(Sheet1!$A$1="pic1",Sheet2!$A$1:$C$9,IF(Sheet1!$A$1="pic2",Sheet2!$A$10:$C$18,
IF(Sheet1!$A$1="pic3",Sheet2!$A$19:$C$27,"")))
Draw a drop down list in sheet1 mentioning all three
pics name
Below draw a range with Camera from a quick access
tool bar.
Insert an image in that range and click on that
image and insert =getchart formula bar
No comments:
Post a Comment