Okay, here's an example.

Workbook A

Sheet 1

Part #, Customer, Catalog #, Date, Eng Hours, Eng Bid, Eng Act, Dollars,

Sheet 2


All the same columns except the part numbers are different

Sheet 3

All the same columns except the part numbers are different.


Workbook B

Part #, Eng Bid hours, Eng act hours, Eng std hours, Ctr bid hours, ctr act
hours, ctr std hours.

Workbook B is a once a month input. I need to find the data from Workbook A
and have it automatically come across to Workbook B. The column setup is not
at all the same. The parts that I've shipped for the month could come from
any worksheet in Workbook A.

I hope this explanation helps.

Thanks.
--
DMM


"Gord Dibben" wrote:

Your request is too vague.

Safely assume we cannot see your workbookB and the data you want transferred
from workbookA

Now try to provide some details.

Find what from where and to which cells will the transfer take place.


Gord Dibben MS Excel MVP

On Tue, 23 Jun 2009 04:59:01 -0700, soconfused
wrote:

I have to do this on a monthly basis and I want it to find the data
automically. The workbook B is a workbook that has at least 10 sheets and
1000+ lines of data on each sheet. I need a formula to find the data.

Thanks