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 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
out of range error18 Sep 2005 00:12 GMT9
Help please! Why am I getting a Runtime error 9 subscript out of range error
on this statement?
Workbooks("filename.xls").Worksheets("Sheet1").Select
Many TIAs
Entering Numbers with 2 Decimal Places - Automatically17 Sep 2005 21:48 GMT2
I've been using Excel for years, yet this is my first time on this
newsgroup.
When reconciling my checkbook, I can set my 10-key calculator to 2 decimal
places, so that whenever I enter a number, it automatically converts it to
Principle reduction question17 Sep 2005 19:30 GMT7
I know how do use the pmt() function to calculate mortgage payments but
I need to know the easiest way to calculate the total principle
reduction/remaining balance after a set number of payments without doing
an amortization table.
Extracting images17 Sep 2005 12:22 GMT2
I use Microsoft Office Excel 2003 SP1
I've been sent a spreadsheet that has some cells containing images.
How do I extract the images to save them separately?
tabs17 Sep 2005 09:18 GMT1
I want to add pulldown menus on some of my fields.  Can someone lead me in
the right direction on how to do this?  You know...I need to have choices so
I do have to type the thing in all the time.  I just click on the arrow and
bring the pulldown down and choose the correct text.
Macro wont run17 Sep 2005 01:05 GMT1
The macro below wont run. When I select a column of data ie: A2:A58 it is
suppose to delete the entire row if a cell in my selection is blank.
All my other macros run OK.
I'm running Excel 2003.
If "text" exist within "cell" then TRUE17 Sep 2005 00:41 GMT7
I cant find a way to look up if a string of text exist within a cell and
reply with TRUE or FALSE, such as "if "text" exist somewhere within
"cell" then TRUE".
I have a list that looks something like:
How do I set up a Doubles Tennis roster for 12 players?17 Sep 2005 00:31 GMT3
The Idea is that all players play once with each other & the scores are
tabled showing which the best partnership/ players are - I'm stuffed !
Edit-Find doesn' work, don't know the problem.17 Sep 2005 00:27 GMT1
I'm using an excel document and I want to use the Edit-Find feature to locate
names within the document.  I know the names are there because I've put them
in and when I use the Edit-Find it doesn't work.  I don't the problem and
would really appreciate some help.
testtest17 Sep 2005 00:07 GMT1
test
test
test
test
Pivot table discarded to due to integrity problems16 Sep 2005 23:41 GMT3
I have a client with a mid-sized workbook. On one page is a pivot table.
Occasionally, upon opening the workbook an message appears about errors
being detected in the pivot table. The result is that the workbook opens,
but the worksheet with the pivot has now become "flat data". The ...
Calculate total of only visible data.16 Sep 2005 22:13 GMT2
I have attached a zip file of my actual data sample. First run the macr
(a) macCreateDetailRpt and then (b) macFormatDetailRpt
The data is about the training given to employees of different compan
either web-based or via Instructor. The total field for each mont
Offset Problem16 Sep 2005 20:03 GMT1
=OFFSET(`[worksheet05.xls]PROCESS LOG`!$K$9,B9-4,0,1,1)
This formula linked to another spreadsheet previously worked, but a ne
workbook has been created and the formula now returns a "0" value to th
cells?
take sum of 6 different values and then * that answer by a %16 Sep 2005 19:48 GMT1
I am trying to numbers from different cells and add them for a total and then
multiply that number by a percent to get my answer. I can't figure out how to
make this formula. Example c10+d10+e10+f10 +j10+m10 and then that total *by a
percent.
Permutation in excel16 Sep 2005 19:14 GMT8
I´me a new member in your forum, can somebody help me to solve this
problem in excel please:
I need to make combinations with a makro or a funktion in excel as
followed:
 
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.