Excel sheet [transfer data from Sheet2 to Sheet1]

[aakhan2011]

I want to copy data from detailed sheet to summary sheet. The C column data of detailed sheet (10.23 instead of 10:23.12 in first row by truncating) needs to be copied to B3 in summary sheet.

We used to fetch the data for summary sheet from oracle database and paste the complete data in summary sheet as shown in sheet. I need some vbs code in summary sheet which will copy the above mentioned data from summary sheet to detailed sheet(after we paste the data in summary sheet and open the detailed sheet.).

The two sheets are pasted in below links

Detail.xlsx - Speedy Share - upload your files here
Summary.xlsx - Speedy Share - upload your files here

Thanks in advance

Regards,
AAK