Hi, I am stumped. In Excel 2007, I am trying to combine 2 reasonably large worksheets (thousands of columns) into a seperate third worksheet by comparing the...

I have the same problem but when I format (right click and choose "format cells") the Zip Cell in Excel to Zip+4 it works good in excel except in the formula...

I have two variables taken from textboxes on a userform: XPosVariance & XNegVariance I want to have them displayed in a cell when clicking done on...

Here is my question with detail. In one worksheet I have a value, that is created by a formula, in a cell. I would like to copy the result of that formula...

I am trying to put together a database of building costs that will have a drop down list that includes such elements as Flooring, Ceilings, Decorations etc....

Probabally a really simple question but Im looking to do my IF function in a couple of stages firstly to check cell L72 and check if the value is greater...

When I select multiple sheets in an Excel Workbook and then do a straightforward copy and paste the 'undo' history is lost i.e. the button on the toolbar is...

Hello I just need some help with a small macro. I need it to find any values in a sheet that have the value "#N/A N/A". The macro then need to copy down the...

I have a pivot table the summarizes data along the left, first by product, then by customers that bought that product. NO filters are set to mask any of the...

IN THE OLD EXCEL YOU WOULD GO TO DATA CLICK FILTER FIND WHAT YOU NEED THEN GO BACK TO FILTER TO UNDO IT. IN THE NEW FILTER I HAVE NO IDEA HOW TO RETURN. MY...

I am trying to sum a range of cells based on the location (listed vertically) the item was used and the date (listed Horizontally) the item was used.

If I try to click the font size menu button or the print (print preview) icon, the screen turns white and an error occurs, then the program quits. This...

I want to creat a drop down menu with 4 options people can pick from. If they pick one of the options I need more details. Is there a way to set it up so...

I want to calculate a daily interest rate from an annual rate. I have input the following formula into a cell labelled "Days in the Current Year" :...

I am trying to create drop down arrows with list of numbers, or date, etc. I cannot remember how. I have tried everything like validation then the list...

Im trying to make a excel sheet with conditional formatting... I want to higlight a cell red if there is nothing in another cell... how would i go about this?

I currently have a string of items that looks like the following: #N/A #N/A 1" Shaft Liner DensGlass Ultra 2'x12' #N/A #N/A #N/A 1/2" 4'x12' Regular

Hi, I have imported numbers from web to excel and I tried to summerize it but the sum turns zero. I tried to change the original format to numberbut it...

I have a password protected file stored on my network that I share with several people. When opening the file and receiving the enter password window, it...

I have created a work sheet where now I would like to delete all the values but keep all the formulas. Can this be done?