Results 1 to 4 of 4

Thread: Excel Help Please

  1. #1
    Join Date
    Aug 2009
    Posts
    1

    Excel Help Please

    Hi

    I need some advice on how I can get 2 x Excel workbooks sharing data and updating each other. The scenario I have is as follows.

    WB1 contains customer names in column A, customer subsidary names in column B and names of individuals (account managers) in column C
    WB2 contains quotation information for customers that may or may not appear in WB1, WB1 has a designated column for customer name (column D)

    What I need to happen is when a customer name is submitted in WB2 column D, I need it to talk to WB1, search for a match (or similarity if possible) against the customer name in Column A and/or Subsidary in column B and once a match is found enter the account manager details (from WB1 column C) in one of the columns in WB2.

    Help ! - Any questions please ask

    Thanks
    Lee

  2. #2
    Join Date
    Sep 2009
    Posts
    1

    Re: Excel Help Please

    Hi,

    You can do so by using vlookup.
    In wb1 worksheet I ve used col A as customer name, col B As Customer subsidiary name,col C as account manager

    In wb2 I ve used col A as customer name,col b as account manager
    In col B Ive used the formula,=IF(ISERROR(VLOOKUP(A6,'[wb1.xlsx]Sheet1'!$A$2:$D$100,3,FALSE)),IF(ISERROR(VLOOKUP(A6,'[wb1.xlsx]Sheet1'!$B$2:$D$100,2,FALSE)),"Empty",VLOOKUP(A6,'[wb1.xlsx]Sheet1'!$B$2:$D$100,2,FALSE)),VLOOKUP(A6,'[wb1.xlsx]Sheet1'!$A$2:$D$100,3,FALSE)), which would select the account managers name from col C in worksheet WB1 if available.

    Yo will have to change the table details "$A$2:$D$100" based on how u have entered the data
    Good Luck !

  3. #3
    Join Date
    Apr 2008
    Posts
    2,139

    Re: Excel Help Please

    Microsoft Excel shared workbooks provide a simple, flexible way for a group of people to collaborate on a list or other data-driven project. If you share the workbook, then each person opens the workbook itself and works in the workbook. It imposes some limitations on the workbook, but I don't think anything that would affect what you are doing. I would pursue that first you try to develop a custom solution. With a shared workbook, you can design your workflow around familiar Excel features.

  4. #4
    Join Date
    Sep 2009
    Posts
    3

    help

    How to get a filtered list containing something i type into a cell

Similar Threads

  1. Replies: 6
    Last Post: 17-02-2012, 01:18 PM
  2. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 05:00 PM
  3. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 09:17 PM
  4. Replies: 6
    Last Post: 17-05-2011, 10:00 PM
  5. Replies: 4
    Last Post: 13-02-2011, 10:37 AM

Tags for this Thread

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
  •  
Page generated in 1,653,788,000.20587 seconds with 17 queries