Hi,
This would be like archiving documents.
lets say I have designated cell A-1 which has room for 600 character. I want to be able to write a comment in A-1 and click a submit botton and have the information transfer to sheet 2 without blank spaces and with the date and time the comment was written. Then when I clear my comments on sheet 1, sheet 2 would remain unchanged. So, every time I write a new comment in sheet1, cell A-1, it would automatically archive in sheet 2 based on dates. Thanks for your help in advance.