combine multiple worksheets & files into 1

[Guest]

I have 18 employees, which each have monthly 12 files for timecards. Each
file is identical in it's format. The difference is each file then has 4-5
worksheets, one for each week and totals at the bottom for hours worked and a
description of the project they were working on each line.

I'm trying to put together a database to replace this archiac way of doing
their timecards so that it will total the hours worked on a specific project
using an Acccess template (Time & Billing).

However, my first step it to get all of this data into 1 report per
employee, so I can import (or rekey if I have to) the information into the
database.

Any help is greatly appreciated!

 

[Guest]

Put each employees in cells A1 to A18
each month in cells B1 to B12

loop through thus
for i = 1 to 18
for j = 1 to 12
open filename Range("A" & i) & Range("B" & j)
ignore if sheet 5 not present
copy sheets 1 to 5
close this file
next j
next i

you have one big file with all 18 of them please

 

[Guest]

OK... that was way over my head. Is this done manually or with a macro. I
get the first part about the employees name and months, but don't understand
the 2nd part. What does "i" and "j" represent?

Thanks so much for the quick response.

 

[PY & Associates]

It is done with a macro please.
Easily done by your IT people. Don't struggle on your own.