hiding rows automatically

I have a large sheet that has UPC codes and I want to be able to have the sheet automatically eliminate the cells that have a 0 value. All the cells contain formulas generating data from numerous tabs. I am very green as far as VBA is concerned, so step by step directions would be necessary...

Hi, I'm looking for a way to hide and unhide the rows based on the condition in D & E. Lets say I want to list all documents that have TR00001 in D or E, I will type TR00001 into a cell(C3). Doing this all other rows in the defined range shall be hidden. If I type in TR00001 into cell C3, all...

Hi, I am trying to hide all rows where the Surgery name is not equal to the value input into the InputBox, this Inputbox is triggered after the word "WORKER" is input into A1 as this is the correct column label for my report. I have these two Subs in the same sheets code, which may be why it's...

I am not well verse in MSExcel 2007, I am hoping someone can help me with my problem. I am creating an excel file that will help my work more accurate and more faster. I have posted an image also for reference. Is is possible to auto hide a row base on numerical value input in a cell...

I am a project manager for a subcontractor in Dallas. I am consistently looking for better ways to manage all of the data that comes into my office. I have to track Purchase Orders, RFI's, Submittals, Action Items &/or Requested Information, Critical Delivery Dates, etc. Right now I have...