merging files

[george]

I have two excel reports, formatted the same but with
different data. how do i import the second excel file
into a workbook of the first excel file?

 

[Frank Kabel]

Hi
one way:
- open both workbooks
- activate the workbook with the sheet to be exported and right-click
on the
tab name
- choose 'Move/Copy'
- choose your target workbook and check 'Copy'