I copied the Command button from another spreadsheet into this spreadsheet and changed the destinations, as well as the page names to reflect the new workbook. However, I'm getting an error on the ExT.Activate line, when I try to use the macro button. Not sure why. It works perfectly on the other spreadsheet and should be doing the same on this spreadsheet.
I did post same question here, but I couldn't upload the spreadsheet for some reason. The only thing I'd like help adding is clearing the data in the first table, columns A & B, with the same button.
Any help is appreciated.
Regards,
GfCs