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 / February 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Mix up names 25 Feb 2008 22:34 GMT5
What is the formula and how to:
To change the names from alphabetical order to being shuffled.
Excel 2003
Thank You
Hidden Rows25 Feb 2008 22:23 GMT1
OK ..  this has me stumped.  I can't find rows 1 and 2 on my spreadsheet.  
They aren't hidden (format/row/unhide), and there is no data filter on my
spreadsheet so I can't go to "show all".  When I "go to" cell B1, my cursur
probably goes there but I still can't see it.
Starting Auto_Close macro based on an IF statement25 Feb 2008 22:22 GMT4
I'm over my head --
I run an auto_close macro to retrieve and save data collected during a user
session.  The macro takes all rows with data, copies them to a folder, then
clears the collection sheet for next session.
How to select certain cells in a column ?25 Feb 2008 22:08 GMT3
Excel 2007...
In Column A are the 1,200 ID numbers that I want, in sequence.
They're not all consecutive numbers.
No numbers are repeated.
Date calculation cell became #NAME?.25 Feb 2008 21:36 GMT1
I have hundreds of row with column ship date, complete date, etc...
For the column of complete date, I have this formula which calculate 15 days
from the ship date field excluding holiday.
=(WORKDAY($B162,-15,Holiday!$A$2:$A$24))
Insert filename via a browse to cell25 Feb 2008 21:23 GMT2
I would like to click in column A.  Let's say cell A3 and browse to a file on
the network and then click on the file and have the filename automatically
inserted in the cell.  Maybe even the path - but it just has to be the name.  
Then if I move to cell A4, would like the same ...
PASTE SPECIAL25 Feb 2008 21:01 GMT1
I have this code to submit a time stamp whenever a button is pushed but I
want it to paste Special so the time stays static and does not update with
each push of the button.
Sub TimeStamp()
Counting more than one criteria25 Feb 2008 20:53 GMT4
I need a count of how many times three columns (Year, Gender and Date) have
the same values.
For example Year 4, Male and In    or   Year 8  Male and In.
Name    Year    Gender    25/02/2008
edit insert dialogue box25 Feb 2008 20:42 GMT1
In 2000, Excell, I had more option when it came to inserting or deleting. I
had 2003 Excel installed and now when I try to insert a cell, it will only
ask me to shift entire row or entire column. It doesn't allow me to shift
cells down or shift to the right.
Sorting a range loses formatted borders25 Feb 2008 19:58 GMT3
Recently started new job where the standard is Excel 2003 SP2.
I have a worksheet which is automatically populated and formatted from VBA,
based on data extracted from a directory-full of spreadsheets. All works ok,
except when I sort the resulting worksheet the borders don't move ...
Comparing to a range and printing value25 Feb 2008 19:57 GMT4
I have a column of data like this (just a sample):
16.81
17.25
16.51
Match and Sum25 Feb 2008 19:57 GMT1
I am trying to get a sum total upon matching conditions (Example)
B6 = CL Type
E6 = Number of Letters
in cell B6 there will be one of 4 selections (ENC Letters, ENC BR Letters, V
Need of a Database for some "basic" info25 Feb 2008 19:56 GMT1
A friend was asked to create a Database that would allow a person to pull up
the info (while on the phone) that contains basic info (like client's names,
addresses, spouses, birthdays, etc.).  This can be done in an Address Book or
Contacts List.  However, the person may also ...
Formula to write Calendar dates excluding weekends -  urgent pleas25 Feb 2008 19:56 GMT2
I need to create a time tracking sheet for 3 employees working on certain
tasks.  I need to track their time they worked on these tasks for each day.  
The employee should go in each day and write how many hours they worked each
day on those tasks..
Where is speech and Handwriting     tool in office 2007‏25 Feb 2008 19:55 GMT1
How i can get in word/excel 2007
 
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.