| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If data is returned then delete data
I am using vlookup to find accounts from sheet1. What ever vlookup finds I
want to delete off sheet1. Any ideas? Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If data is returned then delete data
Formulas can return data but they cannot delete data.
You would need VBA, probably event code to clear cells. Gord Dibben MS Excel MVP On Tue, 13 Nov 2007 09:42:03 -0800, LiveUser wrote: I am using vlookup to find accounts from sheet1. What ever vlookup finds I want to delete off sheet1. Any ideas? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query returned more data than will fit on a worksheet | Excel Discussion (Misc queries) | |||
| differend data returned in last row | Excel Discussion (Misc queries) | |||
| differend data returned in last row | Excel Discussion (Misc queries) | |||
| #value returned instead of data | Excel Worksheet Functions | |||
| This query returned no data | Excel Worksheet Functions | |||
Linear Mode
