Hi folks
Working with Cols K:BL I want to delete the entire Row if the value "1" does not appear in Cols K:BL
Cheers
hammer
Hi folks
Working with Cols K:BL I want to delete the entire Row if the value "1" does not appear in Cols K:BL
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
Attaching a sample workbook enables others to work on your problem:
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Does the "1" have to be in every cell in the row in columns K thru BL?
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi Mike
No, if it appears in just one cell the row stays thanks.
Maybe this
Please Login or Register to view this content.
Last edited by mike7952; 04-19-2015 at 07:17 AM.
'Maybe' was good Mike!
Many thanks for that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks