I have daily excel files for 4 years worth of data that I need to
consolidate into 1 workbook.  Each workbook contains 5 days worth of data so
I only have to open every 5th file.  The data is in the same range in each
files (F16:J37) with dates across the top so I need to copy ...

I have one shaded box and and I want another shaded box to always be the same
color as the first. Is there a way to link the two so when i chence the color
on the main one, the second one will also change, without programming. Didn't
know if there was a way to put a formula in ...

I have a field which does calculation on the IF condition, does fine till
have a negative conditon
e.g. =IF(H3<=-4000,"CAMERA",IF(H3<=-8000,"PRINTER"))
now the statement comes in field 'I' e.g. CAMERA etc.

I didn't have enough room to make a clear title, but I hope it's ok. I don't
know much about what I'm about to ask about, but I think it might have
something to do with fields. Sometimes when I download a template to Word,
there are generic words like [Your Name] in gray, which, ...

In sheet "Stat1", each cell in column C contains a whole number from 1-50.
In sheet "Stat2", column A contains a letter and columns C & E are used to
create a numeric range. Each letter in Col A is a coder representing the
range specified in cols C & E.

I am using Word 2002sp3 on XPpro. I have several templates which have a
special print macro (the same one is in each template). The template has a
number of mail merge fill-in fields over 2 pages of the WORD document. The
macro allows page  1 to be printed twice and page 2 to be ...

I have an excel file that gives me a warning pop up when I click on a
hyperlink that links to an executable program, but not for hyperlinks that
link to other workbooks. The pop up says:
"Some files contain viruses or otherwise be harmful to your computer.

I am trying to crunch my data for my thesis and I'm at a complete loss as to
what to do. If anyone can help me figure out how to input my data I would be
very happy. I have one independent variable (type of teacher) with two levels
(general education and special education). I ...

Here is a basic description of what I  want to do
I have a file "SOURCEFILE" with 30 sheets , sheets names are different
numbers, e.g. 101, 102..112, 202....
all sheets have same structure

I have a spreadsheet with values in a couple of cells in Column E. The rest
of the cells are blank. I would like a macro that would move the value of any
cell containing data (non empty cells) four cells backwards and two cells
downwards to Column A. Is there a macro that would do ...

I have two Excel workbooks that I use on a regular basis.  One is an
inventory collection of my stuff, like music CDs, video games, books,
DVDs, computer software, etc..  Another one is music information, such
as songs with lyrics, etc..

I need to compare the values in a cell in one workbook to the same cell
in another workbook and store them in the same cell in a new workbook.
I wrote the code already to open each workbook, add a new workbook, and
format my heading information on the sheets.  However, I am ...

One of our users has a strange problem in Excel. It seems that when he opens
the program, and highlights a cell, the curser remains 'pressed down', so
when he moves the mouse, the curser selection just highlights more cells,
and he can't 'unclick' or stop the selection, it's as ...

Hi All;
I have a column (say A) in which there are some alpha-numeric chracacters
like below:
300-YT-102

i have a worksheet where the datas to be entered only by the
administrator..and the user shouldnot have to enter any value in the cell..
Also i dont want to show the formulas to be showed to the user..any help on
the subject pls..