JK Responsive Gallery v2.0 JK Responsive Gallery is a modern, lightbox style Youtube video and image gallery that works perfectly on any screen size and device, big or small.
$D, Table1[#Headers], 0)) Named ranges are really useful, this post demonstrates how to add values automatically to a chart: How to create a dynamic chart ) Returns the relative position of an item in an array that matches a specified value in a specific order INDEX(array,row_num,[column_num]) Returns a value or reference of the cell at the intersection of a particular row and column, in a given range How to create a dynamic chart (excel 20) Question: How do I create a chart that dynamically adds the values, as i type them in the workbook?
Answer: Excel 2007 (and later versions) users, create an excel defined table.
How exactly do you provide your drop-down menu, and how do you validate the data?
Worksheet_Change is an event called on I think nearly any change on your workbook - not just, if your drop-down menu changes.