Consulting

Results 1 to 2 of 2

Thread: VBA Macros Help

  1. #1
    VBAX Regular
    Joined
    Oct 2008
    Posts
    28
    Location

    VBA Macros Help

    Hai

    Can Some One Help in One Small Application. I want to Remove the Duplicate Name in the Excel Sheet .
    Please See the Row 10 and 11 and it Contain the Duplicate Name

    I want the Output As Follows

    101 California - 77+2 = 79 in Column 3, 103+2=105 in Column 5,103+2=105 in Column 7, - + -= - in column 9 , 103+2=105 in Column 11 and 10+20/2=15 in column 13

    Before that I will tell the Value For Each Column that is Stored

    E Column Value is C12*12/9
    G Column Value is E12
    I Column Value is G12
    K Column Value is G12-I12

    Can Some One Help me to Solve

    Thanks and Regards

    Madhu.R

  2. #2
    VBAX Expert
    Joined
    Mar 2008
    Location
    Kent, England
    Posts
    853
    Location
    Where on earth does the 2 come from in your calculations??? because it is not on the sheet. Is it the count of how many duplicates it finds???
    If things don't change they stay the same
    Quite often there is a picnic problem (problem in chair not in computer)
    "We were not told it was impossible, so we did it."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •