ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Delete ENTIRE row after updating info in worksheet. (https://www.excelbanter.com/excel-worksheet-functions/46588-delete-entire-row-after-updating-info-worksheet.html)

naiveprogrammer

Delete ENTIRE row after updating info in worksheet.
 
I have a worksheet that is populated via a query from an ODBC. The cells
that are populated are A2:D2. When criteria that is based on my query
changes, my worksheet info changes when the worksheet is refreshed. All this
works great. MY PROBLEM- E2:H2 doesn't update when the query refreshes if
the info has changed. So basically whatever was residing in E2 before the
refresh is the SAME info as before the refresh if the info has changed.

How can I delete the ENTIRE row depending if the info from my ODBC via my
query changes?

Thanks for ANY help!


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com