If B5 matches a text in columb C, show answer in cell E5 from columb D in same row. DESCRIPTION FILE CATEGORY RESULT sandy...

Hi, I’m trying to use a macro to create a workbook of reports for 2010. I need a macro that will copy and paste from 3 master sheets to many new sheets in...

I was copying a worksheet to start a new, 12 month, 12 sheets, new workbook and when I copied the page to start the new worksheet, the sheet I pasted onto...

I have a table of weights, in pounds. How do I convert them to stones and pounds in excel. I dont want to say 14.5 stomes, I want to say 14 stones 7 pounds....

I have created a protected worksheet with unlocked cells to be filled in by the user and saved. Then next week I need to to have another copy of the same...

I have a spreadsheet with 4 cells that 1 of the 4 will have a calculated value in it. I want to take the numeric value in the cell that has a value and place...

When I try to enter an ASCII code for a character in Excel 2003, the keystrokes FN + ALT + 0322 for example, don't work. Instead of entering the accented...

I cannot label the X and Y axis in Excel. I would be grateful if any one would help. -- Thanks

Hi, I've created several custom toolbars as an .xla add-in and distributed them to various people in my company. This appears to be one of the better...

Hi, Happy New Year 2010. May I know if I can fill A,B, C,.. ZZ across and downwards ? Thanks Low

Hi, Happy New Year to you. I have the following table: A B C D E Total Type 1 ...

I'm trying to print a worksheet and it's not printing fully...it stops printing halfway through the bottom row of cells. The print area is set and the whole...

If an "average" formula includes multiple columns, and those columns change each month by hiding old months (at end) and adding new months (at beginning)...

Hi Guys, I want to know how can I do this: I have column A and B and and with this two number, add then and see the data in the cell Column A Column...

Please help. I just purchased a new laptop and installed office 2003. When I open up and excel file a pop-up window for 2007 prompts me for a product key to...

Column A has a long list of items that I use in a drop-down list that I named "CreatureList" How can use the "If" function and/or other functions to test for...

I'm desperate for an answer to this question!!! What does this error message mean and how do i fit it???!! Doing mutliple regression analysis and I...

hi i need to round down to the next whole number only 10.81 needs to be 10 9.2 needs to be 9 cant use decimal place formating as need to do calculations with...

This is what im using & i keep getting a REF error C5 is on a total different worksheet & im looking for numbers in the other 52 worksheets to match with...

I am using Excel 2007 with Windows 7 on a ThinkPad X61. When I right-click the Excel icon on the TaskBar, and then click on any spreadsheet shown in the list...