I have budget information to be imported as text to my financial suite. The date data (which remains the same) is on row 5 columns 'R' to 'AC'. The data on...

Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates...

It would be useful if I could use custom filters (the same as in Autofilter) on pivot table Row/Column/Page fields rather than only being able...

O.K. this code is working to put in a formula that sums a certain number of rows every time the if statement is true, however I need to alter the code to sum...

Excel hyperlinks are presumed to be aimed at other Excel files. How can I create a hyperlink in a cell, that takes the user to a project folder (so that...

Hi all, Im making a table that is referencing another set of data. The x-range of the data is in months ranging from (Feb-06-Nov-08) on the Y axis is (Items...

I have the following formula on one of my worksheets but when cell B3 is "All" I return the correct value but when it's not "All" I get an error #VALUE!....

I would like to have a formula in column C that would look at column A and Column B and combine both entries . There are blanks where indicated. A ...

I am using the following Index formula to look at the values in certain cells (every 7th column in a given row) and see if they exceed a certain value and...

This might be a very simple problem, but here it goes.... I have created a form to be filled out and the user requested to be able to 'tab' through the sheet...

Hi: I need to import some cells from an external sheet but via relative path. Is it possible? How can I do it? Thanks

Hi, I am making a questionlist, kind of a questionaire and i am trying to use comboboxes. I can select the option via the toolbox but I cannot enter my...

This stupid little "PaintBrush" keeps popping up and blocking the cells I am trying to work with. It is more annoying than the "automatic" mulitple copy...

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -= why the. security services? -= -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= You may ask, why do I think the "they" referred. to are...

How can I make that the printing set up for the first tab applies to the rest of the tabs in the excel file. Thanks, jose

I'm new to Excel and I'm trying to print packing slips for orders. I would like to enter the whole order and have excell separate the order by quantity and...

I am trying to get ask if H2 is greater than or equal to 50 and I2 is letter C please make true

Hello: To download a bunch of EXE files I have to perform the following steps MANUALLY: * Go to a specific web site. * Submit an Invitation Code *...

I have a Large Spreadsheet and i use Auto Filter to find the Info i require. No Problems. In the Original Spreadsheet some CELLS i have BOARDERS arround. Auto...