Good morning, I use define names in my Excel file, and I have about 1800 define names in that file. From time to time, I would like to make changes to the...

How You put the following as a vb code: =SUM(1013-J5)*28 -- Tdp

Hello, Using Excel 2007, I want cells in a column to be formatted according to cells in a different column and I want it to work so that if A1="text", B1...

Hello....hope you can help....thanks in advance! I have a formula which is =COUNTIF(C100:M100,0). I want to show an error message box when the result of...

I was migrated from SharePoint 2.0 to 3.0 last week. On 2.0, I had numerous 'update' Excel files where people would submit information. Those files all...

i would like to print a worksheet with rows and rows of data. I set a row heading on all pages in the page setup area. However, the last page (which will...

I am using this formula in a vlookup: =VLOOKUP(B4,'Sheet1'!$A$2:$E$10000,2) Hoever I need an exact match, sometimes it returns the close match. Any...

I want to install office xp small business in my new laptop with Vista is it compatible??

I am using Excel to track data on my employees. It would be helpful if I could search of the employee's last name, in stead of scanning the...

I have a very large password protected spreadsheet. When I save instead of saving the updated spreadsheet a back up copy is created. This is creating...

I want to do the following: I have one sheet that mainly has tables with data and tables with totals from these data etc. I would like to have something like...

Is there any short cut to high light in bold the sub total after the subtotal exercise. Your advise is important, thank you very much.

/Hi to all I have a MAX statement that I think I need to add an If/Or statement in front of to return a blank if the cell shows either a blank, a minus amt,...

I am using Excel 2007 on Vista Ultimate on one machine and Vista Home Premium x 64 on another. I have set the number of Recent Documents to 10 under...

Hi How do i slove this question? In the order form worsheet, all customer orders should be based on product in the product_List table. in the range B2:B20,...

Shane Devenshire, the info you gave was very helpful in converting text to numbers. Thanks again. How do I address the problem with the printer? As mentioned...

R/Sir, I have a problem in excel i have create a file in desktop and save it my office work. when i will open the file in desktop it...

I'm trying to put together a very simple line formula to give me a SUMPRODUCT from another worktab. I am entering the formula in the main tab, and I want it...

I need to increase the number of characters to be used in saving Excel File. How can I do that?

Hi Guys, I am currently using the formula: =Hlookup($B$36,$D$2:BB:42,2,False). What I need to add however is something that will return the corresponding...