I have a list of people (350 people) with specific dates as to when their
training is expiring, I want to summarize the data so I know how many seats I
need to book for training next year

When a PivotTable field list (drop-down item is not checked in column data
for “slicing” and “dicing,” the item fails to return to the column drop-down
list.  The item must again be added to the PivotTable data field.  This
happens when the data and column headings are the same.  ...

I have data in ONE column in every row and would like to have TWO
columns with the same data, but in first column all of the odd rows of
the FIRST column and in the second column all of the even rows of the
FIRST column.

I have this macro:
Dim SCell As Integer
Do Until ActiveCell.Value = 1
   Range("J24").Select

I have this macro's code:
Dim SCell As Integer
  Do Until SCell.Value = 1
  If SCell.Value <> 1 Then

I have different sheet names in column A.  I would like to use the
sheet value in A to show a value in a specific cell in that sheet.
For example:
A12 has 'Test 1 & 2'  (no 's) and I would like cells b12 and c12 to be

How can I make ActiveCell below refer to SCell?
Dim SCell As Integer
Do Until ActiveCell.Value = 1
   Range("J24").Select

I have a 50 page workbook.  I would like to create a macro  to copy each
Worksheet name into each of their perspective A1 cells.
A1 in worksheet1 would display Worksheet1
A1 in worksheet2 would display Worksheet2

Hi, have a workbook with 2 spreadsheets, first one is the master list (with
unique references), second one is an extract (containing duplicated data).  
Can anyone help me with a way of looking at the unique references on sheet 2,
finding the duplicate reference on sheet 1 and ...

i have 3 work sheets with these data fields: RO, ROC, CO
RO is customers order where the new orders for the model will be placed.
the data field is "model","po number", "ord qty", "del date"
ROC is when customer request to make changes to the RO they already made

I have a column with mobile telephone numbers. e.g. 0846578902. (The cell is
format to text not number)
Now I need to add a 27 in front of each to become 27846578902
I'm sure this can be done with a macro but am not too familiar with vb.

How do I set up and print a worksheet without having the row and column
numbers printed on my document.

I am doing a report from a system that works in a percentage of an hour, for
example 0.50 is equal to 30mins, 1.32 is equal to 118mins. is there a formula
in excel that can work this out?

I have the following problem:
In the range C1:C20 i have some data. I the range A1:A20 i have this
"formula": In A10: =C10, in A11: =C11, and so on.
The problem is: I want to have the ability to cut for example the range

I have a very simple table that I would love to insert a number that will
multiply the current number then average the whole table.  I am sure it is
simple, just a bit beyond me.  The table has Col B with letters  Col C are
the numbers that correspond Col D I would like to put in ...