I want to enter the value of a cell to a cell on another worksheet

I have a list of around 2000 numbers ranging from 3 to six digits. I need to
convert all numbers to six digits with leading zeros is 345 becomes 000345
and 12345 becomes 012345.
I also need to convert all of those to a set naming convention with a set

I have done for the last 2 years counted forward when my repete priscription
is due (medication)
I have a spead sheet and my calander. I have been manualy inputting the
dates to remind me.

I am stumped.  I have tried all of the usual fixes, including ones I found
here:
http://www.mvps.org/dmcritchie/excel/formula.htm#problems
I have formulas that, no matter what I try, will not update after I make a

I need a templet for creating a work break down structure for  a project.
Where could I fnd a good templet.

In Excel I need a formula to set up a puzzle as follows:
Grid of 81 cells set up 9 rows and 9 columns.
each row and column can only have numbers 1 thru 9 each row & column.
Each row and column has to have 1,2,3,4,5,6,7,8,9 in any order as long as

IF I USED DATA VALIDATION TO CREATE A LIST.  CAN I LINK TWO LISTS TOGETHER.  
ie:  LIST 1 IS ONLY COLORS, AND LIST 2 IS FRUIT.  CAN I MAKE THE LISTS LINK
SO AN ERROR POPS UP IF I TRY TO SAY I HAVE A PURPLE, APPLE?  WHEREAS THE
PROGRAM KNOWS, BECAUSE MY LISTS ARE LINKED THE ONLY ...

I am setting up a List and have some numbers to add up. I know how to do this
but my question is if there is a way to repeat
Example
=SUM(A2:A10) ((Results are in Cell (A11)

I have to show how many tickets are disbursed to different people.
Let's say Bob gets tickets 100 to 105. The SUM formula subtracting 100
from 105 is 5 when actually Bob gets 6 tickets. Do i have to add a
hidden column with a value of 1 to insert into the formula? Thanks

I have a data table whose columns are arranged in the following manner, from
left to right:
Date | ArriveTime | LeaveTime |Hours | Overtime | Regular | Gross |
RunningGross | CumHours | $/Week

Hi folks I have a major problem. I have done this manually in the past but it
has just taken so long and is so tedious that I am sure there is a quicker
way using VLOOKUP or some other function however I have been having no succes
so was hoping some kind hearted individual out ...

As above mentioned, and also how to create the selection from the down list
with arrow.
Thanks.
Regards,

When creating nested formulas, it is not easy to identify paired parentheses
(i.e., you have to count the number of parentheses on each side to see if you
have an error in the placement of the parentheses, which can change the
formula's result).  I believe that, by adding a ...

I'm sorry this may seem so simple, I've been searching and just can't find
the answer.
I'm trying to do a simple IF function in cell B2 that looks at a cell (B1 -
a date) on the activesheet and looks at a named range on another sheet (Sheet

I normally invoke menu and select options through shotcut keys (like
alt+F+O to open a file)
Recently when using excel I found that If I press Alt+O+C+A For, column
width autofit, It's not working. It's ONLY NOT working for Format Menu