Pivot table automatic update in Excel 2010
How to make my pivot table automaticly updated if I edit, delete, append the source data?

Answer Question   |  January 12, 2011  12:31 AM
Excel 2010, Excel Tables, Pivot tables, Windows XP Professional

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 [...]

Answer Question   |  March 11, 2011  3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros

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;" width="84">[/cOLIST] [col style="width: 62pt;" width="83">[/cOLIST] [col style="width: 48pt;" width="64">[/cOLIST] [col style="width: 66pt;" width="88">[/cOLIST] [...]

Answer Question   |  August 25, 2010  7:30 AM
excel, Excel 2007, Excel 2007 macros, Excel macros, Excel Tables

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.

Answer Question   |  April 16, 2009  9:13 PM
Excel 2003, Excel Tables, Microsoft Excel, VBA

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 indicators, therefore each [...]

Answer Question   |  March 20, 2009  5:33 PM
Excel macros, Excel Tables, Microsoft Excel

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 [...]

Answer Question   |  February 19, 2009  8:47 PM
Excel Tables, Microsoft Excel