I am trying to copy contents of cells from one worksheet to another but i
would like blank cells to remain blank. Presently i am using the formula =a1
for instance and if there is nothing in that cell it puts a 0 there. what
formula should I use to end up with something in the ...

The formatting is lost when we refresh the report.
Please help me how can i retrieve the formatting the report after it gets
refreshed.
It very programtic to first store the formatting of each and every cell and

O.K. this code is working to put in a formula that sums a certain number of
rows every time the if statement is true, however I need to alter the code to
sum a variable number of rows, i.e. one cell down : end (xldown).  Is that
possible?

I have to following inventory data:
Pool    Part #    Final Discrepancies    Actions
FG11    286692-001    -1   
FG13    286692-001    1    Move 1 to FG11

I'm having trouble with F & R not finding.
I have a cell that says, for example "Thing 1", line break (Alt-enter), then
"Thing 2".  Thing 2 is blue, 1 is auto, but i don't think that matters here.
I'd ideally like to, for all cells, be able to say "delete all the black

How do I configure Excel And Word 2007 so that when they open they do so NOt
to maximised but to the size I like to work with on my screen?

I have column A populated with numbers which all end in a letter for example
123A, 1258M, 999Z.  In the B i woul like to the numbers excluding the letter,
ie 123, 1258, 999.
How do I do this?

I have 3 columns with misc data. Column A is a date, column B is an
invoice number and C is an expense report number. If all 3 columns
have data entered, I would like to have a formula return the number
"1" if not, "0"

During the day I have very limited acces to the internet.  I use word and
Excel all the time and often the questions I ask have to go online to get the
answers.  Can the available Help subjects be downloaded completely to use
from Microsoft?

Normally I can undo all event. This problem occur after I select copy and
past or past special value. The undo bottom is disabled. How can I fix this
problem?

Appreicate if someone can advise me what should I do to remove & restore
back to xls entension of keep having this xlk entension (Back up) everytime
when I start saving on my work file
Regards

 I have a very strange problem to disguss with you.
I have opened a file excel on my pc.
I copied same cells of this file and i have pasted this cells in onother
file excel.

If I have a list of Names in an Excel Worksheet. I want only a Particular
Text from a cell .for Example:
Name List
-------------

I would appreciate if someone could please help with the following problem.  
I would like to be able to enter data to a specific cell (say A10) then
automatically get the cursor to jump to the top of the next column, (say B1)
then be able to enter data to the specific cell in ...

I'm using 2007 and have the ADD-IN to save to pdf directly.
My excel document has several sheets
In my excel I've used hyperlink between sheet 1 and 2.
When I use the save to pdf the hyperlink is shown in the pdf document blue