I committed a cardinal sin of sorting a single column instead of the whole spreadsheet. It was then uploaded to a database. The fix seems simple inserting the contents of a cell into a statement in another cell. I can cut and paste but I am sure there is a way to automate it. 1200 lines will take quite a while, and I know this can/will happen again. The statement is " delete from Alias where Alias='XXXXXXXXXXXX' " The Alias is in cells in column "C"
Bookmarks