1
  • 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?

    ITKE829,015 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:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following