Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Lookup Across Worksheets. Return Corresponding Value

  1. #1
    Join Date
    29th October 2006
    Posts
    1

    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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,798

  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,678

    Re: Transfer Data After Column Search Into Other Worksheets

    Hi,

    See the attachment.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros. Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Lookup X & Y And Return Z
    By PY_ in forum Excel General
    Replies: 8
    Last Post: June 18th, 2008, 11:07
  2. Lookup Across Worksheets & Return Matching Details
    By tgraham in forum Excel General
    Replies: 13
    Last Post: January 7th, 2007, 02:28
  3. Replies: 6
    Last Post: September 21st, 2006, 19:10
  4. Lookup/Return Non-Matching Data in Worksheets
    By kesavan in forum Excel General
    Replies: 2
    Last Post: September 19th, 2006, 17:43
  5. Lookup Value and Return it
    By mvillarr in forum Excel General
    Replies: 4
    Last Post: January 1st, 2005, 03:14

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
  •  
porno