I have a timecard which has data and a layout looking like the
following (timecard is on a sheet called "Time Card" and the log sheet
is called "Log"... the dates are formula-generated):


Employee Name [cell C9]

Sun Mon Tues Wed Thurs Fri
Sat

Jan 1 Jan 2 Jan 3 Jan 4 Jan 5 Jan 6
Jan 7

**two rows of info not required to be filtered**

Stat Holiday 8
JobNumber1 4 6 8
JobNumber2 4
JobNumber3 2 8
etc...

I have been trying with no solution, to come up with a way to filter
and re-organized the timecard info into a log table which would filter
out dates in which there is no hours input (all blank cells) and filter
out the rows which were not used at all. For example, my timecard table
consists of a range from D18:J32 (below the days of the week) to fill
out weekly hours. All rows may not be used depending on how many jobs
were worked on. Additionally, not all jobs are worked on every day
(example above). I'm trying to filter the info so that the above
information would look like and be input to the log sheet similar to
the following:

Week Day Date Job# Hrs. Employee

Monday Jan 2 Stat Holiday 8 Name
Tuesday Jan 3 JobNumber1 4 Name
Tuesday Jan 3 JobNumber2 4 Name
Wednesday Jan 4 JobNumber1 6 Name
Wednesday Jan 4 JobNumber3 2 Name
Thursday Jan 5 JobNumber1 8 Name
Friday Jan 6 JobNumber3 8 Name

Of course, I'm also trying to have it record to the next empty cell in
the "Log" worksheet so it won't overwrite any previous data.

I realize this might be a major undertaking, but I appreciate anyone
who might take it on. I'm fairly new to excel and VBA and I've been
fumbling through for a long time, unable to come up with a solution.
Maybe this is too difficult a thing to do.

Appreciated,
Mike db