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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
sorting or is this consolidating08 Nov 2006 12:38 GMT3
I have an excel file that looks like this:
ID#           account          status
10             1                     open
20             1                     open
deleteing documents08 Nov 2006 09:31 GMT1
I cannot delete any documents in the recent document list  that are not in
use any longer, my list of recent documents just keeps getting longer; I have
changed the pin to green to unpin the document but nothing happens......how
do you delete the names (the files are no longer ...
Protecting Sheets08 Nov 2006 08:51 GMT1
I have a workbook which has about 120 worksheets. Is there any way to set
the Worksheet Protection on all sheets at one time? I want all sheets set to
allow only the selection of unlocked cells.
Counting values in a range08 Nov 2006 06:34 GMT3
Hi to all,
Range C5:C32 contains letters either "C" or "M"
Range D5:D32 contains letters either "M" or "F"
I want to count the number of combinations of the letters which are as
Select column range in VB?08 Nov 2006 03:18 GMT2
Hi - I am using MS XL 2002 and I have created a macro that inputs data
to a specific cell.  I want the macro to input this data in a range of
cells; the data should be input into all the same row cells in column
A, providing there is data in the same rows in Column B.
Hide sheet tabs?08 Nov 2006 01:16 GMT12
Is there any way to hide sheet tabs?
Thanks.
Cells won't accept specific text08 Nov 2006 00:53 GMT3
When I attempt to type the three letters myu into a cell and press enter, the
u gets dropped leaving only the letters my.  It does not happen with ayu,
byu, nyu, etc, only with this combination of letters.  If I change the cell
formatting to text only, the same result occurs.  
time sheet help08 Nov 2006 00:41 GMT3
I need to analyze the hours worked by employees on certain days off to
determine how many hours, during what would be their normal shift time,
that they actually worked.  Here's how I have the columns: A= Time
started, B= time finished, C= the total hours worked, D= normal shift
Formating of cell size-08 Nov 2006 00:14 GMT1
Hi- It should be simple but I can t figure it out. Cells are locked to size
from top to bottom of document .Yes I can adjust the heights and widths but
how do I format some cells in the bottom of a document that I dont want to be
the same size as ones a little higher in the ...
Two lists, find *similar* cells (not duplicates) and mark/highlight, etc.07 Nov 2006 23:55 GMT3
So I have 2 lists with client names.  Since different salespeople
entered each data cell, the client names are spelled differently in
many of the entries.  For example, some list client Bill Smith as: "B
Smith" "B. Smith" "Bill S." "Bill Smith"...you get the idea.
Migrating Macros to new log-on07 Nov 2006 21:38 GMT1
We've just been migrated to new servers, and with them came a new log-in.  I
had a whole bunch of macros under my old log-in, and if I go back to it,
they're still there.  How can I move them to the new log-in?  If I just have
to re-key everything I can do that, but I hope ...
Excel configuration07 Nov 2006 20:56 GMT3
I have Office 2003 on two systems, one of them brand new. Is there a way to
move my Excel configuration from the old to the new system?
                            Thanks, CMA
Sum column based upon corresponding values07 Nov 2006 20:27 GMT2
I know this is probably simple but I can't get anything to work.  I
have a formula that I took from another document to use in a new
project.  The formula looks at the values of a specific range in
another workbook and then counts the values of a corresponding column.
Pivot question07 Nov 2006 20:27 GMT1
I have to create a pivot table as follows
The raw data are structured like that
Id   Col1    Col2 Col3
1    A       D     F
Excel 2000 VBA problem07 Nov 2006 19:41 GMT3
Can someone please advise me how I would write a VBA routine to scroll
through each row of a spreadsheet and delete the row if one particular
column value <>"" .  I should mention that there is a formula in this
column - IF (H1= "","",networkdays etc etc.  I am trying to keep all
 
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.