| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete data in worksheet, but not the associated formula | Excel Worksheet Functions | |||
| how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
| Updating database worksheet problem (Template Wizard) | Excel Discussion (Misc queries) | |||
Threaded Mode
