View Single Post
  #2  
Old April 19th, 2010, 02:02 AM posted to microsoft.public.excel.worksheet.functions
PY & Associates[_2_]
external usenet poster
 
Posts: 14
Default How do I match 3 different workbooks information for similardata?

On Apr 18, 10:24*pm, dlh wrote:
I am working with 3 different workbooks that contain some similar data. I am
trying to find a way I can match up that data in a separate workbook. The
first workbook I pull off a website, the other two are also pull out of a
company website. These three sites give me a option to save as excel
spreadsheet. What is constant in these three spreadsheets is the PO number,
part number, some times a date reference. Its very time consuming, being I
have to perform this on a daily basis. What would be the best way to get this
done.


Can we see the first 5 lines of each of the files please?