VBA to match, copy and paste times into different workbook

[Justmegan93]

I receive daily email attachments which has start and finishing times of each employee from the previous day.
eg:

Date	Name	Start	Finish
17/10/14	John Smith	08:00	17:00
17/10/14	Joe Bloggs	09:00	19:00
17/10/14	Teresa Green	06:20	16:30
17/10/14	Bob Brown	19:10	05:00

I also have a spreadsheet set up where i manually enter these time and use formulas to determine hours worked ect
eg:

Date

Name

Date

Name

Start

Finish

Start

Finish

17/10/14

08:

17:00

-

-

-

-

09:00

18:30

-

-

-

-

(The blank columns have formulas in them)

My goal is to match both the name and the date and extract the times from the email attachment to populate the workbook I have created.
any help or even links to webpages are greatly appreciated !

[TMS]

The raw data format is MUCH better that your target layout. If you have more than one set of data on a row, or group of rows, you will make subsequent analysis a lot more difficult.

Just bring all the raw data into a simple two dimensional table. You can add formulae to each row if you need to but you might be able to do the analysis in a Pivot Table.


Regards, TMS