Hi, I'm new to the world of macros, I have recently recorded a couple allowing spreedsheets to be formated and cell contents copied and pasted. I now need to do some serious stuff.

Can anyone help with the coding to do the following:

I need the macro to look at the date in column "A" and if it is today transfer the information from that row into another page of the same work book. The page to receive the infromation is layed out differently to the first so the recieving cell refferance will not be the same.

It then needs to repeat the process until the date column is empty. Having don that it does the same on a second page of infermation.

If you can get me started I could play with it. Thanks Paul