Hello I want to create a drag and drop down list but how can I create
one by getting the list of data from another worksheet in the same
file?  
Thanks

Hi, I'm using an excel spreadsheet and I have a list of customer
numbers in column A and a list of account numbers in column B.  Many
customers have more than 1 account number.  What I would like to do is
change the layout so that I have each customer number listed only once

Hello, I have a slight problem which shouldnt be too hard to solve:
I want to multiply a percentage by a number but first if for example i
have in A1 50 and then in B1 10%  i want C1 to display 10% increase of
50, but how do i do this without typing in 50 * 1.1.....? is there some

I need to calculate hours per thousand. Can someone give me the formul
to use?
thank
--

I have an excel worksheet that I use to prepare a weekly work schedule.
It contains popup menus that I use to select certain variables such as
dates, times and people. Once I have a weekly schedule set, I want to
distribute it electronically but without the popup menus being ...

Problem: Is there a way to reference to a value itself other than t
cell address?
Summary: I've got 2 sheets. In Sheet1 I use formula, let's say in cel
C1, =Sheet2!A1+Sheet2!B1 where in Sheet2 A1=5, B1=7. Of course  cell C

I have two columns in my spreadsheet:
*Name* and *amount due*:
I have 100 records of a *name of  a person* and a*mount due for each*.
I wanna be able to Extract Each data from the spreadsheet

Hi I need to identify which financial quarter a date may be in.  I found
a formula in one of my books but it displays a calender quarter not a
financial one.  My financial year starts April.  Any help would be much
appreciated.

Hey all...
Here's what I am trying to do:
A3 = 4:00am  B3 = A3 - 1   I keeping getting #value error in B3 instead
of the result I am hoping to get which is 3:00am.

Well as the topic implies, I'm trying to update some price sheets
created in Excel.
I have several cells with prices in them and I'm trying to increase all
of the cells by 5%.

New and young technical writer in a bit of a stew due to my
inexperience with MS Excel formulas. The following outlines what I am
attempting to do, likely very basic to you gurus out there so please
forgive my newness to this.

   There are two range of cells A1:A10 and B1:C10 in my workbook. I want
the content of A1:A10 to be updated automatically when some contents of
B1:C10 is modified. How should I write a macro for it?
  I understand that I can just let my workbook update every cell whenever

I'm trying to create a worksheet which records elapsed time between Date /
Time Received and Date / Time Delivered.  So far, so good.  Problem is, the
elapsed time I get really needs to use some form of Networkdays, excluding
Holidays, and (here's the really tricky part) non-work ...

What I need to be able to do is return a range of data based off of
calculation.  Here is an example of what I nee
Widget   36.27
Gadget   31.27

If I have 43,392 minutes that is 30 days, 3 hours & 12 minutes.  How do I
format 43392 to look like 30d 3h 12m or 20 d 3:12?