Delete Cells scattered cells with specific content
I am looking for an easy way to do this...I have a large excel file with 4,500 rows and column's through AQ. Throughout this file cells have the number 1 and I colored them red using conditional formatting. I want to delete all cells that are red that equal 1 in a manner that doesn't require me to delete them one by one. I want to keep all of the cells and basically move all to the left and delete the ones with a 1 and are red. HELP...I have searched and searched.
Here is a sample:
Capture.JPG
I wouldn't use conditional formatting to help a macro know what to do. Are we simply looking for all the cells with a value of 1 and deleting them, shifting all to the left?
Are those cells filled with constants or formulas? Or Both?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
What I would do (with information given)
- duplicate the sheet
-enter formula like this in every cell
New sheet cell A10:maybe commas instead of semicolon for US
Please Login or Register to view this content.
www.plusx.me
Re: Delete Cells scattered cells with specific content
I am so excited....found the answer here: http://www.howtogeek.com/206696/how-...in-excel-2013/
The key was in the part where it demonstrates choosing "blanks" then clicking "delete column's" is highlighted...i selected "delete cell" and it moved all of the content to the left and removing all randomly scattered blanks. This was amazing and saved me hours.
Thank you all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks