The sample that I posted was a "simplified" version so that everyone
could get a general idea of what I'm working with. The actual file
has more columns, and the column headers with two words in them (ie.,
SAL No) are split into separate columns when I import the data using
"space" as a delimiter. I thought it would be too confusing to paste
the sample "as is," but I have done so below so you can see the actual
file.

So... I think your template idea with the headers was a good idea... I
just need to figure out 1) how to capture the date and page number
information from the original file; and 2) how to import the data into
same worksheet as my template headers. What do you think?

Thanks!
Jessi

P.S. Here is the actual file:

BENTLEY AREA
AUTHORITY

Service Work Log
Report 05/04/2006 2:45pm Page 1


Staff ID Name SAL No Date Payroll
-------Reported Hours-------- % Lines Comp Comp

Hrs Total
Direct Non Dir Prep Earned Taken

432498 BROWN 748334 05/04/2006 8:00 5:00 5:00
0:00 0:0 62.5 8 0:00 0:00

399003 JACKSON 444321 05/03/2006 8:00 4:45 4:45
0:00 0:0 59.3 5 0:00 0:00

887790 SMITH 023445 05/02/2006 8:00 2:00 0:00
2:00 0:0 25.0 5 0:00 0:00

223456 CUNNINGHAM 665433 05/03/2006 8:00 4:50 3:50
1:00 0:0 60.4 9 0:00 0:00

333456 DENNY 055432 05/03/2006 10:00 4:30 2:45
1:45 0:0 45.0 9 0:00 0:00

********** Total ********** 42.0 21.0
16.3 4.7 0.0 50.1 36