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 / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Protecting a watermark?23 Aug 2007 21:25 GMT2
Is there a way to protect a watermark in excel?
syntax error - help23 Aug 2007 21:08 GMT2
Worksheets("Cost Analysis").Activate
   Set UdRng = ActiveSheet.Range("F10:F38")
   UdRng.Formula = "=IF(AND(A10>0, H10>0),"EQ","")"  << occuring here
   ActiveSheet.Range("A9:G38").Select
Numeric Format Changes From 1 Cell to the Next?23 Aug 2007 20:38 GMT2
I have a client with a list of numbers, all 15 digits long, in one column.  
All cells are formatted as numeric "General".  All cells display all 15
digits, except one.  This one cell displays the number in scientific
notation, even though the cell appears to be formatted as ...
Second small arrow on filter button23 Aug 2007 20:28 GMT1
In Excel 2007, one of our users noticed a small, black arrow on the filter
button in her spreadsheet.  It appears to the right of the filter or standard
arrow on the button and it's a skinny black arrow pointing up.  What is this
and what does it mean/do?
Protecting header and footer?23 Aug 2007 20:24 GMT1
Is there a way to protect the header and footer in an excel file?
I have the sheet protected but it still allows you to change the footer that
I currently have.
Sum VLOOKUP23 Aug 2007 20:14 GMT2
I'm using the following formula to lookup up my employees based on their ID#
and return the value in column 2 where a match is found. How do I sum up
these matches if the employee number appears more than once?
=VLOOKUP(X2,'LaborDetail'!P2:Q1000,2,FALSE)
Locking Info only which came from another worksheet23 Aug 2007 19:58 GMT1
I have an excel 2003 File (Workbook) with several worksheets.  Some info in
the worksheet that I want to preserve is derived from the other worksheets.  
I want to retain the actual values in the main worksheet and delete the other
worksheets.  Is there a way of doing this without ...
I have 2 books and i have to vinculate both what can i do23 Aug 2007 19:54 GMT1
When I sort the fon I miss the vincles. If yo can answer me in Spanish that
better
Mail merge an excel cell that is preceeded by an apostrophe?23 Aug 2007 19:50 GMT1
How do I merge an excel spreadsheet into a Word document when it includes
cells that are formatted as text or preceeded by an apostrophe?
Need help with formula23 Aug 2007 19:42 GMT2
I need a formula that will subtract 10% of a number.
SUMIF does not work with blank cells23 Aug 2007 19:36 GMT3
Can SUMIF be used if there are blank cells in the range of data?  (The
worksheet has been formatted for a purpose, so I do not want to remove any of
the blank cells.)
Time Difference23 Aug 2007 19:32 GMT1
Tried everything on this, I have two times in a spreadsheet.One is 05:15 and
the other is 08:17. I need the exact difference between the two in hours to
three decimal places at least, so here it should show 3.033, instead all it
ever shows is 3.00. I've tried the hours function ...
Newbie Macro Question23 Aug 2007 19:15 GMT1
I am tasked with data entry.  From a spreadsheet, I enter data into Access.  
To keep track of what I've entered from the spreadsheet, I'd like to change
the color of a cell.  So, I'd like to have a quick little macro that colors
the current cell that I am in to a different color. ...
Sumproduct with OR23 Aug 2007 18:24 GMT4
I searched through some of the questions here to find a solution to this,
however, i'm more confused!!
I would like to return a total where one of the columns i'm totalling has
more than one criteria.  Specifically in this formula i would like to total
Clear Auto Filter on Close (or open)23 Aug 2007 18:16 GMT3
How would I ensure that if Auto Filter is on, it is cleared when the
workbook is closed (or opened)?  I'm not much of a programmer, but I can copy
and paste! :)
TIA
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.