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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Data sharing23 Nov 2007 19:16 GMT4
I have one excel file where we insert information constantly on one desk.
But we also have another person who needs to insert more information on his
side on another part of the office.
How can I share some columns so every time the second person needs to add
Excel Formula to add stock23 Nov 2007 18:08 GMT7
Is it Possible to have have one target sell change one way only?
For example i want to use one cell only to add stock.  What ever stock
arrives i just enter this number into the one cell and it changes.   I have
the formula configured to change the stock held when stock in and ...
Graph Re-size Macro23 Nov 2007 18:01 GMT5
I want to be able to create a button that will automatically enlarge a graph,
and then when it is pushed again will shrink the graph back to its original
size.  I tried doing this and the graph kept shifting to the left every time
I pressed the button.  I do not want the graph to ...
stop entry of data that causes a negative value from a formula23 Nov 2007 17:30 GMT3
Excel 2002.  I tried to use "Validation" on the "Data" menu but that only
works on entered data.  I have a formula in a cell and if the answer becomes
a negative number I want it to stop the user and "force" them to fix it.  I
used an IF condition but that only displays a message ...
Date calculations in Excel23 Nov 2007 17:08 GMT2
I am a very basic Excel user and I'm trying to set up a formula that will
calculate a date based on me providing a "Due Date" and a "Number of Days
Prior Item is Due".  I also want to be able to change these fields and have
the formula recalculate the date.
Hyperlink to web does not return to original Excel worksheet23 Nov 2007 17:04 GMT1
I have an excel file which has 12 worksheets.  On every worksheet there is a
hyperlink to the same webpage (copywrite info).  When the hyperlink is
activated the first time it returns to the original worksheet but if you
change to another worksheet it will always go back to the ...
IF Fill Color = Green, then "G"23 Nov 2007 16:42 GMT2
Hi,
Is this possible? I would like to create a statement saying...if the FILL
COLOR of cell D1234 = Green, then type "G".
Can this be done (with or without VBA)...and well, how if possible.
Problems Coping and moving sheets between files Excell 200723 Nov 2007 16:37 GMT2
I am trying to copy a Excel sheet from a file to other, excel shows
the
following warning. Excel can not insert sheets because the destiny
have
Navigation of Excel 200323 Nov 2007 16:14 GMT2
I am unable to move down through the rows by using my enter/return key.  Does
anyone know how to adjust my settings in order that this is rectified.  FYI I
also had problems with tabbing however, this has been corrected by removing
the tick in the Transition navigation keys which ...
Trying to create an overdue message based on set dates23 Nov 2007 16:05 GMT5
I have a simple grid spreadsheet with a list of road names down the left and
1st cut, 2nd cut, 3rd cut etc along the top. The idea is to show how many
times the grass in each road is cut. There should be one cut every two weeks
and the date of that cut is then entered. What i ...
Rounding up totals.23 Nov 2007 16:05 GMT6
I am trying to total (in cell F4) the percentage of a range of cells but
with a minimum value.
In cells F14:F63 I have the amounts:
F14        600
I can no longer edit hyperlinks via right-click menu, help please23 Nov 2007 15:43 GMT3
have i accidentally turned this option off somehow ?
Date Questions23 Nov 2007 14:54 GMT2
I have two problems with the format of two different columns of dates i have
coppied onto an excel sheet. I need to be able to have the dates in a
standard date format in order to be able to work with them. The problems are
as follows:
Excel IF statement23 Nov 2007 14:52 GMT2
I am struggling with an IF Statement in Excel. I want to have a sheet which
says if it is mon -thurs add these totals and if it is Friday add these
totals together.
Does anyone know a way around this
Pivot table23 Nov 2007 14:43 GMT1
I want to display in my pivot table report data fields which have no value
yet but I dont want those fields to up as "blank", instead they need to be
displayed empty as in the database.  How do I accomplish that ? I have tried
formating them via table options checkbos for empty ...
 
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.