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

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

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

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.

--
DMM


"Gary''s Student" wrote:

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

To automate the process you would need a macro. You would need to exactly
specify the source and destination columns and any logic that determines the
destination options. Here is a typical example:

http://groups.google.com/group/micro...254c3ee4370ad#
--
Gary''s Student - gsnu200857


"soconfused" wrote:

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.

--
DMM


"Gary''s Student" wrote:

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