I am using excel as a frontend reporting tool to display some performance
data that is held in a sql database.  This spreadsheet and the database
behind it will be altered over time as we incorporate new data into it.  I
will be doing these changes on our test environment first ...

I wish to run a random sample of 60 numbers from a population of 75 numbers
without repeating any number more than once. The  data analysis - sampling
tool generates the 60 random numbers but duplicates several numbers.

I used Macro function in Excel WorkSheet.But now the Stop Recording/Relative
Reference Button ToolBar for Macro does not appear any more?Can someone help
me restore this option again?
Regards

;) I'm keeping track of daily sales at a small store. I would like to
open one spreadsheet, enter all the sales for the day, and have a
running 'year to date' sales total at the end, so it needs to take the
YTD total from yesterdays sheet and add it to todays total.  I save

I want to data validate two lists where the value choices are the same
Each list takes its data validation choices from a defined range
However, when a user selects a value from the first list, th
corresponding value on the 2nd list will not have the value the use

I have a table with 3 columns and several hundred rows. In column A entered
years (1920, 1910, 1930, etc). In column B entered age of a person
(32,76,43, etc). In column C I'd like to enter the year of birth of these
persons which, of course, is the result of subtracting the age ...

I'm sure this is very easy to do, but I'm having a lot of troubl
figuring out how to do it
How do I search a column for the value in a particular cell, and the
insert the value into the current cell if found

I am hoping that someone in this vast pool of Excel knowledge might be able
to help me with this problem.
This list shown below in blue....
10/04/06  10/05/06     108     757      ANC-NRT     1600   2325    ..WR...

I want to have the columns do the following
A1      b1
A2      b2
A3      b3

When I use the arrow tool (or any other AutoShape) to draw, it alway
defaults the "line color" to the "no line" setting.  If I have th
object selected, I can then change it to black (or default) but th
setting does not stick when I draw another arrow.  

I have two columns, Date and Location.  In location, there are
different possibilities, lets say Alpha, Bravo, Charlie, Delta. Here i
a small example of my data.
_Date--------------Location_

   I want to prevent some other one can view some of worksheets in my
workbook. Although Excel can hide the worksheet, it can be unhide again
without protection. Does anyone know how to do so?
Best Rdgs

I have created a row with 2 categories and 2 numerical selection lists
The numerical selection list represents a % allocation and goes fro
0-100 in increments of 5 and the goal is to apply a percent of tim
spent on activities in each category.  The sum of the two %allocatio

I have set up a time sheet for employees to fill out on the computer. I need
one column (STRAIGHT TIME) to total up to 8 hours ONLY, and anything beyond
that to go in the OVERTIME column. So in other words, if I work 10 hours in a
day, I need Excel to automatically record 8 hours ...

I am getting annoyed by not being able to have multiple instances of
Excel (being able to view two Excel workbooks at the same time. I have
dual monitors and right now I'm stuck on one screen with this other
beautiful screen going to waste. Anyone know of a way to allow me to