yankeegooner
New Member
- Joined
- Jul 15, 2014
- Messages
- 1
I have searched the many threads of this forum that have similar questions, but I have not found what I really need.
I have a sheet that pulls values from another sheet based on user selections. For the years selected, say 2014 to 2050 (37 columns), if all of the columns for that entry (Product description, which is the left-most column) is zero, how can I filter out the entire row (37 columns + product column) and not show it to the user?
I have tried unsuccessfully to use the advanced filter.
Thanks for your help!
I have a sheet that pulls values from another sheet based on user selections. For the years selected, say 2014 to 2050 (37 columns), if all of the columns for that entry (Product description, which is the left-most column) is zero, how can I filter out the entire row (37 columns + product column) and not show it to the user?
I have tried unsuccessfully to use the advanced filter.
Thanks for your help!