Adding a query into a Microsoft Excel 2007 table

I have added a query into a Microsoft Excel 2007 table. But, I'm looking to add a parameter from one of the cells into the query. Is there a way to do this?

ITKE1,149,700 pointsBadges:

Pivot table changing into values on save

I have created a pivot table in which one field is calculated field. I saved and closed this pivot table. Next time when I open it is changing into normal Excel table with values. But I want this to open as pivot as is. How can I rectify this problem? Please help someone. Application using: Excel...

individually5 pointsBadges:

Filters

How do you remove the filter arrows from an Excel table?

ericanjung5 pointsBadges:

Excel 2003 Macros with Org Chart Parent

Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you. COL  ...

Vanillathunderrr5 pointsBadges:

Pivot table automatic update in Excel 2010

How to make my pivot table automaticly updated if I edit, delete, append the source data?

Eogy60 pointsBadges:

Proper Excel 2007 macros to identify table

dear sir/madam i have a table such as the left table and want to extract a table like the right one please give me the proper macro. best regards. hamid [table style="border-collapse: collapse; width: 300pt;" border="0" cellpadding="0" cellspacing="0" width="400"> [col style="width: 63pt;"...

Hamidirani575 pointsBadges:

VBA EXCEL 2003 table coding

Trying to write VBA code taking daily averages from datalogger (144 values/day). Its placing the averages every 144 lines apart in excel sheet. Looking for coding to condense averages into table.

Bellyflop5 pointsBadges:

excel table to text flat

Hello, I am not an IT expert to start with! I have a series of tables in excel made of 3 dimensions. Two dimensions are vertical (indicator and country), one is horizontal (years). The different tables contain data for a variable number of years and for a variable number of countries and...

Brunella5 pointsBadges:

HELP WITH JOINING 5 TABLES

I need to join 5 tables and the probelm is that I have imported 5 seperate excel spreadsheets and the first column in all the spreadsheets is the same and I need to combine all that data to see if there are any duplications throughout the 5 spreadsheets and then combine some data that may be the...

Law1235 pointsBadges: