Paste value into the first blank cell of a column untill the last completed adjacent row

Hi Guys,

Has anyone solved this problem before? I have been searching for the answer since lunch!

Basically- I have a macro which adds customer data onto the bottom of a master sheet- I now need to add the date it was added into the next column. (see image)

mastersheet.JPG

The red line indicates the new data.. I'm now looking for a macro which will copy =today() date from a cell and paste it in the first blank cell in the date received column (F) and loop until it reaches the last completed adjacent row(E35)

I hope that makes sense,

Thanks in advance

Regards,

Hernan

Crespo,
Part of reason for not receiving a reply lies with a picture. Picture does not help with sample data and code. Please attach a sample book with a desired result.