View Single Post
  #1   Report Post  
ExcelDummy
 
Posts: n/a
Default lookup and transfer data

I have multiple spreadsheets that I want to move certain information from to
get all my info into one spreadsheet. Is there anyway to search mutiple
spreadsheets by a column like "Part Number" and tell it to retrive another
column like "Qty" then post it into a corresponding column in another
worksheet by matching "Part Number"??