Can someone please let me know if there are quick ways clear the contents within a column.
Basically, I'm constantly deleting/clearing the contents in a column and inserting new data from a new sheet.
So for example, in the attached spreadsheet I would clear all the symbols in column A sheet 1 and then go to sheet 2 copy the stock symbols in one of the columns and paste it into column A in sheet 1. I continue doing this until I've gone through all the symbols in sheet 2.
As you can imagine this can become quite a laborious task.
If you can help that would be greatly appreciate.
Thanks in advance.