I have an xl doc in which one of the sheet's column A changes value every 1 hour...

What I would like to know is.. if there is a method in which i can copy these values from column A to a text file every hour...

The range of cells containing values in Column A also varies every hour.

Also, the old values in the text file needs to get deleted before the new values are updated every hour.

Thanks in advance