Is it possible to have a button on a worksheet and just have the buttons say "notes". Then when it's pressed a dailog box opens for the data entry?. If so, how...

I try to use ALT+ENTER in a function, but the result is a continous line. ex. C1=A1 &A2 &A3 Is there any way to produce a result in C1 with hard breaks?

I am using the lookup function to find similar values in two different columns and am able to get the desired results. However when I want to bring the value...

Hi, This is my spreadsheet. Column C has the LOOKUP formula. A B C 53 a a LOOKUP(A2,$A$2:$A$14,$B$2:$B$14) 447 b b LOOKUP(A3,$A$2:$A$14,$B$2:$B$14) 1...

I would like to be able to forecast next years production using previous years production figures.

I have a Macro that essentially consolidates all the same data in column A, then separates the worksheet into individual worksheets, named based on the data...

Not sure why all the data isn't shown in the filter pull down. I'd like to scroll through the pull down instead of using the custom filter option in the pull...

I need to create a list range Under data, point to list and then create list. I do not have list listed under data. Where can it be found?

I am having a problem with matrix functions in general. No matter what variation of sequences I use (the correct one included) I find that Excel SOMETIMES only...

would I use excel calculate totals of my daily cost codes as there inputed

I am trying to use the COUNTIF function to count the number of text frequencies on a line that match a "text phrase". then i am try to copy this formula to 200...

I am trying to insert round function on external reference functions, and nothing is happening. 'Category Financial Review'!G7/(H7*$L$4) is the formula I am...

I need to open up 50 text files and merge them into a worksheet (in less than 50 moves)?

I'm using an Excel document to keep track of the cases I handle in my department. I have several columns, B through L, with each cases information. Once a case...

Hi there I have created a workbook which links to 5 other workbooks and my formulas pull the data out of the 5 and put it into one consolidated workbook,...

Please help. I am entering minutes and seconds...i.e. 34:10 into a worksheet to be charted. One column is number of calls, the other column is minutes and...

I have two worksheets, one with charts and one with tables. Both of them report data on separate worksheets. I use separate worksheets because the format of...

How do I find, load and install the add-in features on the Excel 2003 office program ?

What I am trying to do is link a worksheet to another worksheet. When I change the original I want it to change on all of the other sheets. Is this possible?