General

why can't i browse to a location to save a flat file
Why doesn't the browse box pop up when i click on the export record button? Instead I have to type the filename and path. ... 1 Apr 2010 20:15

VBA to select all cells with content
Hi I need some advice with some VBA coding. I need to select all the cells in my worksheet which have content. Effectively selecting from A1 to the last cell in the last row , whichever it happens to be.. Can someone help with this? Thanks ... 1 Apr 2010 20:15

Cell Formats - Limit # of characters
I want to limit the # of characters allowed in a cell to 11, regardless of what the user types in (less characters is fine). How can I do this? -- KKD ... 1 Apr 2010 22:28

keeping values
I am sure that this question has been asked and answered. I am creating a worksheet for my class. I have a value in cell b2( I want use this value thru out the sheet). Let say b2 = 10 b c d 3 5 6 8 4 3 7 1 I want to subtract each value from b2(10). How can I do ... 1 Apr 2010 18:01

Formula help--lookup?
I have various items in a spreadsheet. Some of these items are repeated in various rows, but have a different text description for it. They all have the same reference number, just a different description. I want to combine all the descriptions into one cell. I am doing vlookup, but it is only putting in the fi... 2 Apr 2010 11:31

Vlookup in Excel 2003
when I enter a vlookup formula into a cell...I hit enter and the actual formula stays in the cell...SHOWING. It doesn't give an error message but just displays the actual formula with no action...Help, please! ... 1 Apr 2010 18:01

Formula help
I am sure this is a silly question, but hopefully someone can help me. I have linked information from one workbook to another workbook. the formula looks like this: ='X:\Municipal Court\Reports\Web Pymts\[Web Payments 2010.xlsx]Apr'!$L$7 What I am trying to do is to be able to fill in column down and have it ... 1 Apr 2010 18:01

series of sums in a long spreadsheet
I am trying to create a series of sums for a rather long spreadsheet with mulitple variables. I have several rows on my spread sheet, each categorized in genres such as "apple", "orange", and "pear." There is also a numerical value in a separate column for each of my rows that I want to associate with the cat... 1 Apr 2010 16:54

Lookup, vlookup, find, or what
Thanks in advance. Xcel07 on WinXP. I have a list of names in sheet 4, I need to search sheet 1, 2 and 3 to see if each name on sheet4 is located on any of the other 3 sheets. Here are a couple of my attempts so far =LOOKUP(C3,'Friday 930am:Monday 1130am'!C2:C25) =SUMPRODUCT(C2*'Friday 930am:Monday 1130am'!C... 1 Apr 2010 16:54

Formula showing in cell -- Never mind
I had copied cells from another workbook. When I inserted a column it must have brought in something that made the formula text. When I copied and did an paste special into the column, the formulas started entering correctly. Carolyn "Carolyn" wrote: When I type a formula in a cell after hitting enter,... 1 Apr 2010 15:47