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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
HOW DO I E-MAIL WORKSHEET AS IS WITH ALL FORMULAS, ETC?15 Aug 2008 22:44 GMT1
Trying to e-mail a financial worksheet and only print out sent, not the sheet
in the workbook with formulas, etc.  Is there a way to do that? When I click
the Office Button and go down to send, only choice there is "Inernet Fax".
Tried "e-mail" under commands and only print of ...
Need to pick up data from left of a space starting from the right?15 Aug 2008 22:40 GMT3
1 4210210 134.40
2 30362920 395.40
3 820401-2 116.20
4 728435514 5152.06
Next time sheet is touched, remove items from cells?15 Aug 2008 22:02 GMT3
I had this before and did not get any takers.  I think the chalenge is more
getting to do it once and not to check each time?
=============
Not sure how to do this, but I have a sheet that I have a macro export data
Select, find in another book, copy, return and paste15 Aug 2008 21:42 GMT3
Excel 2003
I have multiple catalogue workbooks, all use the same layout. I want to
update the on hand stock in column H for the item numbers I select in
column B. All on hands are in workbook peter1.xls in column G.
Formula for formatting font/style15 Aug 2008 21:37 GMT2
I am creating a spreadsheet where, in a certian column, each entry starts
with a bold capital letter that codes for something, followed by a text
description. I am hoping a formula or setting exists so that I can type my
information in and automatically capitalize and bold the ...
X EQUALS A NUMBER15 Aug 2008 21:20 GMT3
I would like to place an x in a cell and it repesents a number:
For example:
Always  Frequently Occationally Seldom Never
  =1         =2              =3            =4       =5
Still trying to average 4 worksheets and having formula problems15 Aug 2008 21:01 GMT3
Basically I need the average of 4 cells on separate worksheets with 1 or more
cells having a DIV/O message. A little background: these 4 worksheets are the
quarterly results (averages from the monthly workbooks) then I need a formula
that averages the quarters to make a ...
PivotTable - Sum and Count15 Aug 2008 20:59 GMT1
As part of my PivotTable, in the Data field I have 2 columns, one for the Sum
of a value and one is for the count of another value.  The PivotTable
displays what I want, each on a row, but I would like the currency sign to
appear on sum values but not of course on the count ...
creating a quote15 Aug 2008 20:42 GMT7
How do i create a quote?
Format row color based on individual cell15 Aug 2008 20:22 GMT5
I have a list of work orders.  In column G, they are listed as being one of
four types, A, b, c, or d.  I would like row 1 to have a background color
based on the type in column g.  I would like to do this throughout the
spreadsheet.  I have tried conditional formating, but I ...
Maximum Allowed Rows15 Aug 2008 20:08 GMT5
I need to exceed the 65536 rows allowed in Excel. My work needs to be saved
in the csv format, and it must be a single column. Is there any way I can
create a single column with several hundred thousand rows?
Compati Checker - erroneous links warning15 Aug 2008 20:02 GMT3
I copied a sheet from one workbook to a new one where it is the only sheet.  
Every time I try to save the new workbook (in XL11 format) I get the Compati
Checker warning me about links to unopened workbooks - even citing 6
occurences.  Problem is that:
Using index and match15 Aug 2008 19:48 GMT5
I’m, trying to use an index and match function to return text from cells on
anther sheet. =INDEX(Formulas!$J$3:$K$6,MATCH(AM7,Formulas!$J$3:$K$6)) The
formula looks for a value that matches AM7, it is suppose to return text from
cells on another page shown below. I keep getting ...
Select Wich Cells To Include In Print15 Aug 2008 19:44 GMT2
Good Evening All,
Excel 2007.
I have a ss (report), in which I have included notes for the user, eg 'click
on button to refresh data'. These notes have been placed directly in
Scheduling Functions15 Aug 2008 19:25 GMT5
I'm creating a spreadsheet to track approaching deadlines for tasks to be
completed (on a construction project). I'm trying to figure out if there is a
function/formula that I can use to highlight cells as the dates approach. For
example, if today is 8/15/08, all cells that ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.