LinkBack URL
About LinkBacks
Add a column with your additional logic to return TRUE/FALSE and then use that column in your autofilter, showing either TRUE or FALSE depending on your desired display.
Add a column with your additional logic to return TRUE/FALSE and then use that column in your autofilter, showing either TRUE or FALSE depending on your desired display.
Bernie Deitrick
Excel MVP 2000-2010
Hi Bernie Deitrick,
Understood. I can do that if it is a new file. But I have around 500 existing files that I can't add a column in it. it is very difficult for now.
Use a macro to add the additional column - you can process 500 files with the click of a button, if you write the code well
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks