How can I find data in one list and add it to another sheet?

  • Thread starter Thread starter soconfused
  • Start date Start date
S

soconfused

I currently have two workbooks in which I need to have data from one
transfered to the other. One workbook contains many sheets and I need to
look in 4 sheets to find the information that I need. The workbook that I
need the data transferred to also has many sheets, but for the year we are
currently in, I only use one sheet.

How can I grab the data from the first workbook and transfer it in the
correct columns to the 2nd workbook.

Thanks in advance for any help you may be able to provide.
 
I need it to fill in automatically when I input data into the first sheet.
The workbooks are completely different in the way they are setup. The one
common piece of data is the part number.
 
Back
Top