I need a code that will go thru column C and delete the whole row if cell value is 78315,
Also it needs to shift the the rows up so there is no empty rows wheneverything is done done
I used some codes but they take forever to go thru whole sheet, so please the fast and simple code would be appreciated.
Thanks
Bookmarks