Results 1 to 11 of 11

Hiding row if column sum value equals 0

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    63

    Hiding row if column sum value equals 0

    Hi,

    I have searched few topics, all had something similar but it didn't seem to work for me. I need to say I have no idea of VBA code, I only realize that if I need it running all the time I need to add it through worksheet code and if I want a button thorugh a module.

    So idea is as mentioned in the topic, I want to hide a row if column value, for ex. "I.3.Change in receivables after one year" sum C5:K5 equals 0.
    I added and example, but it contains numbers only, original file has only fomulas, so if value would become non-zero it should be visable again.

    If anyone could help me with this it would be great.

    Regards,
    drakaz
    Attached Files Attached Files
    Last edited by drakaz; 03-19-2013 at 04:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1