hi,

i really frustrated and no excel expert.

bit of background: i have a till system with 12000 lines that has crashed and needs to be uploaded to a new system. I thought i could up load a CSV file so have gone about creating it instead of re inputing it. My original information has come of 2 separate PDF files generated off the old till before it died.One pdf has info like the item description and retail price while the other has the cost price and supplier details. Crucially (i hope!) both pdfs have the barcode for each product on. I need both sets of information in one place

I have used a pdf converter to make them both info into separate excel files, but this process has put all the info into separate sheets for each page of the pdf which i have found out you can't merge into one list on my version of mac/excel (no VBA?)

i have diligently gone about copying and pasting one of the workbooks into something more organised. it now comprises of organised columns on one sheet. it took a week!

My problem is that if i do the same with workbook 2 is that although the rows are organised (right price by right bar code...) the order is different to workbook one making a simple copy and paste impossible.

Therefore here is my question: if column "a" is "item number" on my good sheet, can i get excel to find the same item number off the other workbooks sheets and then show the value of cell (e.g. cost price) taken from that workbook ( it would be on the same row as the matching item number,) on the good workbook?

i do hope so!

any help would be appreciated!