I want the information that is on the first 4 lines to be automatically inputted on pages 2-6. Like a header\footer but not.

I'm having a problem, and I don't know if there's a solution in the form of an Excel function. I believe I could write a VB Macro to accomplish what I need...

I'd like to save time selecting from a drop down list by typing the first few letters of textl and have the cell "auto fill."

I have 2290 characters in a cell and need to compare using Vlookup. It throws #value error. Is there any limitation on the number of characters it can...

Hi there, I have a complex function that sums or averages a series a values, based on month. Occasionally, when i open the workbook and specifically, the...

Hi I have a series of timed events (races to one hundreth of a second) that need to be tracked by event (worksheet) then all total times for teams averaged. ...

Hi, I use text formula and after saving the file using pastespecial to values I can see a single quote (') in the blank cells. This is giving a problem to...

Hi, I've formatted cell to - Number Date*14 March 2001 I type in todays date 11/9/08, but it returns 00 January 1900. If I type the formula =today()...

Hi I have a tracking spreadsheet that contains all the deals with the close date change.. there's a close date old value in column A and a close date new...

Hi all, simple question (I think)... I have a text cell made up of a vlookup and some other text. What I want to do is colour the 'non-looked up' text a...

Hi, I'm not exactly sure how to do this. I want to sum data in column c if it meets two conditions, both in column a. For example, I have budget data in...

Understanding what I need is easy; finding the correct formula perhaps not so much Say that my range, in C11:C100 , contains some cells that are not empty...

Need to find value in column P of multiple worksheets (i.e. may_acct1, may_acct2, may_acct3) based on phone number in column A of these worksheets matching...

I have 31 worksheets in a workbook. Each worksheet has col A the site and col B the person who went. On worksheet 32 I would like to count how many times...

Presently the active buttons are blue against a grey background and not very visible. How can I change the active blue to a brighter color?

Is it possible to reference a Cell in the Header or Footer. Maybe Code etc. What I am trying to do is use the same worksheet every month. The date is...

Hi there, I have a list of data in sheet 1. I have a second list of data in sheet 2, which contains all of sheet 1 plus some new entries. I want to compare...

I need help in creating a vlookup formula that will search a single column that automatically defines the range within the column to lookup. On one tab I have...

Example 6:15 am 8:26 am The answer that I am looking for is 2:18 worked. Can you give me a formula for this problem

Dear experts, In a worksheet, column A is for player's name and column B is for player's scores. I list some examples below: John 25 Peter 65 May ...