Hello Guys,

I have created a spreadsheet (Daily Sheet.xlsm) for tracking daily mileage of my pizza delivery boys. In the spreadsheet one cell ("O5") has the date entered on a daily basis and right below are the names of my delivery boys ("O7:O17") who type in the miles reading ("P7:P17")

I have a central spreadsheet which has dates in rows and the names of the delivery boys in columns.

I would like to get your help in a macro where it copies data from the Daily Sheet and pastes them under the corresponding date & name. At the end of the copy-pste loop, I would like to erase the miles data.

Your help is much much appreciated.

Thanks
Pratish