Hi, In an older version of Excel I used to be able to click on a cell that DIDN'T have any precedents or dependents, and select the TRACE button, and simply...

I have a worksheet with data/formulae etc etc. I would like to delay the execution of formula for certain column by few weeks and after the completion of the...

I have a spreadsheet to log a persons manhours performed for the month. 31 columns with a totals column to follow the last day of the month. We are a military...

I have an Excel 2000 file into which I've been pumping exported query results (as new worksheets) from a SQL Server database. There are also a few pivot tables...

(Gerrit-Jan Linker) wrote ... You may want to try an addin that allows full database access from Excel. Where were you three...

Hey all, Hopefully this is a simple one. I'm SUMing a column: =SUM(L8 + L12 + L16) At times, some of these cells might be empty. Can I mod this equation...

I am having problem with a HLOOKUP. I have few columns assinged for certain items. Those items are catergorized into 3 catergories. Each catergory is merged...

I have created a rather simple spreadsheet that data is entered into the first 3 columns, the fourth contains a formula/function. I have pasted this formula...

What's the correct syntax for a VB code line that returns the current column (or row)? For example If Worksheets("currentsheet").column=1 then ' is the...

Hi all, when I insert a Hyperlink to a file , e.g H:\MyFile.doc It inserts the link as the full unc to the file,...

Is there any way to "tone down" the code that Excel 2002 creates when saving a worksheet as a web page? We converted to Excel 2002 this past year at work and...

I am trying to figure out a way of linking cells in the first column of a workbook to individual worksheets in the same workbook (Excel 2003). Basically the...

Greetings All, I am trying to find out what is the VBA code that identifies what button has been clicked? In short, is there a way to identify the button's...

I want to create an IF statement that does something like this: (Formula in cell B1) - IF A1 contains "red" then return "red", else if A1 contains "blue",...

This is probably simple but I can't figure it out. I am trying to create employee evalutaion workbook that will take employee names, social security numbers...

I want to write a formula so that if a number entered is negative it goes in 1 column and if it is positive it goes in a different column. Is there any way of...

I have a list of names and birthdates in the format: Diane 5-2-00 Joey 2-9-01 Nancy 12-16-99 I would like to add a third column that...

I've created an ActiveX Button. How do I make clicking on this button execute a macro? --- Message posted from http://www.ExcelForum.com/

I have the unfortunate task of converting a SQL Server database into a stand-alone Excel file that will store all the data, as well as act as a "front-end' for...

Hi all I would like to count data relating to different columns but also if this data matches certain cells. A1 to A10 = Areas B1 to B10 = names D1 =...