Compairing columns from two workbooks and updating data in
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Compairing columns from two workbooks and updating data in

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Cambridge England
    Posts
    521
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to write a macro which will look at two workbooks ( A & B), then
    update the price column (say column J)
    contained in a worksheet within workbook A with the data contained in a
    worksheet (column J) within workbook B.
    Both A and B workbooks have a common P/No field but the similar P/No's will
    almost certainly be on different lines
    numbers. I am sure VLOOKUP will come into the equation somewhere.
    Thanks for the help.
    eD

    _________________
    From eD
    traspberries@hotmail.com

    [ This Message was edited by: eddy on 2002-03-05 13:32 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,809
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-03-05 13:30, eddy wrote:
    I need to write a macro which will look at two workbooks ( A & B), then
    update the price column (say column J)
    contained in a worksheet within workbook A with the data contained in a
    worksheet (column J) within workbook B.
    Both A and B workbooks have a common P/No field but the similar P/No's will
    almost certainly be on different lines
    numbers. I am sure VLOOKUP will come into the equation somewhere.
    Thanks for the help.
    eD

    _________________
    From eD
    traspberries@hotmail.com

    [ This Message was edited by: eddy on 2002-03-05 13:32 ]
    Not sure why you want a macro here, but you can use in column J in the WB that needs prices from the WB that has that information.

    Your description of the problem omits alas much of the lay-out of the relevant data in both workbooks, so it's hard to be specific.

    Aladin


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com