Have a column of 318 members in a club. Want to increment the entire column by one for each additional year they are active. How do I do this with the...

I want to create a summary worksheet which will total, say, worksheets between a sheet called 'start' and a sheet called 'end' without typing the individual...

This is a Mircosoft Office 2007 Excel spread sheet. I need to figure out a formula that can round up or down to $xx.95 using the following situation cost:...

Excel 2003 I need to number rows on a large spreadsheet from 1 - 27, and repeat 1 - 27, etc to the end. I'd rather not copy and paste! TIA Carole O

Is there a way to set in the template so that all dates entered show as 2/6/10 not as 02/06/2010? Thanks in advance.

I use data validation allot to restrict user access. Recently, in a financial workbook I developed, I used data validation drop-down lists in several columns...

I have a file that was saved as a csv extention and want to put the information from the comma delimited pieces into their own cells. How do I convert from...

Hi all Guru, I have created a button which emails the addresses as shown below, what i would prefer if i could have it so that it emails what ever email...

i size it the whenever i reopen the worksheet the size changes. i can size it using both with the handles and with the properties box

I have a worksheet containing a column of cells each containing a mobile phone number - the number in the cell is 7 digit , but needs to be 8 digit...

For Excel 2007 I would like to a repetitive pattern of rows delete rows from a very large worksheet with 2000 rows. As example, I would like to delete rows...

I am exporting my email addresses from an excel worksheet to Outlook 2003. Outlook gives me an error "name range of data to export". How do I name the range...

I succeeded in changing File Menu to the Excel Icon and have no idea how I did it or how to get it back. The result is that a left click on that icon will...

I have an Excel workbook pulled up with 3 different sheets. I need to link cells between one sheet to the next. How do I do that?

I need help understanding which formula I should use. . . I have built a table similar to the one below on a sheet of my workbook. On a separate sheet, I...

WT heck...do I have some kind of disease? As I'm using a button, I am watching it as it disappears away to nothing. In time, it will have collapsed into a...

Hi All, Let say I have data Coloum A1:A100 containes number data and I want to HIGHLIGHT using Conditional Formatting, those cells that have the following...

I have around 150000 PDF files to hyperlink in excel from a folder. I have put the file name in Column A. The file names of PDF file are same as in Column...

Hi All, I need to force user inputs when inserting data on a row. Example: I have 3000 rows of data that needs to be Entered by a user into the...

This Macro uses a Column "E" of unique numbers in Archive sheet for any changes in Current sheet and if it finds any overwites the data in the corresponding ...