copying from one excel spreadsheet to another

[anjali5]

Hello Everyone,

I need to copy the data from one excel spreadsheet to another. My first excel spreadsheet has values like below

7654 8763
Date Talk time Handle Time handle15 TotaldelayTime xPTime POTime TCTime Talk time Handle Time handle15 TotaldelayTime xPTime POTime TCTime

1
2
3



Another excel spreadsheet say spreadsheet1, I have

7654
date Talk time Handle Time handle15 TotaldelayTime xPTime POTime TCTime

8/01/2010 5 10 8765 5432 8 987 234,786
8/02/2010 985 20 244 9876 9 10 123424
8/03/2010 444 222 244 9876 9 10 123424

8763

8/01/2010 444 222 244 9876 9 10 123424
8/02/2010 444 222 244 9876 9 10 123424
8/03/2010 444 222 244 9876 9 10 123424

(the numbers might not be matching with my attachment numbers)


I need to copy data from spreadsheet1 to spreadsheet2(please see attachment) in the same order when the date matches the above date so for e.g 8/01/2010 matched 1 and number 7654 matches number 7654 with the above sheet then the data should be copied from bottom spreadsheet to above spredsheet. The bottom spreadsheet will keep going for 7654 , 8763, 9876 and so on, there are total 14 of them. In the above spreadheet, these 14 numbers are displayed horizantally so I have 7654, 8763, 9876 and son and for each of these numbers, I have, Talk time Handle Time handle15 TotaldelayTime xPTime POTime TCTime in horizantal form.

How can I accomplish this in Excel macro. Any help will be greatly appreciated. (I have attached both the spreadsheets)

Thanks