combine multiple worksheets & files into 1
 

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!

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

"Barb" wrote:

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!

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" wrote:

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

"Barb" wrote:

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!

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

"Barb" wrote in message
...
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" wrote:

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

"Barb" wrote:

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!