+ Reply to Thread
Results 1 to 6 of 6

Updating old part numbers to new without effecting unchanges numbers

  1. 03-26-2010, 07:24 AM #1
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Updating old part numbers to new without effecting unchanges numbers

    Hi,

    Our stock system relies on manually updating the prices using formulas in excel. A problem I'm experiencing is that our suppliers tweak existing part numbers and add new ones on the list without highlighting the changes they make.

    I have attached the spreadsheet that I'm working on.

    In the 'Exported Part Numbers" Tab I would like to show the most current part numbers (shown in Column A in "New Price List Part Numbers"). I want to be able to drag the formula down and it to update any superseded part numbers, however leave the numbers that haven't changed the same.

    I hope I have explained my predicament sufficiently.

    Many thanks for all your efforts

    Sam
    Attached Files Attached Files
    Last edited by 3smees23; 03-29-2010 at 06:01 AM.
    Reply With QuoteRegister To Reply
  2. 03-26-2010, 07:53 AM #2
    arthurbr
    arthurbr is offline
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Updating old part numbers to new without effecting unchanges numbers

    Hi
    maybe something like =if(b2<>a2,a2,b2)

    and drag down as needed
    Reply With QuoteRegister To Reply
  3. 03-26-2010, 08:44 AM #3
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Re: Updating old part numbers to new without effecting unchanges numbers

    Hi,

    Thanks...but im trying to execute the formula in the 'exported part number' tab. All it is doing is replicating what is being displayed on 'New Price list Part Numbers' tab (column A).

    I need to some how keep the order of the part numbers on the 'exported part number' tab.

    Any more suggestions?

    Thanks

    Sam
    Reply With QuoteRegister To Reply
  4. 03-29-2010, 03:29 AM #4
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Re: Updating old part numbers to new without effecting unchanges numbers

    Can anyone help me with this?

    Unfortunately =if(b2<>a2,a2,b2) didn't achieve what I needed.

    Thanks for all your time, It's greatly appreciated.

    Regards

    Sam
    Reply With QuoteRegister To Reply
  5. 03-29-2010, 03:57 AM #5
    Dav
    Dav is offline
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500

    Re: Updating old part numbers to new without effecting unchanges numbers

    well perhaps on the export sheet, say in column B
    Please Login or Register  to view this content.
    Assuming that the part number will exist in the new part numbers, if it is not in the old part numbers.

    Regards

    Dav
    Reply With QuoteRegister To Reply
  6. 03-29-2010, 06:01 AM #6
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Re: Updating old part numbers to new without effecting unchanges numbers

    Thanks Dav

    Solved!!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1