+ Reply to Thread
Results 1 to 6 of 6

Updating Inventory Price Changes between two Sheets

  1. #1
    Registered User
    Join Date
    09-03-2014
    Location
    Toms River, NJ
    MS-Off Ver
    2013
    Posts
    3

    Updating Inventory Price Changes between two Sheets

    Hello,
    I am new at this and need a bit of help please.

    I have an inventory sheet and I get price change updates from time to time..
    The inventory is well over 800 products but the price changes are much less.

    I was wondering if its possible to match the part numbers from the price change sheet and to the full inventory and change the prices for COST and LIST on the full inventory sheet only affecting the price changed parts.


    Any help with this would be greatly appreciated .

    The price changes sheet is called PriceChange , the part number is in col A, cost in B, List in C

    The full inventory I'd like to change
    The sheet is called BulkProductData the part number is in col B, the cost is in col H, list in col I

    there are header rows on each sheet

    Again thank you for your time!

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Updating Inventory Price Changes between two Sheets

    Should be able to accomplish this using a "=VLOOKUP" function. If you're unfamiliar with this function, please upload a sanitized sample file and someone will write the formula for you.

  3. #3
    Registered User
    Join Date
    09-03-2014
    Location
    Toms River, NJ
    MS-Off Ver
    2013
    Posts
    3

    Re: Updating Inventory Price Changes between two Sheets

    Quote Originally Posted by hoyasaxa215 View Post
    Should be able to accomplish this using a "=VLOOKUP" function. If you're unfamiliar with this function, please upload a sanitized sample file and someone will write the formula for you.
    File is attached Thank you.. I thought Vlookup was the right direction but I don't know how to pass the price changes over to and write over the original sheet.
    Thank you.
    Attached Files Attached Files
    Last edited by DanCurran1; 09-04-2014 at 12:27 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Updating Inventory Price Changes between two Sheets

    The file you posted has headers, but is otherwise completely blank. Can you upload a file with a couple rows of sample data and that identifies the cells where the formulas should go and what you'd like to be imported into those cells?

  5. #5
    Registered User
    Join Date
    09-03-2014
    Location
    Toms River, NJ
    MS-Off Ver
    2013
    Posts
    3

    Re: Updating Inventory Price Changes between two Sheets

    Quote Originally Posted by hoyasaxa215 View Post
    The file you posted has headers, but is otherwise completely blank. Can you upload a file with a couple rows of sample data and that identifies the cells where the formulas should go and what you'd like to be imported into those cells?
    ok here is a sheet with limited data...

    The price changes sheet is called PriceChange , the part number is in col A, cost in B, List in C

    The full inventory I'd like to change
    The sheet is called BulkProductData the part number is in col B, the cost is in col H, list in col I

    there is a note on the sheet

    Thank you
    Attached Files Attached Files
    Last edited by DanCurran1; 09-04-2014 at 12:25 PM.

  6. #6
    Registered User
    Join Date
    09-03-2014
    Location
    Toms River, NJ
    MS-Off Ver
    2013
    Posts
    3

    Re: Updating Inventory Price Changes between two Sheets

    Thank you .. I got it figured out myself!

+ 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. Hi I need help with inventory price change
    By princess45 in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 12-27-2013, 03:46 AM
  2. Master inventory product price changes with new order
    By Mmurra22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2013, 09:13 PM
  3. [SOLVED] Need remaining average inventory price after partial inventory is sold
    By Akano in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 04:12 AM
  4. Supplier Inventory Best Price Analsysis
    By pilkingtond in forum Excel General
    Replies: 0
    Last Post: 08-27-2010, 05:16 AM
  5. Updating price sheets
    By -Lawless in forum Excel General
    Replies: 2
    Last Post: 02-03-2006, 04:14 PM

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