Hi,
I'm working on automating a huge reporting. Each month one column for the new month is added to the table. I have a lot of tabs that are related to this table and which add one column with the information I need every month to the previous one. Then for each tab I have graphs and charts. I want to find a macro that increase the chart selection range if the column next to the original table is not blank or that remove fields in the charts where there is no data. If I increase the chart selection range so that it ll include the new column that ll be added each month, then I ll have blanks in the chart, f.e. what should be March 2013 in the chart will be blank (no info yet). So I want to know if there is a macro which enables me to select a table as long as there is no column blank or that remove
This may sound as if it is easier to reselect the selection range of each graph for each month but I have actually a lot of charts and tabs.
Thanks for your help!!!