I have an Excel spreadsheet with pictures inserted in one of the columns. When I sorted the spread sheet, about half of the pictures did not move with their...

Good day; First of all, I would like to thank you. You helped so many times. Example;;; Sheet-1, Cell A1 = Milk Sheet-2, Cell B1 = Can I copy the Cell ,?

Hi, I managed to use the McGimpsey Macro to enter a date stamp into my spreadsheet based on something being typed into an adjacent cell. I want to then use...

I have a table of product codes with 20 different prices for each product code that sit on sheet 2 of the workbook. Price Range prod code 1 ...

What is the formula to display the number of months between 2 dates? Thanks, Melissa

Does anyone know if there is a setting in Excel 2003 where we set number of rows a formula should pick up? I have a sumif formula to calculate range from...

I am trying to add up values in cells that correspond to text in other cells. So, let's say I have 100 rows of various text and columns next to each of...

Sub Macro1() MenuBars(xlWorksheet).Menus.Add Caption:="&Name1", befo="&Help" With MenuBars(xlWorksheet).Menus("&Extras").MenuItems .Add...

Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC

I am trying to determine how to do the following: I need to assign players to teams in a flag football league. The number of teams will depend on the number...

I am working on a table and I am suppose to sort different records within each other. Ex. Sort the record in the table by age within gender. How do I do...

I have a spreadsheet that I have used for 5 years...with daily data being inputted (in newly inserted rows), then Grand Totaled at the bottom of the...

Example: H6=01/14/2010 16:45 A6=12/31/2009 12:15 I want to get the difference between January 14th 2010 at 16:45 and December 31, 2009 at 12:15. Ideally,...

Can a formula be used in a criteria area when extracting data from a table in Excel 2007?

Dear All, Please i need the formula for colum D Status, it can display Pickcal or In or Out or Picked. Colum A Colum B Colum C ...

I want to put a line that connects two bars in Excel, and put different values on top of it, like correlations or significances between the two bars. ...

Is there a way to change the location of the sheets tabs? Instead of having them at the bottom of the worksheet, I would need to have them vertically, next...

When I open a workbook it comes up as shared and it causes delays when saving. i'm the only person on my system so don't need "shared". How do I remove the...

I use Excel in Spanish but I need to insert days of the week in english. That is why I created two custom lists, one goes from Monday to Friday and the other...