+ Reply to Thread
Results 1 to 3 of 3

Need formula or Macro to pick the value of cell with ref. to another text in excel sheet

  1. #1
    Registered User
    Join Date
    08-21-2017
    Location
    UAE
    MS-Off Ver
    office 365 proplus
    Posts
    17

    Need formula or Macro to pick the value of cell with ref. to another text in excel sheet

    Dear Friends,

    Please help me with the excel formula / Macro to pull the employee number from my payroll sheet with reference to pay mode as cash salary to my existing excel sheet(separate sheet).

    Example attached for ref.

    Master for the report as below:
    Code Pay Mode
    9101748 Bank Transfer WPS
    9101749 Bank Transfer WPS
    9101750 Bank Transfer WPS
    9101751 Bank Transfer WPS
    9101752 Cash
    9101753 Bank Transfer WPS
    9101754 Bank Transfer WPS
    9101755 Bank Transfer WPS
    9101756 Bank Transfer WPS
    9101757 Bank Transfer WPS
    9101758 Bank Transfer WPS
    9101759 Cash
    9101760 Bank Transfer Non WPS
    9101761 Cash
    9101762 Cash
    9101763 Cash
    9101764 Bank Transfer Non WPS
    9101765 Bank Transfer Non WPS
    9101766 Cash
    9101767 Bank Transfer Non WPS
    9101768 Bank Transfer Non WPS
    9101769 Cash
    9101770 Bank Transfer WPS
    9101771 Cash
    9101772 Bank Transfer Non WPS
    9101773 Bank Transfer WPS
    9101774 Cash
    9101775 Cash
    9101776 Bank Transfer Non WPS
    9101777 Bank Transfer Non WPS
    9101778 Cash
    9101779 Cash
    9101780 Cash
    9101781 Cash
    9101782 Bank Transfer WPS
    9101783 Cash
    9101784 Cash
    9101785 Cash


    Report required as below

    S.NO Emp No
    1 9101752
    2 9101759
    3 9101761
    4 9101762
    5 9101763
    6 9101766
    7 9101769
    8 9101771
    9 9101774
    10 9101775
    11 9101778
    12 9101779
    13 9101780
    14 9101781
    15 9101783
    16 9101784
    17 9101785


    Thanks,
    Vijayaraghavan

  2. #2
    Registered User
    Join Date
    09-27-2018
    Location
    India
    MS-Off Ver
    2013
    Posts
    14

    Re: Need formula or Macro to pick the value of cell with ref. to another text in excel she

    hi,
    can u provide a sample worksheet, that will help in building up the formula.

    regards
    anup

  3. #3
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Need formula or Macro to pick the value of cell with ref. to another text in excel she

    Give more details and explain the result from first sheet to the second one
    - Battle without fear gives no glory - Just try

+ 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. Replies: 3
    Last Post: 12-08-2016, 10:37 AM
  2. Replies: 4
    Last Post: 07-14-2016, 08:47 PM
  3. Replies: 4
    Last Post: 07-03-2012, 06:33 PM
  4. Create a pick list to use to go to a text cell in Excel
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Create a pick list to use to go to a text cell in Excel
    By Debra Dalgleish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. Create a pick list to use to go to a text cell in Excel
    By Pegita in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] Create a pick list to use to go to a text cell in Excel
    By Pegita in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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