Consolidate Workbook

  • Thread starter Thread starter Douglas
  • Start date Start date
D

Douglas

I am using Excel 2000. I am trying to consolidate 2 workbooks into one. I
want to browse and find my two workbooks. What is the procedure?

Thanks

Douglas
 
Depends on what consolidate means.

If you just want a worksheet from each workbook to be combined onto single
worksheet,


then I'd open both files
copy the used ranges from one worksheet and paste to a new workbook.
then get the second file and copy and paste directly under the first paste.

Or if you're merging fields, you may want to take a look at =vlookup() (if
there's a nice unique key field in both workhsheets).
 
Back
Top