Using a MAcro to generate new sheet & Calculation
 

Hi there,

I have a register in which i record numerous reports/data. I woul
like to create a button which when pushed creates a new spreadshee
with a calculation sheet which has already been created.

Register is spreadsheet 1
Calculation is spreadsheet 2

When a button in row 1 (spreadsheet) is pushed i would like a macro t
create a new sheet, copy the calculation from sheet two and then fil
in the blanks in the calculation from row 1 in spread sheet 1.

If possible it may be better if the macro created a totally new sxl
file with the calculation on its own rather than hundreds o
calcultions within the same xls file. This is not so important.

I hope i have explained myself well enough.

Thank you so much for taking time to read and any help will be ver
much appreciated.

Kind regards

Steve Masson


PS. If you need a copy of the excel file i can easily send it

--
Message posted from http://www.ExcelForum.com