I have an excel doc/table A3-M3 downwards.
in N3 etc, I would like a button that, when pressed, will open a word.doc
template and export data in A3 into a particulr section in that document.
It will also take info from B3 to another part, B4 to another etc etc.

Good afternoon --
I'd like to know if a cell can be designated to pick up the formatting from
the cell from which it's receiving it's data.
I'm designing a workbook to be used by a wide variety of people, and have

How do you evaluate a cell that has two decimals places so that whole numbers
(no decimal places) is "True" and anything with values other that zeros to
the right of the dot evalute to "False"?

i have a a spreadsheet showing refresh dates for training. How do I enable
it to change colour at date minus 30 and date minus 60 days to highlight
training needs?
Peter

I want to write a formula that gives a result in a cell if the value in the
target cell has a range of values. (i.e.) something like
IF (value in cell A3 has a value of >80 but <85, put a figure (e.g.) 3 in
the result cell or otherwise a zero.

Pivots allow you to add criteria at the page level, but when you drop it down
you can only select one thing. How can I make it so I can select multiple
variables?
Otherwise, how can I add a filter to the pivot that I can select and

Hello,  I've got an Excel spreadsheet with a single column.  The cells
contain a date & time (m/d/yyyy h:mm:ss).  I'd like to compare the value in
cell A2 to A1, then A3 to A2, A4 to A3, etc.  to determine if it's a
"duplicate" or "different".  

I need to add a column of process times.  When I do the answer only shows
residual hours after muliples of 24.  Is there a way of showing total hours
over 24?

Is there a way of automatically being able to remove leading spaces?  A
number of people work on a spreadsheet and some remove the space themselves,
but others don't.
Ideally I would like it to automatically change perhaps by using a macro.

Hi Experts:
What I would like to do is copy the data from Worksheet1 titled "JanObs" and
paste it to Worksheet2 titled "HOA Forms" IF Column D on "JanObs" = Y
How can I do this either with formula or Macro?

Hi, experts
I need to sum a column with values if two conditions are met in two
other columns. Let me explain the case with an example:
I have a list of projects (each project belongs to a business area and

Would welcome assistance to determine which function I use to check whether a
range of cells have any content or not, then return a text string from
another cell, if not?

I would like a formula to find the value of a cell 1 row before certain
conditions are met.
Beginning with data in row 34 down I want to know the value of the cell in
column J 1 row before the row when these conditions are met for the 1st time:

I have a simple calculation to make but must enter the formula multiple
times.  Is there an easy way to do this?
I am collecting time points from multiple experiments, a t = 0 point and at
fixed intervals thereafter.  The number of timepoints varies between

I am trying to make a spreadsheet that no matter what worksheet is created
anything in a cell will update a dedicated worksheet.
For Instance:
worksheet 1