Hi,
I've developed a spreadsheet in Excel 2010 which will be used to generate compensation based statements for about 200 employees. The issue i have is that there will be many rows with zero values that i would need to hide and actioning manually is simply not an option as i need to refresh these fairly often. I've looked at some VBA code on this forum which is helpful however i can't get anything to work for me.
I currently type in the ID number of the employee which populates various comp information using VLOOKUPS and the needed VBA/Macro would idetify rows with zero values in columns E,F,H and I and hide them (not delete).
I've enclosed a test version for your viewing, any help much appreciated.
Andy
Bookmarks