Hi,

If you want to import a Worsksheet from any of your workbook in to a
worksheet in a differnt workbook, then do this as follows:

1. Click a cell location in your worksheet.
2. On the Data menu, point to Import External Data, and then click Import
Data to diaplay the Select Data Source dialog box.
3. In the Look in list the select the Microsoft Excel file you want to
Import. The Select Table dialog box displays with all the worksheets.
4. Click the select the worksheet Name.
5. Clear the "First row of data contains column header" check box.
6. Click Ok. This displays the Import Data dialog prompting you whether you
want the data to be imported in the current cell location or in a new
worksheet?
7. Select the current cell location under the Exiting worksheet list.
8. Click Properties to display the "External Data Range Properties" dialog
box.
9. Under the Data Formatiing and Layout, clear the "include field name"
check box.
10. Click OK. This closes Data Formatiing and Layout and return to Import
Data dialog box.
11. Click OK to return to the worksheet, to view the imported data in the
cell location.

Challa Prabhu


"dap_125" wrote:

I have a formatted text report with headers that I need to import into Excel.
Is there an easy way to remove the headers so that I don't have to manually
delete them all? Or import the data without the headers, or just format the
headers.
The report has over 1000 pages.