Im using Excell for my Fantasy Football Draft, Id like to have one spreadsheet with my players in order by Rank and the other by Name, however id like to link...

How do you add hours on a time sheet? I'm trying to come up with a spreadsheet where my employees can type in their time in's and time out's throughout the...

I find data has moved about 10 cells below where it should be. How do I prevent this?

I am using the WORKDAY function and occasionally the value it returns is #NAME?. When it does this I can go to Add-Ins, uncheck the Analysis Tool Pak check...

A while back someone was very helpful in solving a macro problem. I need a little more assistance. The macro compared "Column A" in two worksheets (Master...

What is the corecct / simple formular to calculate the average speed? In one colum I enter the distance (miles) traveled. The other colum I enter the time. ...

I have the need to set the color of a cell, based on whether the value equals one of a series of values on another worksheet. The situation is, we do tire...

Is there any way to change a set of cells all at one time? The entire equation? I'm copying cells from one area in the worksheet to another, and I don't want...

A friend has a worksheet that some cells are shaded, others aren't. The shaded cells values are to be summed. Right now, he's writing a different formula for...

I have a series of data that gets pulled into a worksheet(it's pulled into a "data" sheet first from a text file, then creates a "report" from the data in the...

I'm sure this isn't hard. Brain won't cooperate today. Going home. Had enough. Column A is text (Location code) Column B is numeric (part number) Column C...

Variables from which to choose: Month, Store#, Type (Fruit or Veg), Color Table looks like this: Fruit ...

I'm trying to use Excel to make a converter between GMT and EST/EST DST.

I have 2 workbooks. One consist of a report cover page created with textboxes, shading, etc. The second workbook has all of my data. I would like to merge...

I have 2 workbooks. One consist of a report cover page created with textboxes, shading, etc. The second workbook has all of my data. I would like to merge...

Would anyone have a Macro the help me get the results below? Workbook name: enlformat2 Worksheet name: enldata sheet2 ...

i imported a address list into excel. i want to set it up as a data base. the list had no headers and consists of 2500 names & addresses. if i can select every...

I am trying to return a number if it matches with the IF function to a certain number in " ". However I can only get seven possibilities and I need 30. I...

I am attempting to read a workbook's properties such as Date1904. Using brute force I discovered the flag in byte 765 of some .XLS files, but I presume that...

Column A contains various differnet values, each refering to the quantity of a particular type of product in my database. Column B contains the sum price for...