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 / Worksheet Functions / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Why do I get an error message hiding excel columns30 Oct 2007 11:01 GMT2
MY error message says it will not hide a column as it
cant "shift objects of the page".  I just want to hide the column!!
Help?
Dynamic SUM range30 Oct 2007 09:03 GMT8
I want to be able to SUM the last 4 values in row.  I know the exact location
of the last cell so this would appear to be my starting point and I would
work backwards from thee.  But the cells preceding it may contain a value or
there may be a blank cell.  There can only be a ...
Naming of column index30 Oct 2007 08:57 GMT2
Dear experts,
I've a marco in my worksheet which is used to show auto current date and
time when something is filled in column A. The code is:
Private Sub Worksheet_Change(ByVal Target As Range)
Automatically pu date when cell is edited30 Oct 2007 07:32 GMT3
i want the date to be shown next to a cell when that cell is edited for the
last time.
I suppose is possible, but i cant find the command!
Thanks in advance!
Cursor Movement?30 Oct 2007 05:18 GMT10
How do I make the cursor got to a specific cell in a worksheet?  The
worksheet is for others to enter data and some cells are locked - I want the
user to simply be able to hit the enter key and go to the next cell that
needs data entered - in sequence - Any help with what I ...
search across row for nearest value30 Oct 2007 02:57 GMT4
I am looking for a function that will search across a row of empty cells to
find the one cell that has a value; and then bring that value to the formula.
Additionally, I am looking for a function that will search across a row of
empty cells to find the nearest cell that has a ...
workday with month functions30 Oct 2007 02:19 GMT5
Hello,
I have tried to create a date function that would give me the workday for
any one month period,minus holidays, and would only display the workdays of
one month by typing a date in C1. My worksheet does not allow me to display
help PLEASE Urgent30 Oct 2007 02:05 GMT4
I have the following case that I am having problems with
      A            B
1  Number      Date
2  109956      1/08/1983
consolidate data30 Oct 2007 00:36 GMT1
I have 2 seperate workbook each workbook contains certain numbers and $
amount. Here is how I want to result:
before consolidate:
workbook #1                                          Workbook#2
how to avoid duplicate entries in column30 Oct 2007 00:25 GMT1
Hi thr,
Can anyone help with this I want to get prompted if some enters duplicate
entry into my excel sheet for a particular column.
Thanks a lot,
Formulas30 Oct 2007 00:08 GMT1
Can I create a formula that only counts cells that have been shaded or
colored? For example, every week I run a report that lists all active
"requests for information". The report shows the date the request was
created. Can I color the ones created since the last report, and ...
copying formulas29 Oct 2007 23:26 GMT2
All of a sudden, I am not longer able to copy a formula from one cell to
another.
Worse, if I change a cell in the formula (from 2+2 =4 to 2+3), the SUM still
reads 4.
Validation - Error message if equals Left formula29 Oct 2007 21:45 GMT6
I have a project code in column A formatted as general and the user should be
entering 4 digits dash 3 digits (0001-000).  In column B and C the user needs
to break out each part of those numbers.  In B they need to type 0001 and in
C they type 000.  I wanted to place a data ...
How do I carry page numbers across sheets in Excel?29 Oct 2007 21:43 GMT1
I have multiple sheets that need to have the correct page numbers, but each
sheet starts over at page 1, even when they are grouped. Any suggestions?
Difference (weekdays) between two dates29 Oct 2007 21:37 GMT5
How do i calculate the difference between two dates?  I only want to know
"work-days": Monday - Friday.
I know theres a calculation somewhere but cant find it....
Cheers,
 
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.