+ Reply to Thread
Results 1 to 2 of 2

column in sheet TTT match column in sheet1 , return the cell value in sheet1 to sheet TTT

  1. #1
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    column in sheet TTT match column in sheet1 , return the cell value in sheet1 to sheet TTT

    Dear all,

    attached file with vba code dont work, it is diffcult vba for my limit. pls help

    If the column AH(sheetTTT) match column B(sheet1)
    And column BF(sheetTTT) match column A(sheet1)

    Then column AM(sheetTTT) value
    If less than or equal to column D(sheet1) , then return the
    Column c(sheet1) , otherwise delete the record

    Let have an example,
    If row 3 , column am is 98.4, then return 10%
    If row 4 , column am is 98.2,then return 10%
    If row5, column am is 98.7, then return20%
    If row6, column am is 99.3,then return33%
    If row 9, column am is 98.5, then return 15%


    After vba code the answer in sheetTTT should same as sheet2

    pls help

    Thanks
    Tom
    Attached Files Attached Files
    Last edited by hktom; 06-01-2018 at 02:01 AM.

  2. #2
    Registered User
    Join Date
    02-23-2015
    Location
    hk
    MS-Off Ver
    window7
    Posts
    240

    Re: column in sheet TTT match column in sheet1 , return the cell value in sheet1 to sheet

    Dear All

    Any idea can make the vba work ?

    Tks
    Tom

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to sum total of a column on sheet1 and add the value to a cell on sheet 2
    By danwoltrs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2015, 11:37 AM
  2. Replies: 2
    Last Post: 07-14-2015, 04:32 PM
  3. Replies: 6
    Last Post: 05-12-2014, 02:35 PM
  4. Copy certain data from Sheet1 to Sheet 2 based on values in a column on Sheet1
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 01:28 PM
  5. [SOLVED] I need a formula to return a column of data from sheet1 into sheet 2
    By DustOfTheEarth in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-15-2013, 06:36 PM
  6. Replies: 1
    Last Post: 12-30-2012, 07:52 PM
  7. [SOLVED] Simple formula to match column A, sheet1, with column A, sheet2, return text answer
    By Connie5761 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-14-2012, 02:56 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1