Hello All,
I currently have a work sheet where Row 1 is full of the column headings. Every day new data is copied into this sheet. I am trying to automate this process to make it faster. Currently I use the .UsedRange command to select all the data from the first sheet. The problem I am having is I need to select all the data on the 2nd sheet from A2 down to the end and delete it. Sometimes the data has less rows, if I do not clear the sheet the bottom rows could possibly be left over from the day before. I need to leave the first Row since those are the column headings. I tried usedrange however it also selects the first row also. The sheet I am selecting has no borders or shading. It is strictly numbers. I just need it to start at the 2nd row and select all the data down to the end of the sheet.