Hi!

So I am setting up an automated excel workbook that pulls accounting information from my company's online records into excel. I have the web query working correctly. Now I need vba code to delete the last row of the pulled information because the last row only contains the total of the column. I want to delete the entire row if column A and column B are empty and then stop when it gets to the bottom. The length of the pulled information changes. I need the macro button to be in "Sheet 1" and the information to be in "Sheet 2". I have no idea how to do this.

Thanks in advance for your help!