I am looking for a "counting" formula that will count cells in a range based on their color, so that if I color a series of dates (to show 'vacation) the...

Is it possible to copy a value in a cell and add it as a comment? How would such a macro look like? Preferably the comment box should be resized to just reveal...

Hi, I need to have a macro such that it'll select all sheets from the first to the sheet before a sheet called "test". After selecting these sheets, i want to...

/ Hi, If I have worksheet where I want to delete all the rows that have (say) 0 in column C is there an automatic / formula way to do it. I've tried filter and...

Every Time i want to Enter some Text in to Excel it is automatically formatted as Scientific Text .. IE: I enter in 5E1 amd Excel Automatically formats the...

I am trying to write a vba code that accomplished the following excel code, can anyone help =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)) I have wrriten the...

Is there a way to change zip codes in a spreadsheet to only display 5 digits?

i have a .xsl file that include 3 chart in one worksheet. now, i need to sort these 3 chart's data display order from high to low , but it seems hard to...

Afternoon Workbook with 100 or so individual sheets Used the BuildTOC macro from Dmcritchie website that worked great What I want to try and do is to then...

Hello, I want to export data from Excel, perform some calculations on it, and then link the data to an Excel chart. Although the exported data has a named...

I am managing in excel a flat database of over 1000 names, committees, etc., where email addresses are found using vlookup function. How do I convert these...

Hi, I have a column of start dates (B) and a column of end dates (C). I would like to have the inclusive total of days. I would then like to have a running...

I'm trying to save an excel file in .csv format with Excel 2003. After I get out of the file and get back in the format of the cells has changed. For...

I am currently using this code ti click "x" in to a column of cells. Is there a way I can select only certain cells in a column, like b2:b8, or individual...

i am looking to add a clocking system into my spreadsheet so colleagues can clock in and out and the time they worked is recorded, how can i do this??

Excel 2000 ... looking for Font List that will reflect corresponding Wingding symbols vs alphanumeric cell entry ... Thanks ... Kha

I am trying to split a column with negative and positive numbers. I can use the custom autofilter and get all the positive numbers that I need to move to the...

I am trying to find an easy way to determine the lowest 5 values in a list of 10 and add those values together. There are 150 lists involved in which the...

I would like to save a file with multiple sheets while retaining the current values and format, but not the links so I can minimize file storage space and load...

Hi I have an Excel spreadsheet that ultimately I need to save as a plain text file but with specific column widths in the text file. (I have tried changing the...