Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel users21 Apr 2008 15:43 GMT2
I have Excel and Word on a server for multiple users. On some computers some
users can access Excel and Word without problem while other users have to
"Load" Excel or Word before opening an existing workbook or document. These
same users have no problem on a different computer on ...
How do I get an inserted symbol to show in another worksheet?21 Apr 2008 14:04 GMT1
If I have a worksheet where there is a trend column that uses inserted
symbols (eg arrows) to show the trend, how do I get that symbol to show in
another worksheet that has a formula to return data from a specific cell (eg
the one with the symbol in it).
PC macros won't work on MAC21 Apr 2008 13:58 GMT2
I spent the last month working on a large workbook in Excel 2003 and it has
all sorts of macros in it.  It works great on PC versions of Excel.  However,
the macros are not working when MAC users open the workbook.   Also, the
formatting of the MAC file is a bit off.  Is there an ...
Copying Data from One Worksheet to Another21 Apr 2008 13:32 GMT2
I am wanting to put the data in a specific row to worksheet 2 or 3 drivin by
a formula.  If row one in the a column has a 2  I want the whole row of data
to copy to sheet 2 and if row one in the a column has a 3 I want the whole
row to copy to worksheet 3.
Explain how data is stored in excel in your own21 Apr 2008 13:10 GMT1
Explain how data is stored in excel in your own
Cell Referencing21 Apr 2008 13:09 GMT5
Is it possible to reference cells in Excel using numbers for both rows and
columns rather than the letter and number reference as is standard?
If so, is it possible to write a macro that selects range A1 to A+X:1+Y
where X & Y are variable integers in other cells?
Auto Fill...Is it Possible?21 Apr 2008 13:04 GMT5
In column A, I have, in alphabetical order, say, 1000 cities...in A1 through
A1000.
How is it possible to scroll directlt to "Manila", for example??
If I begin to type Manila in a cell,   say cell D1, can I 'scroll' directly
ComboBox ListFillRange21 Apr 2008 12:55 GMT14
Why a horizontal range, e.g like A1:G1 cannot be used in ComboBox
ListFillRange?
Is there a workaround for that?
Another question: can an OFFSET function or a named range be used in
Subtotal show more columns21 Apr 2008 12:34 GMT1
When you use subtotal the output is only 2 columns, what you subtotalled on
and your value or whatever you chose to calculate. How can I see other
columns information as well on the subtotal line? I do realize the lines can
be different but how would Excel handle this situation ...
Conditional format for future date21 Apr 2008 11:49 GMT2
I have entered todays date into a cell and I would like that cell to change
colour 2 months in the future. I know I have used =TODAY()-60 for dates equal
to or greater than than 2 months past. What would the formula be for a future
date?
Returning zero if the results of a formula is a negative number?21 Apr 2008 11:08 GMT7
How do I get a simple addition formula to return a zero in a cell if the
formula yields a negative number?
FORMULA/FUNCTION TO LOCK AND UNLOCK A CELL21 Apr 2008 11:03 GMT2
I AM TRYING TO LOCK A CELL DEPENDING UPON THE VANUE THAT HAS BEEN RETUREND
FROM ANOTHER CELL.fOR EXAMPLE IF CELL a13 RETURNS 1 THEN CELL a14 SHOULD BE
LOCKED SO THAT NO ONE CAN CHANGE THE CELL.
PEASE  HELP
SumProduct21 Apr 2008 11:00 GMT2
i've got two identical work books (one for 2007 and one for 2008)
I have a sumproduct formula that works in the 2007 workbook but not in the
2008 workbook.  I get a #value error in the 2008 workbook.
The formula is:
Saving as .xlt21 Apr 2008 10:33 GMT1
Hi,
I have made a form with several formulas, have locked those cells with the
formulas and have protected my sheet.
When I save as .xlt one particular cell loses its formula, can anyone help
Can anyone !21 Apr 2008 07:03 GMT1
I have range in A1 : B10,
Col A - Names
Col B - production data
In a day ( 8 hour work), I need to update data on every 2 hour in a
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.