how i can merge more than two excel files in one file.

Can anybody show me how to create a Calculated Item in a pivot table?  I
have a field called CLASS with the following values:  Stock, Sales,
Order and Target.  I would want a field that calculates Stock minus
Order.  As per HELP, we have to ungroup each item and enter the

My problem is that I have installed crystal ball on my comp. When for
example I am trying to do the simulation I want one of the cells to be
decreasing gradually by the values given to me by the crystal ball.
That is not the case, lets say:

I have a list of names (which will change) in column B "data work
sheet". I'd like to assign a letter from colmun A to represent the cell
that each name is entered (a=B1). I'd like to use that letter to
identify the name to be used in the introduction of a generic message

How do I go about linking a picture ?

I have trying to make up a timesheet to calculate times and wage due
1.    06:00 to 20:00 = amount of hrs worked, I would like 14.00 instead of
14:00 hrs
2.    To be able to calculate each day to total hourly week

I know I've found and save the answer to this question but I can't seem to
locate it.
I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some of

Please can someone please tell me how to locate where a corup link in a
spreadsheet might be.  When I open up my workbook it tells me that it
"contains one or more links that can not be updated."  I then choose
EDIT --> LINKS to check the status of the links but all the links show

I have a workbook containing 20 sheets. Each sheet is identical (used up
to 80 rows,  columns A to W) and is used to record peoples working hours
each day of the week in different  departments.
Could someone please tell me how to consolidate all the data on the 20

I have grouped cells by using data/group and outline/group and after
that I have protected the worksheet through tools/protection/protect.
Now when I am in protection mode I cannot open (or close) a group. Is
it possible to have a worksheet protected but allowing users to

I have more than a sheet in th workbook (15 sheets).
I need to use the sheet name in certain cells in the sheet itself.
i.e.     sheet name is "January" , I need to have it in cell B200.
Is there a way to do this automaticly instead of typing it in the cell?

I'm using this piece of code to populate an excel userform listbox with the
name of each worksheet in a workbook
i = 1
For Each ws In Worksheets

No i Koniecznie dodaj ta oferte gdzie sie da ja najwyzej dodam zdjecia

A procedure often Number Overflow.
So I put this handler in procedure.
Private Sub Hint()
On Error GoTo Overflow

--------------------------------------------------------------------------------
not sure if i got the right forum
I have a form created by VBA, and on the form I have a combo box wher
the user can specify the month and year. I need to retrieve data from