+ Reply to Thread
Results 1 to 3 of 3

Communicating cells between tabs

Hybrid View

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    Berlin
    MS-Off Ver
    Office Mac 2016
    Posts
    1

    Red face Communicating cells between tabs

    Hi all,

    Sorry for my English - it is not my mother tongue.

    My question is maybe rather simple, but it is challenging me and driving me crazy when trying it for over a week now:

    What I aim for:
    In 'Tab 1' I have all kind of information:

    Object No. - Price - Costs - Inventory
    1 - 30 - 10 - 5
    2 - 40 - 20 - 6
    3 - 50 - 30 - 7
    4 - 60 - 40 - 8
    5 - 70 - 50 - 9

    In 'Tab 2' I would like to make a sheet that does the following:

    When I enter in cell A1 the object number (e.g.: 1).
    I want to see in a few other cells (e.g. B2, C3, D4) the other information to appear (thus: B2 is Price says 30; C3 is Costs says 10; D4 is Inventory says 5).
    When changing the object number in cell A1 from '1' to '3', the information in B2, C3 and D4 needs to be changed subsequently according the object no. information in Tab 1.

    Thus: When '5' in Tab 2 cell A1 - then look for '5' in Tab 1 column 1 (Object No.), refresh in 'Tab 2' the price, the costs and inventory.

    Do you have any idea how to proceed?

    Best and cheers,
    Kirsten

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: Communicating cells between tabs

    in B2
    =VLOOKUP(A1,Tab1!A$1:D$5,2,0)
    in C3
    =VLOOKUP(A1,Tab1!A$1:D$5,3,0)
    in D4
    =VLOOKUP(A1,Tab1!A$1:D$5,4,0)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    07-10-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    129

    Post Re: Communicating cells between tabs

    find your result in

    =+INDEX(Sheet1!$A$1:$D$6,MATCH($A2,Sheet1!$A$1:$A$6,0),MATCH(B$1,Sheet1!$A$1:$D$1,0))

+ 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. Communicating with Telnet
    By aldek in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2011, 07:22 PM
  2. VBA Code not communicating with Outlook
    By greekboyuk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-21-2011, 04:09 AM
  3. Communicating Between Two Sessions of Excel 2007
    By SDruley in forum Excel General
    Replies: 0
    Last Post: 07-26-2010, 10:49 AM
  4. Excel communicating with Access
    By bobaftt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-2009, 12:19 PM
  5. [SOLVED] Communicating with Excel from another program
    By Roy Sites in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2006, 04:25 PM
  6. [SOLVED] Excel communicating to csharp application.
    By roger.camargo@gmail.com in forum Excel General
    Replies: 1
    Last Post: 11-17-2005, 01:55 PM
  7. Excel communicating to csharp application
    By roger.camargo@gmail.com in forum Excel General
    Replies: 0
    Last Post: 11-17-2005, 11:45 AM
  8. Communicating with Outlook
    By Matt Jensen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2005, 10:06 AM

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