I'm using Excel 2007. Is it possible to sort a column by the number of characters on the line? I track part numbers - which vary in length and can include...

How do you change the rows to columns and the columns to rows in a spread sheet when copying, using excel 2007. I believe with excel 2003 you could do it...

I have a workbook with a large amount of VBA that works just fine in Excel 2003. However, when I open the file in Excel 2007 and try to "Save" or "Save as"...

How I can copy a pivot table to another worksheet without missing its format. But in the new worksheet should behave as normal sheet can possible to insert a...

Hi I have a data validation list which I use in the spreadsheet for the user to select from the drop down. I would like the user to be able to user a data...

I need to populate a column in Excel from SQL Server based on data in an existing Excel column. For example if I have a spreadsheet with employee ID’s in a...

I have created a template and I want to be able to fill in parts of the template by just tabbing and the cursor to move to the next cell...and to a specific...

Is this possible (Excel 2002) We have a workbook in a shared folder which many need to have access to update the info in it. Problem is there are now 3...

I am trying to develop a spreadsheet that I can list 2 columns of information under each month column...Is this possible in Excel?

basically i want the macro to enter values 1 to 5 for range g2:g6 then move onto row h2:h6 and start with 2 and place i and the bottom so it should look...

Forgive me for this off-topic request. But since it impairs my ability to help people with Excel questions, it might not be entirely inappropriate. I have...

I have an excell spreadsheet that is used as an schedule. it was built using office 2003 and I could send it to the plotter using some modified changes. We...

I am using Windows XP and Excel 2002. I have written a small code in THIS WORKBOOK. I want to know if there is a way to protect anyone else from going into VB...

Hi, I need to prevent data from being entered into a cell if there is already data in any cell left or right of it in the same row. Thanks Gotroots

I have the following in cells after using a formula. #INVALID_DATA. The reason is there is no data in the cell. If i use the Find and Replace to remove the...

I would like to average the 1st 7 numbers in an array (E2:E63), in the next colum I need to average the 1st 30 numbers of E2:E63). I have tried using...

I have a list of names in colum B, that I would like to split into column C and D. The names in column B have a first name, middle intial and a last name. I...

Hi, Is there any way that I can use Pivot Table or any other similar function so that I can get text not numbers in the ∑ Values field? Sure my intention...

I have a chart that shows shipped quantities vs month/year date, with the date on the x-axis. My manager, who is expert at finding trivial things for me...

Hi guys, would appriciate your help with the following. I have an Excel sheet where I copy information from Powerpoint presentations. When there is a bullet...