Posts by hdevadiga

Thank You Rory..

Hi All,

Thanks for your response in advance.

I am facing an issue while adding cell value in comment. I have an excel sheet which have two column A and B. Column B have the value which i want to put in comment.

When i run my macro code it is adding a comment but its not taking the adjacent cell value in comment. Can you please help me in this

I attached the file for your reference

Regards,

Hari

Hi All,

I stuck while working on Vlookup with wildcard thing. Actually i have two column, one is "Name" and second is "Amt". In "Name" column i mentioned "Harindra Gopal Devadiga" and in "Amt" column i mentioned "100".

Same way i have another two column with same names, "Name" and "Amt", now in "Name" column i mentioned "Harindra Devadiga" i skipped Gopal from it. Now what i want is with the help of VLOOKUP with WILDCARD i have to bring that same Amt.

For reference i attached the file in which the red color cell have a formula "=VLOOKUP("*"&D2&"*",A2:B2,2,FALSE)". Can anyone help me out in this.

Re: Want to export word bookmarks to Excel sheet row wise

Hi Thanks Carim... Thank You Very Much.. You Solved My Issue.. This is the Exactly thing which i want

Hi All,

I got stuck while exporting value of word bookmarks to excel sheet. i dont understand how to do this stuff. Here what i want is:

i want to export all the value in bookmark to excel sheet row wise. I have a word file which having text and check marks bookmark (For Eg: If anyone checked Staffing Placement than in excel sheet under Staffing Placement "Yes" should come, same way for text also) for understanding i attached excel file also having the value. I want it that way. Is this possible. I tried it but not got the answer. Can anyone help me in this.. Please

For reference i attached word file and excel sheet

Regards,
HD

Re: Only Locked the given range and Unlock rest of all -- Urgent Basis

It is very important to me and i apologize for breaking a forum rules

Re: Only Locked the given range and Unlock rest of all -- Urgent Basis

Till Now. No one is given the answer to this..

Re: Only Locked the given range and Unlock rest of all -- Urgent Basis

Hi cytop,

I am sorry for cross posting the post. But its very much urgent thats why i posted it. Please if you have solution, please let me know

Regards,
HD

Hi Friends,

Below code is not working fine.

Private Sub Worksheet_Change(ByVal Target As Range)


 Dim rngNonDelete As Range
 Set rngNonDelete = Range("H:J")


 If Not Intersect(Target, rngNonDelete) Is Nothing Then
 Application.EnableEvents = False
 If Target.Column = 2 Then
' confirm = MsgBox("Do you wish to confirm entry of this data?" _
' & vbCrLf & "You will not be allowed to change it!", vbYesNo, "confirm Entry")
' Select Case confirm
' Case Is = vbYes
 Dim Cell As Range
 With ActiveSheet
 .Unprotect Password:="asdf,1234?"
 .Cells.Locked = False
 For Each Cell In ActiveSheet.UsedRange
 If Cell.Value = "" Then
 Cell.Locked = False
 Else
 Cell.Locked = True
 End If
 Next Cell
 .Protect Password:="asdf,1234?"
 End With
' Case Is = vbNo
' Application.Undo
' End Select
 End If
 Application.EnableEvents = True
 End If
End Sub

What i want is lock only H:J range of column and unlock rest of all.

Can anyone help me in this.. Please its urgent

Regards,
HD

Re: Search the value in multiple sheets and display the entire row of matched value

Not an error, but it search for within one sheet. Its not searching in Multiple sheets.

Hi Friends,

I am getting an error while working on below code:

Private Sub cmdsearch_Click()
Dim a(), r As Range, res, i As Long, ff As String, rng As Range
Dim title
    
    title = Array("Unit Description,Unit Code,Roll Code")
    res = Me.txtsearch
    
    If Len(res) = 0 Then
