1. open both workbooks and position them side-by-side
2. select the first source sheet
3. locate the proper information and copy it
4. paste in the destination sheet.
5. continue steps 3 & 4 until complete and move to the next source sheet.
--
Gary''s Student - gsnu200857


"soconfused" wrote:

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.
--
DMM