Having created a graph from a certain source data, if columns get added later to the source, they do not automatically append to the graph. While this is easy enough to accomplish in Excel 2007 and higher versions, doing the same in Excel 2003 is a different procedure altogether. Instructions are very clearly mentioned in […]
Read More →
The VLOOKUP() function returns data from a lookup_array irrespective of the filter setting of the lookup_array. To make the lookup_array of the VLOOKUP() function work only on the visible cells of a filtered range, refer to this workbook.
Read More →
{ 2 Comments }
Assume there are three worksheets, one each for 2008, 2009 and 2010. On each sheet there are two columns for Account code and Account description. Thereafter there are 12 columns (one for each month). Values inside the matrix represent amount spent on a specific item in a specific month. On the P&L worksheet, a user will provide the […]
Read More →
{ 6 Comments }
Assume there are ten worksheet tabs – one for each retail store. Each worksheet tab has sale data of different brands across 12 months – brands are arranged in rows and months are arranged in columns. The structure of all worksheets tabs is the same. Furthermore, each store is managed in any of the two retail […]
Read More →
{ 0 Comments }
If a certain cell entry is found in column C of the other eleven sheets, then colour the entry in red. Furthermore, a summary sheet should show all red coloured entries. You may refer to my solution in this workbook.
Read More →
After creating a validation list in a cell, one may enter one any value in that cell from the cell drop down. Once a selection is made in the cell drop down, a change in existing source entries (say a spelling change) of the validation list will not cause the cell entry to be changed (although the […]
Read More →
{ 2 Comments }
One may want to create interactive graphs by allowing users to select indicators and years to be plotted (via check boxes and scroll bars). I have presented three cases in this workbook.
Read More →
{ 2 Comments }
Assume data in range D6:E11 – months in D6:D11 and numbers in E6:E11. Headings are in D5:E5. On filtering multiple values in column D, one may want to view the filtered criteria in cell (separate criteria by comma for multiple selections in auto filter drop down). For solving this problem, you will have to download and install the morefunc […]
Read More →
{ 6 Comments }
Create a data validation list from a range which has data appearing in multiple rows. I have shown two cases – one using macros and other using formulas. The question and solution have been explained in this workbook.
Read More →
{ 0 Comments }
Based on information regarding starting date of tasks and periodicity, generate a schedule/time-table on another sheet. The question and solution have been elaborately explained in this workbook.
Read More →
Updating charts for columns added to source data in Excel 2003
{ 0 Comments }