Offsetting an output to different column

Hi,

I have some code that is almost there and performs the function that I need it to. However, I cannot figure out the last bit.

People will enter dates into column A, of which each row will be an individual piece of work. So the code that I have now records the newly input dates like I wanted starting in column B and so on. I need this code to work how it is now (printing all input dates) but I need the printing to start in column Z but column A will still remain the place where people input dates.

Please Login or Register  to view this content.

Any help would be great!

You indicate to start printing in Col Z. What is the complete range that needs to be printed ?

Example: Z1:Z26 ? The code would be :

Please Login or Register  to view this content.

Hi,

I am not sure this is what I am after.

I need to code above just need to know how to start the continous input of dates from Z onwards. I need to record every date that is input into column A.

Thanks

Please Login or Register  to view this content.

Hey,

This offsets the output to Z but then spaces the next output out to AY and so on. I need it to output to Z,AA,AB,AC etc.

Thanks so much for your help!