looking for code to delete rows on sheet 2 unless it has same data in sheet1
my master worksheet (sheet1) contains list of master names (5 names in cells A1:A5). I am looking for macro code to loop through data on sheet 2 and delete entire row if it does not contain the master names in sheet 1.
anyhow know quick code to do this? Thanks.
i have imported external data (odbc) to my excel sheet but everytime i open the worksheet and click refresh data, it prompts me for a login id and password. does anyone know of a macro that will refresh the data and connect to the database when i open the worksheet so i wont have to keep inputting the login and password everytime?