I am at the address W7 in Bok1 in Sheet3.
I need to copy the contents of Cell B3 in Sheet2 in Book2 where Book1 and
Book2 are in the same folder.
What formula is needed to be typed in cell W7?

I have a printer A set up as default for my PC. I want to have a printer B to
be default one for ALL NEW Excel  files. So task is not to change it manually
or via some macro button; the task is to have the printer B ready directly
after opening of Excel file. Any suggestions?

Trying to formulate a cell to Show  the greater of two cells that are
calculating other formulas...Thanks for any help?
Example  B5= B10 or C8 whichever is the greater amount??

I'm dealing with an Excel issue that's driving me crazy and I was
hoping someone could help me out with.
I'm working on a spreadsheet to track projects and I would like to
create a macro that would track and show the number of a days a

I am having problems working out how to automatically place text from one
cell into a cell in another sheet.
I have read the post on 10 April 07 "Repeat text in exact cells in
multi-worksheets" and tried the solution:

Hi, I need to create a chart using Excel 2003 and or PowerPoint 2003. The
nonnumeric data is
stored in a multiple column spreadsheet.  In one of the columns (A) the
cells are populated with letters (BT or PP or RD) I need a dynamic total of

Or do they only "float" on the page.
Marc

Given a time period A formatted as hh:mm, how do you divide a 24 hr period
(formatted as hh:mm) by A? Would appreciate answers. I am getting dubious
answers!
Don-

I'm new to Excel and am having trouble writing a formula that uses a
column which might contain any of the 3 following types of data:  1.
a date,   2.  nothing at all   or 3.  appear to be be blank, but
actually shows a small carat in the formula window.     It's situation

I have an Excel 2003 spreadhseet in which I want the defaul font size
to be 12 points. The Help text says:
Tools > Options > General > Standard Font Size 12
I did that, got a message to quit and reopen the file for the change

For no reason I can fathom, when I am in a worksheet this happens.
When I move the pointer so I am creating what looks like a text box
which looks as if I am selecting an area. But whatever I do I cannot
detach the pointer from this box. Also when I move the pointer I am

Here's what they want:  About 35 people need to enter info into a
spreadsheet.  Each user needs to see only their own information.
Admin, though, wants to be able to see everyone's info.
Some possible solutions:

I have a workbook with 3 worksheets (Sheet1, Sheet2, Sheet3) and 2
pivotcharts (Chart1, Chart2). I want to write a sub that when it is called
it cycles through all of the worksheets and charts (all of the workbook
objects) and toogle sheet visibility. I want to have only one of the

I have a solution (.xlsm) I wrote in Excel 2007 and I want to hide the
ribbon as well as anything that will resemble Excel. When I run the file (as
well as the code) I want it to appear that this is more like a Win32
application. Any pointers to some documents to read ?

I need to create an 8 letter Account Name from company names, and I need to
remove any spaces in the company name, such that Smith And Wesson Ltd gives
SMITHAND.
Any suggestions?