I am trying to Copy-Paste Special Value from one Workbook in to another, but
its coming up with the following Error "This operation requires the merged
cells to be identically sized"
I'm assuming that it is because I have headings centred across columns. How

My questions relate to the "Why", "Where" and "What" type
of macro code should be stored in (I believe 3 places)
that Excel has.
1. in the worksheet.

I have 2 worksheets, on worksheet 2 I created figures by using formulas
using refrences to the other worksheet (worksheet1).  I now need to use the
new figures on worksheet 2 to create a new worksheet using different
formulas to create yet a different set of figures.

The escenario is as follows; I have a list of over 400 individuals on excel
file. I need to create separate folder for each individual. the question is,
is there any way this can be done simultaneously instead of create each one
at a time?

need to set up a form that I can record personal information regarding
funeral arrangements and biographical information.

Hi thanks a lot. The pivot table is great. I got another proble
though.
What do I do if I want to summarise my data like so:
I have

I'm sure this has been asked a hundred times before but I've googled till
I'm blue so here goes.
I run the mini leagues for my local squash club, there are 5 players per
league and generally 10 to 12 mini leagues per season.

Using both Excel97 and Excel XP:
Could someone please explain how I can set up several independent sets of
option buttons on a worksheet, reliably.  I'm about to throw something!  And
the Help facility is absolutely no help with my problem.

Thanks Frank,
Now, to find out what a pivot table is.   :)
Fran
--

I have a group of employees that work in shifts (24 Hours).  Over th
course of four days we had a "special event" occur.  How can I create
formula that spans a four day period & any employee that worked hour
during that four day period would be totaled separately?

I have a large Db with 38 different numbers.  I would like to count th
number of each value (number)
--
FPA186

Hey all,
Does anyone know how to create the following custom number format?
56d, 5h, 4m
I have the number 56.2117988... calculated in a cell which translates to 56

Hi.
I'm fairly new to access. I've design a database that we'll use for
automating our invoice process. We have numerous customers and each has it's
own prices for our products. I created tables with relationships to hold this

I need help with the COUNTIF function. What I'm trying to do is count
range of cells if they are equal to the value of a specific cell
Example: COUNTIF (A1:A20,?=>B1?), but it does not look at what?s in B
it only counts it if the cell value is B1. Does anyone know how t

I'm new to excel and have a problem that I need solved. Can someon
help? This is what I was givin.
(L1*L2-L3/L4+7L5^2)
L1=5, L2=2, L3=6, L4=3, L5=3