+ Reply to Thread
Results 1 to 2 of 2

Copy cell information from one worksheet if a cell matches the criteria

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    5

    Copy cell information from one worksheet if a cell matches the criteria

    Here is what I'm trying to figure out for the formula. I have two worksheets (Master Sales and Inventory)

    Inventory has columns
    Item Description Vendor Item Number Invoice# Purchased Price Qty Inventory Balance

    Master Sales has columns
    Item Number Item Description Purchased Price Shipping Costs Etc . . . . .

    I want to copy the purchase price from inventory and copy to the master sales to input the price that corresponds to the item description. What would the formula be for this. Please help, thank you.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: Copy cell information from one worksheet if a cell matches the criteria

    Hi and welcome ot the forum

    Take a look at using the vlookup() function for this
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Copy cell information based on another cell criteria
    By brian807 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 09:14 AM
  2. Copy whole row if criteria matches one cell
    By HayleyH86 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-21-2013, 07:33 PM
  3. [SOLVED] Copy Rows if first cell matches criteria
    By amq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 11:23 AM
  4. Replies: 4
    Last Post: 08-23-2012, 05:26 AM
  5. How to copy rows where a single cell matches certain criteria?
    By Sccye in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2011, 09:42 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