A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Set Textbox on a Form to Deafault by John Calder
Hi I use Excel 2K I have a form with a number of textboxes. I would like some of these textboxes to default to a particular number. This is so the user does...
July 28th, 2009 01:39 AM
by OssieMac Go to last post
7 188
ComboBox Code by John Calder
Hi I run Excel 2K I have opened the VB editor and inserted a "form". I have added a combobox to the form What I need to know is how do I populate the...
July 28th, 2009 01:17 AM
by John Calder Go to last post
4 190
Merging 2 excel sheets with numbers and words by Excelnewbie
I started with one sheet (using Excel 2003) but took a copy home (on a flash drive)to work on and added data (both numbers and "X" 's) - using Excel 2007. I...
July 27th, 2009 06:00 PM
by Eduardo Go to last post
1 114
Keep adding to one cell to carry a total in another by Mex
Hi I want to be able to use one cell to keep adding new numbers to that will accumulate the total in another cell. Ex: I use A1 as the cell to input a new...
July 27th, 2009 02:26 PM
by Don Guillett Go to last post
7 150
balance in excel that only shows the last entry by mchick
I have a simple formula in cell G4 I have =(g3-c4-d4-e4+f4) When I copy it down for the entire column it shows the last "G" entry all the way down. I want...
July 27th, 2009 03:06 AM
by T. Valko Go to last post
3 115
Slow Opening Shared Workbook by SteveH
I have an Excel 2003 workbook that is shared. It's about 35 Meg in size. If you open it in Excel 2003, it loads in about 15 seconds. I have one user that is...
July 26th, 2009 11:18 PM
by JLatham Go to last post
1 245
Method to Calculate APR in Excel? by PJF[_2_]
Any suggestions or solutions would be appreciated. Thanks & regards, PJF
July 26th, 2009 07:55 PM
by PJF[_2_] Go to last post
3 205
multiple y axis in xy chart by sivaprakasam
is there any options or macros avialable for creating multiple y axis in the xy chart. my application is that i want plot a graph for various values at a time...
July 26th, 2009 06:48 PM
by sivaprakasam Go to last post
3 211
Static Data Updating by MilleniumPro[_2_]
I found the problem. With the code I will post below, the static date and time works as iit shoud, however, whenever I use the "data filter auto filter"...
July 26th, 2009 01:49 AM
by OssieMac Go to last post
4 185
why don't i get colour in my drop down menu by Tim
When creating a drop down menu in excel the colour fonts from my selection lists are not transferred to my menu? can you help?
July 26th, 2009 12:00 AM
by Shane Devenshire[_3_] Go to last post
1 117
Training at its Best! by Raj[_7_]
Training at its Best! Hello guys, Now you don't need to worry about passing the certification exam. Visit http://www.FreeExamKing.com and get certifications...
July 25th, 2009 08:58 PM
by Raj[_7_] Go to last post
0 98
leading zeros by Dave
Hi All, I have an issue with formating cells. I have a permit number that has leading zeros sometimes, so I must display them when entered. I have tried...
July 25th, 2009 08:44 AM
by RyanR Go to last post
5 132
Annual % Rate calculation by PJF[_2_]
Using the nominal rate for a loan, is there a formula in Excel for calculating the APR? Thanks and regards, PJF
July 25th, 2009 03:50 AM
by PJF[_2_] Go to last post
2 150
How do I count the cells ending with a specific letter? by David
Hi, I am trying to count the cells in a column ending with a particular letter. Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is giving...
July 25th, 2009 12:17 AM
by RagDyer Go to last post
5 172
Dynamic Reference by Tyler.C.Brown
Is their any way to return a value from a dynamic reference to a closed spreadsheet?
July 24th, 2009 11:58 PM
by Dave Peterson Go to last post
7 197
Pivot Table by H
Hi -- I have a pivot table Column A = Soldtoname Column B = Sales # Column C = Software Column D = Support Column E = Grand total Is there a way to...
July 24th, 2009 05:57 PM
by Eduardo Go to last post
1 133
Count if by ecf123
I trying to count enties with different conditions example if this A1=A2,1, if A1A2,0, if A2A3,1 can somebody help me setting up this formula -- Thanks ECF
July 24th, 2009 05:12 PM
by RagDyeR Go to last post
7 156
xy chart doubts by sivaprakasam
-- sivaprakasam
July 24th, 2009 01:49 PM
by Bernard Liengme[_2_] Go to last post
1 135
Static Date and Time and VBA editing by MilleniumPro[_2_]
Hello all, I have no idea how to write VB and have spent an extensive a mount of time doing trial and error. The following code is what I currently use that...
July 24th, 2009 05:25 AM
by Shane Devenshire[_3_] Go to last post
2 109
Lookup ? by H
is there a lookup function that I can use to categorize a column In Column Q I have a percentage for example ColumnQ ColumnR 22% ...
July 23rd, 2009 11:05 PM
by JoeU2004 Go to last post
1 100
Post New Thread


Display Options
Showing threads 1281 to 1300 of 13737
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.