$$Excel-Macros$$ Need formula to get the desired cell content.

2010-05-21 Thread Vinu
Hello, I have 2 sheets. In one sheet I have a dump data where I will filter based on requiremets(only first colounm i.e, country is only one filter - not multi filter). In the second sheet I used subtotal formula to get some fields SUM. For eg. In sheet1 I have country names coloumns.

Re: $$Excel-Macros$$ Need formula to get the desired cell content.

2010-05-21 Thread Harmeet Singh
Below Code may help u Do ActiveCell.Offset(1, 0).Select Loop Until Rows(ActiveCell.Row).Hidden = False Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Fri, May 21, 2010 at 6:46 PM, Vinu vinu1sm...@gmail.com wrote: Hello, I have 2 sheets. In one sheet I have a dump