Hi Kalyan,
I didn't understand your questions. But from figures you have mentioned in
columns H to L, I have develop a solution. I hope it is what you are looking
for. If have any query email it.
Pls find attached excel for solution.
Regards,
Swapnil.
On Wed, Sep 29, 2010 at 4:06 PM, Kal xcel
Dear Experts,
I am sending a quary related Outstanding Tracking. Details in the attached
file.
Please help me.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear All R/s Friends
Dilip Pandey is great personality . That is truth. He is genius and great
knowledge of excel vba. I salute to you .
D = Data ( Good Data Method )
I = Input ( All input Knowledge )
L = Logic ( Good Logic )
I = International ( International Khiladi )
P = Platform ( In E
Dear Friend,
How much time did it take to get the result?
Regards,
Angelo
2010/9/29 ashish koul
> hi
>
> check the attchment see it it helps you
>
> you can apply the filter and delte all rows with "d" and then remove the
> temp column
>
>
>
>
>
>
> On Wed, Sep 29, 2010 at 2:44 PM, Dave Bonall
this is a change event macro.
whenever a cell is changed, this macro is called and Range of the cell (or
cells)
is passed to the macro as the variable name "Target".
In this case, the macro is checking to see if the row or column of the
cell changed is 3, then proceeds.
note: if a group of cel
Dave, keep in mind that Excel can do several HUNDRED comparisons each SECOND.
If you're adding an Application.wait for only ONE second EACH LINE for 13,000
lines,
you're adding 13,000 SECONDS, or 216 minutes, or 3.6 hours of WAIT TIME!
so, I suspect that you're not "hanging", but simply waiting
very true ...this is real mr dilip pandey
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
2010/9/29 neil johnson :
> Hi ,
>
> Dilip Pandey is great personality . That is truth. He is genious and great
> knowledge
worked it out for myself, posting answer in case it is helpful to
others
dim aRow
aRow = ActiveWindow.ScrollRow
ActiveWindow.ScrollRow=50
On 29 Sep, 00:08, stuartR wrote:
> With the top row frozen and the sheet scrolled down so that the first
> visible row below row 1 is row 32.
>
> How would
Dear Excel member,
I need your help. Can you explain that code.
Private Sub Worksheet_Change(ByVal Target As Range)
*If Target.Row = 3 And Target.Column = 3 Then* ( What is that Means )
'calculate criteria cell in case calculation mode is manual
Worksheets("ProductsList").Range("I3").Calculat
Hi ,
Dilip Pandey is great personality . That is truth. He is genious and great
knowledge of excel vba. I slute to you .
-- Forwarded message --
From: Jai Deo Tiwari
Date: 2010/9/29
Subject: Re: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम
है..पाण्डेय MR. दिलीप जी.
To:
10 matches
Mail list logo
