Create a report based in a template spreadsheet.

Hi all,

I have a template spreadsheet with multiple worksheets (same structure, only some values are different, and one of the columns is empty) and I need to open one of these worksheets depending on each one I want and then load a .dbf file with some data to fill the only empty column in the worksheet.

All this need to be an automatic process.

Can I do this with macros?

I thought about Base and Reports but I don’t think that’s the best way.

Thanks