You have to always end the if statement
If Column D value ="Yes"
then Filter C column
& copy the data
End If
www.gate2quality.com/tools.html
On Thu, Sep 3, 2009 at 7:53 PM, mahesh parab wrote:
> Dear All
>
> i am getting caption error while runing the macro, i herewith attach sample
> sheet,I
Mudassar can you send the file, Whatever u need can be done either through
lookup or using and array formula combinig small and index functions.
On Wed, Feb 11, 2009 at 12:15 PM, hari kumar wrote:
> Hi Mudassar,
> It would be advisable to go for pivot table by organising data in proper
> f
Hi Rabindra,
Please find the attached file with the formula in table B.
Regards,
Tariq Kamal
www.gate2quality.com
On Tue, Feb 3, 2009 at 8:09 PM, Rabindra Thapa wrote:
>
> Please help me on attach files.
> --
>
> Regards,
> Rabindra Thapa
> ¨`·.·´¨) Always
ect
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
'to paste in sheet2
Worksheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Regards,
Tariq Kamal
www.gate2quality.com
On Mon, Feb 2, 2009 at 11:43 AM, Naveen wrote:
> Hi,
>
>
can u send the sheet...
On 1/21/09, Ajay Varshney wrote:
>
> send us your file, we will unhide the sheet and send back to you.
>
>
>
>
>
> On Mon, Jan 19, 2009 at 4:23 PM, vinu wrote:
>
>>
>> its not working I tried it..
>>
>> On Jan 17, 2:34 pm, "vijender kumar" wrote:
>> > Just go to
>> >
It can be doen by writing a simple macro, wherein you will have to use two
properties
You will have to mention that a prticular cell in column A if it is true
then select the corresponding cell in column B / C / D and then
Selection.Locked=True
and
ActiveSheet.Protect ("Password")
these two will
False, SearchFormat:=False).Activate
ActiveCell.FormulaR1C1 = " Mr. " & ActiveCell
Here it will search for anythng that is put in B1 of sheet1
Hope it helps
Tariq Kamal
www.gate2quality.com
www.rideahead.blogspot.com
On Mon, Jan 19, 2009 at 7:14 PM, H Upadhyay wrote:
> Dear Grou
Hi,
Instead of a mssgbox use a userform.
Regards,
Tariq Kamal
www.gate2quality.com
On Thu, Jan 15, 2009 at 9:01 PM, mickeyc wrote:
>
> Hi,
>
> I have a LOT of text I want to display on a msgbox and it doesn't fit.
> There's no error, it simply doesn't displa
You have not mentioned any bracket, coma etc anywhere in the code...
Like
if(sheet1.cells(3,39))="4" then
you need to write the code in correct format first.
To lock the cell you can have the following code
Cells.Select
Selection.Locked = True
Regards,
Tariq Kamal
www.gate2q
Hi,
What all fields do you want to track and what all heads (date, eforrt,
etc) do you want in te sheet
Regards,
tariq kamal
www.gate2quality.com
On Mon, Jan 12, 2009 at 12:56 PM, Archana Mestry
wrote:
> Hi Guys & Gals,
>
> I need a project mangement excel sheet where I can
It's easy just send me the sheet...Need to use "branching" and "lookup
functions"
i.e. If statement and lookup function to get this done
Regards,
Tariq Kamal
www.gate2quality.com
www.rideahead.blogspot.com
On Sun, Jan 11, 2009 at 12:14 AM, How Do you? wrote:
Just forgot to mention that "Field 2" means Second column in which filter is
applied
On Fri, Jan 9, 2009 at 11:10 AM, Tariq Kamal wrote:
> Hi Shay,
>
> The code for filtering is
>
> Sub filter1()
>
> Dim count As Integer
> Dim i As Integer
&
that's why cells (i,4) ) starting from first row...This way it
will go to row 12 and hence the definition of i from 1 to count, where count
= 12
Hope this helps..
Regards
Tariq Kamal
http://www.gate2quality.com
http://www.rideahead.blogspot.com
On Fri, Jan 9, 2009 at 10:35 AM, shay shay w
Some of the topic you can find on the site www.gate2quality.com
I will be updating the site with more stuff in coming days.
On Wed, Jan 7, 2009 at 10:17 AM, Kamal Gulati wrote:
> *Dear All, *
>
> * *
>
> *I am new in this group. And I really like the posting that you all have
> made. It's a
Hi Madhur,
Freewares are also available which can open the file and then you can reset
the password.
Regards,
Tariq
On Tue, Jan 6, 2009 at 6:59 PM, Tanzeem Ahmad wrote:
> Hi Madhur,
>
> The passwords cud be changed . Like i Changed the password of this VBA to
> 1234
> try and check it :)
>
>
15 matches
Mail list logo
