When combining two spreadsheets, and one has truncated data, how can a pair of columns be matched for sorting. For example, one spreadsheet contains all of the investments made last year. The second contains a list for which annual reports have been completed. However, annual reports have not been completed for all of the investments. Thus, the names of investments column in the first spreadsheet contains more items, than the same column in the second spreadsheet. Since the name is a unique identifier, the goal would be to match them. Then, the first spreadsheet could be used as a checklist for those investments that still require an annual report.

How do I get Excel to run a macro without showing all intermediate steps in a calculation? So, after I kick off the macro, there are no changes on the screen until the macro has finished...

I’m trying to plot more than one series on a chart, but I will never know in advance how many series’ will need to be plotted at runtime.
 
I’ve got the code to add the chart and 1st series in Module1.addChart
 
The problem at the moment is my Module1.addSeries, because there is no active chart.  I’ve tried code to activate / select the chart first, but it’s not having it.
I coded it this way, because before addSeries is called, it adds the actual chart, and I thought the chart was still active.
So I figured passing the chartobject as a parameter would be the best bet.

Hi,

What is wider use of ISNA function? How can I link it with IF function? I would like to be able to get rid of #N/A as a formula result.

Thanks,

Gosia