How do I set up an Excel worksheet that compiles data from other .

B

BeginnerExceluser

How do I set up an Excel worksheet that compiles data from other Excel
worksheets. If the directions are too lengthy what is the proper Search Term
to use?
 
J

Jose366

Try VLookup or HLookup. If you have a "main" table with a common field to
the other tables these should work well for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Merging from an Excel file with graphics 1
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Compile data from several workbooks 1
Excel suddenly crippled by Just-In-Time Debugging 2
Multiply with Vlookup value from another Worksheet 0
Excel 2010 countifs for date range 3

Top