Adding another Column

Skybluekid

Well-known Member
Joined
Apr 17, 2012
Messages
829
Hi All,


I have an existing Query which gets its data from an Excel Table. I would to include a column from the excel Table, which is not in the existing query. Can this be done?


Thanks in Advance
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,823
it depends on the structure but in general: it can be done
 

Skybluekid

Well-known Member
Joined
Apr 17, 2012
Messages
829
I have 3 queries all coming from 3 tables, which are all in separate worksheets. They combine into one query which in turn loads into a table. I would like to add 1 column from each of the separate worksheet which was not loadef in the original query.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,460
Messages
5,487,017
Members
407,575
Latest member
calc

This Week's Hot Topics

Top