Macro to populate a cell and then execute another macro

Hi,

A former colleague created a spreadsheet programme that requires a user to input a fund code in cell B2 and then click a macro button in the same worksheet that extracts a report. The problem I have is that I need to extract reports for about 30 funds. This means that, for each fund, I need to type a fund code into cell B2, click the macro button and then save the output in a given directory.

Is this the sort of job that could be spreeded up with another macro that will enter a fund code in B2, click the macro button and then save the output in the selected directory, before entering the next fund code in B2 and kicking off the macro again?

I thought that I might create a table of fund codes in another worksheet that the macro I'm trying to create will work through.

Any help would be much appreciated!

Thanks!