Hi Rabindara,
Solution is attached. Please have a look.
Naveen Sharma
On 7/15/09, Rabindra Thapa wrote:
>
> Hello Guys,
>
> can somebody help me on attach file.
> --
>
> Regards,
> Rabindra Thapa
> ¨`·.·´¨) Always
> `·.¸(¨`·.·´¨) Keep
> (¨`·.·´¨)¸.·´ Smiling!
> `·.¸.·´
> (¨`·.·´¨) (¨`·.·´¨)
>
Attached is a solution.
Subtotal is not what you want to use.
This is done with dynamic named ranges and data validation.
Norman
On Wed, Jul 15, 2009 at 6:07 AM, Rabindra Thapa wrote:
> Hello Guys,
>
> can somebody help me on attach file.
> --
>
> Regards,
> Rabindra Thapa
> ¨`·.·´¨) Always
> `·
Thank for your kind information.
Have a good day.
On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma wrote:
> Hi Rabindara,
>
> Solution is attached. Please have a look.
>
> Naveen Sharma
>
>
>
> On 7/15/09, Rabindra Thapa wrote:
>>
>> Hello Guys,
>>
>> can somebody help me on attach file.
>> --
>>
I required when i filter, the filtered row should be display on other
column.
On Thu, Jul 16, 2009 at 1:19 PM, Rabindra Thapa wrote:
> Thank for your kind information.
>
> Have a good day.
>
> On Wed, Jul 15, 2009 at 4:51 PM, Naveen Sharma
> wrote:
>
>> Hi Rabindara,
>>
>> Solution is attach
I would be interested if there is simpler method to perform your task.
Meanwhile you can use the following function.
'
Function StrSubTotal(r As Range) As String
Dim i As Integer
i = 1
While r.Cells(i, 1).Height = 0
i = i + 1
Wend
Exact solution for me. Thanks for your great effort.
Have a good day
On Fri, Jul 17, 2009 at 4:25 AM, Akhilesh Karna wrote:
> I would be interested if there is simpler method to perform your task.
> Meanwhile you can use the following function.
>
> '