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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Fun trying to convert xls to document everyone can open!13 Sep 2006 22:26 GMT4
I have Office 2003 and created spreadsheet for class schedule that I could
use formulas, hide columns, etc. Excel seemed to have more advantages over
keeping it in MS Word.  However, not everyone has Excel so I have had fun
trying to convert it.  It is only a two page document ...
HOW DO I DELETE NUMBERS IN A COLUMN out of each cell13 Sep 2006 21:23 GMT2
I have a list of part numbers in a column, over 5000, and I need to change it
while keeping other information in tact.  For example
1025-00-128-5463                (Each of these numbers are in a cell which
totals
Populate a cell based on adjacent cell13 Sep 2006 21:14 GMT1
I have a worksheet that contains outgoing call data.  The first column
is the Group Number column, so each record begins with this group
number.
I've inserted a column to the left of the Group Number column.  I want
Transpose a variable length list into Excel / Access Table13 Sep 2006 19:37 GMT11
Example given of a variable length (library) list, but which may actually be
1000 long. How can I transpose the data into a Table in either Excel or
Access?
LC Control Number    79013607
merging data from 1 excel file, into a master excel file13 Sep 2006 18:39 GMT2
I have 2 spreadsheets - a master spreadsheet and sheet #2.  Sheet #2 contains
all of the information from the master (with the same exact columns), plus
new rows that are inserted throughout.  The first column of data uniquely
identifies each row.  Most of the rows are identical ...
Export from Excel to Word13 Sep 2006 17:30 GMT2
I have a 20 page Excel document that has a LOT of formating involved, it is
text not data.  Is there a way that I get it into Word without having to redo
all the formatting?  It is 11x17, landscape.
Deleting or cancelling large amount of data in excel13 Sep 2006 17:25 GMT2
Got the following problem apparently easy but it's driving me crazy.
I've a large file (c40mb) containing large matrices full of datas and
formulas (ie thousands of rows / approx 100 columns)
Whenever I try to delete the content (or clear content) of one of this
sorting data to obtain a fixed amount13 Sep 2006 16:42 GMT2
Please help!! I have numbers in a row of cells and I would like to have a
formula to sort the data to give me a  fixed total... (like which cells would
equal x) i don't know which of the cells make up that total... can excel tell
me which cell combinations would equal any given ...
Conditional Formatting for a certain month13 Sep 2006 16:26 GMT8
Having a bit of an issue at the moment, ive got the Cell for instance
A1
Which contains
04-Jan-06
Is there any way of calculating a running total within a single cell in a column13 Sep 2006 13:22 GMT2
Can anyone help with this query?
e.g. I want to work out how many people are working at any time in a
24 hour period. The number of people rostered on differs each day of
the week.
Last ModifiedDate -15 days13 Sep 2006 12:50 GMT5
I have a function which does the following:
1. Remove .xls from the file and use reminder as a wild card by
additing * at both the ends
2. Query the directory (source path) for the wild card
Adding rows in Excel worksheets and 'deduping'13 Sep 2006 12:34 GMT20
Can anyone help please?
I have a table of staff members and tasks set out as follows (the real
one is a lot bigger)
        Task 1     Task 2    Task 3    Task 4    Total
Inputting a US map into Excel?13 Sep 2006 12:24 GMT1
I gotta quick question:
Has anyone ever tried to input a dynamic/auto-updated US map int
Excel?  Let's say I have a database which includes a column calle
"state" and a column called "count", which has integer values countin
How do I easily divide an excel list of names/addresses among 6 pe13 Sep 2006 12:05 GMT4
I am very new to Excel and need to divide an excel spreadsheet with 250
names, addresses, dates, etc  between 6 people in an order of wedding date.  
Is there a really easy way to divide the list up so that each of the 6
people  gets the next name on the list?
set up print prefs in vba screen13 Sep 2006 11:01 GMT2
vba project window
under heading VBA Project (Workbook.xls)
open folder Microsoft Excel Objects
I am given a list of worksheets & their given Names
 
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.