Excel Programming

[Sam T]

Dear All,

Query 1 - I have this sheet in excel which needs to show the row only when there is a corresponding value in the two columns.  If the value amounts to zero it should be hidden.  Can any one program a macro which will toggle 1 between showing the whole sheet (with empty values) and toggle 2 showing only the rows which have either non zero value in either of the years.  

I have highlighted the rows in yellow where my query has been shown.

Regards,

Sam

[Sudarshan Wadkar]

I doubt if anyone will do this for you. But I think what you are looking for essentially is vlookup with custom formatting.

-S

--
--
The website for the club is http://stab-iitb.org/wncc
To post to this group, send email to wncc...@googlegroups.com
 
---
You received this message because you are subscribed to the Google Groups "Web and Coding Club IIT Bombay" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wncc_iitb+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Saswat Padhi]

I am not sure if, VLOOKUP would help here.

A very simple macro that loops over each row and either shows or hides them as per the criteria should do the job.

Saswat Padhi  |

Senior Undergraduate |

B.Tech. CSE |

IIT Bombay

[Sourabh Bhat]

Hi,

I think the best way to find out is:

1) Start recording a marco

2) Do the required operations in excel

3) Stop the macro, and see the recorded script

4) Then you can use similar script (with your variables) in your script.

Hope that was helpful. That is the way I used to work-out unknown things in excel macros.

Regards,

Sourabh

Best Regards,
-- Sourabh