Hi all, I am not a professional software developer, nor a GUI designer. I need help in improving the GUI of my Excel spreadsheet application. I currently...

Hi all, Is there a way to rotate a column of data into a row of data, in Excell 2003? Let's say B8 - B1000, there are so many of them... I want to rotate it...

Hi all, For an Excel front-end GUI user interface, what's the best way to interface it with a back-end computational engine using C/C++? I guess there are...

HI all, When the users open my Excel/VBA sheet, they met with a window asking if Macro should be enabled. My users are not that sophisticated... so I would...

Hi all, I have some buttons in my Excel files and assigned macro behind them. I have add password protection to the VBA code so without password, the users...

Hi all, I have the following control structure from Matlab, do you think I need VBA to handle it, or I can just rely on Excel? Thanks a...

Hi all, If I want B10 to B17 all follow the change of the same number(copy cell), let's say I put it in A1, and C10 follows the change of A2(copy cell), and...

Hi all, Can I enter data interactively and dynamically? To give an example: Approach 1: Currently, when I enter grades for students, I have to find his/her...

Hi all, I defined a cell named range: Let's call the cells A1 to A5 to be "trytry". Then in another cell, I enter "sum(trytry)", I will be able to get...

While in an EXCEL spreadsheet, when I link to an external closed workbook, sometimes it updates, and sometimes it does not. There seems to be no common...

I am trying to create a spreadsheet that, once saved as a .txt file, will be compatible with our accounting software (Timberline) and will enable us to...

I'm a CPA in industry, and have just taken a new position as Information System Director for a large site contractor. The accounting software my company...

Excel 2000: Need to compare text in cells in sheets. One spreadsheet has simplified company names as keywords in one column (e.g. B1 = "xyz", B2 = "abc corp"...

how can I place a company logo into the page header in excel?

Available in Excel 2003 thru the Pivot Table wizard. How do you do this in Excel 2007?

Can you enter data in worksheet 1 book 1 and have it automatically entered into another workbook? If yes what is the formula? Thanks

How can I select only the active area of a spreadsheet without using the mouse. Using ctrl+alt+spacebar gives me the entire sheet, which is way too much, as I...

I have multiple sheets having varying rows of data. I need to select all data in each sheet for sorting without click and drag, perhaps for a macro. Any...

Can anyone help me with this problem? Is excel capable of performing this task? I have set the cell format to: # ??/?? AW5 AX5 AZ5 ...

I am trying to write a SUMIFs formula using two sets of criteria from different columns, but I need it to be an "either/or" formula. Is there a way to do...