date copy

[qdavhen]

Hi All,

Can somebody help me with a macro please. I have a worksheet with many rows and columns of data. In cell A1 there is a date. I'd like to cut this date, insert a new column A and paste the date in column A from cell A6 into all the cells of column A to the last used row in column B. (Eg. if the last piece of data in column B is B45, then the date will be pasted from A6 to A45).

Thanks in advance.

Dave.

[mojo249]

Try:

Please Login or Register  to view this content.

[qdavhen]

Thanks very much! Worked great! Much appreciated.