I have names already in a colume. I want to put names in alphabetical order in that colume

Below is my origianl question with a response I received. My problem with that answer is I need the action to be automatic. Multiple people use the...

When I create a small one page speadsheet in Excel 2007, and print it, it prints fine - all on one page. However, if I save this document as a PDF file, the...

In 2003 Excel, I could hide columns in a worksheet, save the worksheet as a .csv and the hidden columns/data did not convert to the .csv file (which is what...

Hi, If I'm in the week of May 4 and I'm trying to add 13 or 26 or 52 weeks, how can I create a spreadsheet or formula to do this for me. Can the date be a...

I need help creating a formula that calculates the number of minutes and hours (and days if easier to formulate) between cells that exceed 24 hours. Here is...

The date in the cell keeps adding the year when I don't want it to, even if I select "Category - Date" and "Type - 3/14". I need to have ONLY the month and...

Not sure if this is an Excel or Access question, but here goes: Previously, when I performed a copy and paste from an Access query result to an Excel...

Hi all - Hoping someone can help he Columns A and B contain either a Y or N value; C contains a dollar amount I want to write the Value of C into either of...

Need help with the following: Column N contains numeric values (page counts) - I need to add the sum of N under 2 conditions. N will always contain a...

I have several worksheets that I need to link to multiple workbooks. Each worksheet in each workbook has a different name. When I copy multiple cells from...

What would be the appropriate code for finding whether the active cell is locked and protected? Run-time error '438': Object doesn't support this property or...

I can not solve the following problem, Let say we have a monthly discharge data of 20 years written in Col A1 to A240. Now I want to have the yearly data as...

i am wanting to create a lookup that will return a value from another sheet based on the headers from both columns and rows...to return the value at the...

I have a large worksheet for employee data. Each employee ID (column A) has 1 row for every date (column E) of the month, activity performed on that date...

In Excel 2003, I have a list in a column. I'd like a function/formula that returns the last value in the column. For example, if the list looks like: ...

Hello, If I enter an ID# in cell I2 I need the data from cells A1 to H32 from that individual's worksheet to auto-populate in the same place on the current...

Is it possible to change the creation/modified dates in Excel? Example... Can someone change their computer date and create an excel file so that it would...

i emiled a xlr file to my office computor but it wont open here at work i need to change it to a xls file to open it. i am at work now so i need to make the...

I have a spread sheet that has costs in Euros, Canadian and US $. I have over 10000 items to convert to US$, what formula should I use in COLUMN C to convert...