Hello everyone, in Excel 2007 we have the new cube functions described in this blog for...

I am formating a dashboard where you select which dash board from a drop down menu (P&L, KPI's etc.). When I change the dash board with the drop down menu...

"Mr L Hibbert" wrote: hello im trying to compile a small folder consisting of different worksheets, each worksheet is a different customers sales etc.......

Dera plz solve my problem, i m working in a bank my query is that Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and this balance...

"Jay" wrote: Yes, go to the cell right click and select format cells from the pop-up menu. Then go the very last right tab and place a check mark in...

Does this work the same way in 07? I have tried it several times. However, it will not allow me to copy and insert a row without entering the...

Excel 2007 Data Table http://www.mediafire.com/file/w2omdzdz2yy/03_20_10.xlsx Pdf preview: http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_20_10.pdf

This may sound like a basic question. But I am trying to set up some conditional formatting based on varying text in Excel 2003. I am sorting baseball...

On Mar 19, 9:23*pm, Domenick wrote: When I manually correct these spreadsheets, I have to select all the cells that...

I previously asked a question regarding auto height with merged cells and was given a code to enter into visual basic. I entered the code and copied & pasted...

I have 63 file. My data set on to column X, and G2 is row number related to column X. I need to macro or formula, when run it on any file, copy of column X...

Requires a f

I have huge spreadsheet with dozens of columns, and filters are on most columns. In my last column, I want to systematically post the results only of...

How formulas can be implemented in excel by connecting to it using odbc in c#. Help with some sample code will be greatly appreciated?

I need to show some references in de form of A11_A11_1a in a table, and with the order given by each section of the references. I tried using pivot tables...

I have several cells have conditional formatting equations which refer to a date value in cell H1 (for example). I want to be able to move the value stored on...

I've noticed since changing to Excel 2003 that when I have a spreadsheet that I want to do multiple subtotals on that if I have one grouping within a group...

Hello, I'd like to get access to a chart series via vba. This works fine with ActiveChart.SeriesCollection(1).Values = "='" & ActiveWorkbook.Name & "'!"...

I am a teacher in a department of 3. We all keep records of the results our individual classes achieve on identical Excel worksheets. I need to be able to...

Hi, I'm using excel 2007, I have a pivot table and I'm trying to create a calculated item, the formula for the Calculated item is: IF(MID('Project...