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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
make image into autoshape27 Apr 2006 19:10 GMT2
I know how to draw an autoshape, and do the freehand, but how could I insert
an image in as an autoshape? For example, I want to take an image which is an
outline of a state (any state) and make it an autoshape, so that I can use
the fill color tool and fill in the state a ...
text wrap and change row height on different cells in an excel sheet27 Apr 2006 19:06 GMT2
I've been trying to look for a way to wrap the text and display it in
the row by adjusting the row height. I have found a way of doing this
for a selected cell, however i need my macro to be able to traverse
through the sheet and perform the task. I am not familiar to vba
Combining Cells27 Apr 2006 19:03 GMT2
I need the easiest way to do this:
I have a column with values. Sometimes there are 2 rows, sometimes 20.
For another program, I need all the values in that column in one long
string separated by commas.  So if my orginal data is:
Conditional Sum of Quarters27 Apr 2006 18:23 GMT4
I have tried the conditional sum to calculate quartely results for the
following:
Measures    Month    Population    Sample Population    Missing/Invalid
Population    Numerator    Missing/Invalid Numerator    Denominator    Observed Rate
Vlookup/If? Formula problem?27 Apr 2006 17:59 GMT1
Having a bit of trouble working out a formula and wonder if anyone can help
me...
I'm trying to look up a value (quantity of parts on hand) based on two
criteria (a part number and a revision)... the worksheet I'm looking up is
ERRORS IN TVM FUNCTIONS IN EXCEL 2003?27 Apr 2006 17:32 GMT1
As I understand the descriptions of the PMT, ISPMT, and PPMT functions, the
calculations returned for ISPMT and PPMTusing identical inputs should add to
PMT for the same inputs.  Can anyone explain why the first period's interest
(ISPMT) plus the first period's principal (PPMT) ...
Help with some formulas27 Apr 2006 17:31 GMT2
Well I have this problem, I need to determine the number of *days* (if a
person's b-day hasn't passed during the current time) if the b-day
passed I need to leave a blank or tell "b-day passed"
I already have the age formula, The formula for the day of the week
Excel Web Query27 Apr 2006 17:09 GMT3
I'm attempting to use Web Query to import a Web-based table into Excel in
order to perform lookups on the imported data.
The reference point is customer number - common to both my Excel sheets and
the Web-based table.
Clear History27 Apr 2006 16:45 GMT1
we have a spreadsheet that has columns for customer charges and totaling the
charges from all columns and have a paid column for partial or full payment
and then having a balance column we would like to clear old history
Is there anyway to clear every 2 months automatically all ...
Grouping / Ungrouping27 Apr 2006 16:39 GMT1
I have spent some time grouping rows on a large spreadsheet. Its quite
big and complicated now and there are 5 levels of grouping. What I
basically want to do is to remove the first layer of grouping so that
the second layer becomes the first. Make sense?
Trigonometry with excel27 Apr 2006 15:48 GMT6
If I wanted my answer in degrees for the following: opp side 8.3ft divided
by adjacent side 5.8ft should give me 55.05 degrees. I have no problem with
my little calculator but I'm having a difficult time trying to do this in
excel.
worksheet events and a little more help27 Apr 2006 15:45 GMT5
I'll start with the code i am using already:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Column = 6 And Target.Row > 3 And Target.Row < 256 And
Creating and pasting using VB27 Apr 2006 15:20 GMT9
I need to create an email and paste some data already selected in excel
into the body.  I have just started to attempt this so if I need to add
mapi or anything like that please let me know.  Any help would be very
helpful....
Quick Question27 Apr 2006 14:57 GMT1
I have a workbook that is basically made up of 2 worksheets, a importing
data sheet and a chart. Everything works great, timely refreshes and its
rather simple. The problem I have is this: The chart is basically a
seating chart and does not change at all(static). The 2nd worksheet
Help with a formula to determine data presence in other worksheets in the same workbook27 Apr 2006 13:48 GMT2
I have a workbook with 20+ worksheets in it.  Each worksheet contains a
series of columns where generally the 'key' (not a real key but the
term will suffice for this example) is in the first column and various
attributes of that key exist in subsequent columns.
 
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.