Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using Criteria with two possible values
using CUSTOM to choose both criteria - make sure you populate all four boxes and choose OR a the comparison operator) and see the code which is generated I need a translator!! LOL I can record a macro, but then I get los at that part. Then again, how would I record a macro doing anythin but deleting a row -- DK ----------------------------------------------------------------------- DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451 View this thread: http://www.excelforum.com/showthread.php?threadid=27563 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using Criteria with two possible values
Hi
(do this on a copy of your work and save the macro in the personal macro workbook so it doesn't disappear when you close the file) choose tools / macro / record new macro click in your list choose data / filter / autofilter click on the drop down arrow of the column you're interested in choose custom choose equals and then the first criteria choose OR choose equals and then the other criteria you want click OK only records meeting either of these criteria should now be displayed choose edit / goto / special - visible cells only choose edit / delete choose tools / macro / stop recording choose tools / macro / macros ... click on the macro and choose edit hope this helps Cheers JulieD "DKY" wrote in message ... using CUSTOM to choose both criteria - make sure you populate all four boxes and choose OR as the comparison operator) and see the code which is generated I need a translator!! LOL I can record a macro, but then I get lost at that part. Then again, how would I record a macro doing anything but deleting a row? -- DKY ------------------------------------------------------------------------ DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515 View this thread: http://www.excelforum.com/showthread...hreadid=275631 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum of values based on different criteria | Excel Discussion (Misc queries) | |||
Frequency of values with Criteria | Excel Worksheet Functions | |||
using Criteria with two possible values | Excel Programming | |||
using Criteria with two possible values | Excel Programming | |||
using Criteria with two possible values | Excel Programming |