Here:
        Application.EnableEvents = False
        With Me.ListBox1
                .ColumnHeads = False
                .RowSource = ""
                .Clear
        End With
        Me.txtsearch.SetFocus
        Me.cmdsearch.Enabled = True
        Application.EnableEvents = True
        Exit Sub
    End If
    
    With Me
        .cmdsearch.Enabled = False
    End With
    
    With Sheets("Data")
        Set r = .Range("DataRange").Find(What:=res, LookAt:=xlWhole, LookIn:=xlValues, MatchCase:=False)
                
        If Not r Is Nothing Then
            ReDim a(1 To 4, 1 To 1): i = 1
            faddress = r.Address: ReDim Preserve a(1 To 4, 1 To i)
            For ii = 1 To 4
              a(ii, i) = .Cells(r.Row, ii).Value
                If ii = 4 Then
                    a(ii, i) = r.Row
                End If
            Next
            Do
                Set r = .Range("DataRange").FindNext(r)
                If r.Address = faddress Then Exit Do
                i = i + 1: ReDim Preserve a(1 To 4, 1 To i)
                For ii = 1 To 4
                    a(ii, i) = .Cells(r.Row, ii).Value
                    If ii = 4 Then
                        a(ii, i) = r.Row
                    End If
                Next
            Loop Until r Is Nothing
        Else
            MsgBox "DATA DOES NOT EXIST!", vbInformation + vbOKOnly, "Alert Message"
            Me.txtsearch = ""
            GoTo Here
        End If
    End With
    noclick = True
    With Me.ListBox1
        .ColumnCount = 4
        .ColumnWidths = "270;100;100;0"
        If i > 1 Then
            .List = Application.Transpose(a)
        Else
            .Column = a
        End If
    End With
    noclick = False
End Sub

This above code search the value and display the entire row of matched value from one sheet.

Now what i want is this it should search in multiple sheet and display same (the entire row of matched value)

Can anyone help me out in this.

Regards,
Harindra Devadiga

Re: Fetch data from one sheet to another on the basis of criteria

Ya quite similar.

Like this i want:

I get a table from Mail and similar table format is mentioned in spread sheet also, but in spread sheet the names are not in similar format given in mail. May be there are here and there (Mismatch).

So now what i want is when i paste a mail table in Sheet 1 and press button it should get transfered to Sheet2 a same format of table but names are here and there in Sheet2 on the basis of Date criteria.

If i copy paste a table from mail of Date 01/10/2015 than the Sheet 1 table date should get transfer to a mentioned date (01/10/2015) table in Sheet 2.

Hope i cleared you query.

Regards,
HD

Hi Friends,

I am facing an issue while working on this sheet:

I want to copy a below range of data from Outlook Mail:

[ATTACH=CONFIG]67158[/ATTACH]

Now i want to paste the above value in below Excel Merged Data Validation Cell Range

[ATTACH=CONFIG]67159[/ATTACH]

Can anyone help me out in this thing using VBA or any easier way

Regards,
Harindra Devadiga

Re: Fetch data from one sheet to another on the basis of criteria

Hi Mumps,

No i would be anything from two digit to three digit.

Re: Fetch data from one sheet to another on the basis of criteria

Hi Bryce,

Ok if i use a Revised Table as you mentioned in your reply attached file. Than is it possible to fetch a data of Table from email sheet to Revised Table sheet

Hi Friends,

While working on sheet i stuck at one place. Can any help me out. Its very urgent.

I have two sheets (Sheet1 and Sheet2) in Sheet1 i copy paste a table from outlook mail.

In second sheet i have a same table with more formatting now what i want is:

A data inside a table in sheet1 should reflect in second sheet on the basis of date, Stream (Case Initiation (EAD-AP/STEM), Forms (EAD-AP/STEM), Names (Vijay, Jaffar, Aniket) criteria.
For Eg: if i input 1 in Case Initiation (EAD-AP/STEM) under Vijay (Production) column Sheet1 a same thing should reflect in sheet2

I hope you got the thing what i want

Regards,
HD

Re: Required Dependent Data Validation drop down

Hi Bro,

Me once again.. Can you help me out in below Thread.

http://www.ozgrid.com/forum/showthread.php?t=196841

Regards,
Harindra Devadiga

Re: Required Dependent Data Validation drop down

Thanks Bro.. Its great.. This is the thing what i want..

Thank you very much

TC

Hi Friends,

I trying to put a dependent data validation in below attached excel sheet. I have two sheet Dashboard and Data. In Sheet Data i have month wise candidate details and in sheet Dashboard i am trying to put dependent data validation.

Now what i want is, if i select any associate from the drop down menu that time in month drop down it should show the related months of an individual

For Eg: If i select Satish Devadiga in "Associate" Drop down menu, that time in dependent drop down "Month" it should show the months he worked for.

Hope you got my point

Regards,
HD

Re: Want to copy the data from one sheet to another sheet

Hi Roy,

In below attached file you will find a two sheets (Sheet1 & August 2015). In Sheet1 you will find a table which having data and name of the Associate (For Eg: Vijay, Jaffar etc) and in Column B you will find the Streams.

Now what i want is when i copy a table from outlook mail and paste it in Sheet1, that time data get fetch from Sheet1 and should reflect in August 2015 sheet on the basis of streams Column B (Case Initiation (EAD-AP/STEM), Form (EAD-AP/STEM) etc, Date ( 3-Aug-2015) and Names (Vijay, Jaffar etc) on August 2015.

Hope you got my point.

Regards,
HD