Announcement

Collapse
No announcement yet.

Lookup Across Worksheets. Return Corresponding Value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lookup Across Worksheets. Return Corresponding Value



    Hi, I am new to VBA and hope that someone can help me out with this problem.

    On "sheet 1" I have a cell A1 with a number 12550 in it. On the following 6adjacent cells from B1 to G1 there are specific values assigned to them.
    (Eg. $20, $30, $40, pork, 145, and spicy)

    There are currently 4 worksheets in the workbook and some of the worksheets contains the value "12550" in CellA1 of Sheet 1 while others don't.

    I wish to search in a similiar column, from A1 to A50, throughout sheet 2, 3 and 4, for the value of "12550". Once the value is found in a sheet, the corresponding values to the 6 adjacent cells (from B1-G1 in Sheet1), are copied and pasted next to the "12550"cell.

    If there are no "12550" cells found in a sheet, the macro should continue as normal.

  • #2
    Re: Transfer Data After Column Search Into Other Worksheets

    Try the Custom Function of VLOOKUP Across Worksheets

    Comment


    • #3


      Re: Transfer Data After Column Search Into Other Worksheets

      Hi,

      See the attachment.
      Attached Files
      Kris

      ExcelFox

      Comment

      Working...
      X