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 / New Users / December 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Hide Rows in one W/S Based on a cell value in Another W/S14 Dec 2006 12:52 GMT7
Hide Rows in one W/S Based on a cell value in Another W/S
I have the following code in an excel spreadsheet (see below).  The
code correctly hides the rows when C98 in one worksheet = "Dog" but
when C98 does not = "Dog" it does not unhide the cells on Sheet Blue.
ASAP Utilities (Free Download--Very Nice)14 Dec 2006 11:12 GMT1
I'm sure most of the higher echelon people here know about this little
utility, but for those who don't I wanted share this with everyone who
doesn't have it.  I've got a lot of good, fast and friendly help here,
so if I can contribute a little something then so much the better.
Excel Formula using relative position of cells in two different worksheets14 Dec 2006 03:36 GMT1
I want to know how a certain Excel formula would be written.
Excel formulas reside in cells computing the value of the cell content.
A given formula can be entered in an entire column, producing different
values in each cell in the column in which the one given formula is
How can I highlight a cell or row or column in excell 2007?14 Dec 2006 00:10 GMT2
I am using excell 2007 beta and wanted to highlight a row so I can organize
the group/s in each different colour, but I could not find the highlight. How
can I find the highlight, please?
Cannot open Excel files.14 Dec 2006 00:05 GMT2
i cannot open any excel files directly from there location. When i try to
access the file, it will open the program to the point just before the
workbook is about to be displayed and hangs. No error messages are created
and the system does not hang. I can however, open excel ...
How to determine the what quarters are between 2 dates13 Dec 2006 23:04 GMT5
I need to determine how many days fall between a start date and an end
date.  I am actually able to find that information, but how do I take
that total number of days and determine how many days (of the total)
fall within Q1, how many fall within Q2, how many fall within Q3, etc.
losing spreadsheets13 Dec 2006 23:02 GMT2
Hi y'all,
At work we're sharing a spreadsheet with everyone saving on a regular basis
so everyone can see the updates.  Unfortunately, the spreadsheet keeps
getting damaged.
Turn off chart13 Dec 2006 22:28 GMT8
I created a worksheet for a friend to record receipts.
He hit the F11 key by mistake and was presented with a chart.
Well, try as we may we couldn't get back to the sheet I created.
In the end I had to delete the xl file and reload a new copy and re enter
occurence count13 Dec 2006 21:23 GMT6
I've got a row representing 31 days in a month.
If a worker calls in sick, the hours missed goes in that cell.
That could be any number up to 8 hours.
That absence may carry into many days.
Bloomberg add-in anomalies13 Dec 2006 21:16 GMT2
A discovery was reported at work today: a user has the Bloomberg add-in
(http://about.bloomberg.com/software/index.html - the DDE Server and
Excel Add-Ins file) installed on his computer, and Excel seems to have
been affected in two ways that he's noted so far:
XIRR question13 Dec 2006 19:44 GMT5
I have the following numbers/dates in an excel sheet A1:D3
     1/1/2007 1/1/2008 1/1/2009 1/1/2010
      $      (10)  $         1    
      $         2   $       20  
HYPERLINK OPEND FILE WITH WRONG VIEWER13 Dec 2006 17:19 GMT2
Excel 2003 (11.5612.5606) XP-Pro SP2
I have cells with hyperlinks to various small .JPG nd .GIF images
located in a folder different from the worksheet. For well over a year
the images have been rapidly opening with a lean, mean viewer
header and footer in excel 200313 Dec 2006 16:55 GMT2
I want try setup repeat row 1 to 4 for header and repeat 64-68 for footer.
How can setup , pls advice. That mean every page show this header and
footer.
Looking up data in various columns13 Dec 2006 15:09 GMT1
It is possible to do the following:
Column A   Column B   Column C   Column D   Column E
                      123        456        No
                      789                   Yes
Creating dynamically arrays, is that possible in VBA?13 Dec 2006 11:37 GMT3
I would like to do the following, but I am not sure it is doable in
VBA. I saw it in Php, so I have a little hope it is.
I have a spreadsheet full of range names. They are all of the form
"S1.Name3.Subname2". Basically I would like to load in VBA all the
 
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.