Forum home » Delegate support and help forum » Microsoft Excel Training and help » Applying Queries to merge two worksheets
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Applying Queries to merge two worksheets
Resolved · Low Priority · Version 2007
Reply Wed 4 Aug 2010, 16:31Delegate Robbie said...
Robbie has attended:
Excel Intermediate course
Applying Queries to merge two worksheets
How do I merge 2 worksheets to map accross corresponding values onto one sheet
For upcoming training course dates see: Pricing & availability
RE: Applying Queries to merge two worksheets
Hi Robbie, thanks for your query. Have a look at this link:
http://www.exceluser.com/explore/msquery1_1.htm
Note you need to copy the individual sheets into one file (and then name the data ranges). Once you've got used to do this manually you can set up a template with the ranges already in place. Make sure you link the tables by their ID numbers and then simply select the columns you want your new table to include.
Hope this helps,
Anthony
Thu 12 Aug 2010: Automatically marked as resolved.
|