Dear Friends,

I have an open notebook (called report.xls.) I would like to copy a worksheet from a closed notebook (the notebook is called budgets.xls and the desired pages is called "percentages"), and paste-special it to the report.xls notebook to a new worksheet called "BudgetInfo".

Can anyone tell me how to do this?

Thanks,
Mike