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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Reverse Sort Order Views
Hyperlinks by mevetts
Hi, I am trying to integrate some hyperlinks into my workbook, essentially all they are doing is jumping from one area on a sheet to another area on the same...
(Multi-page thread 1 2 3)
December 21st, 2005 09:13 PM
by Dave Peterson Go to last post
25 300
Use Named Range instead? by David
With a lot of help from folks here, I've got the following working: Sub PrintMine() Dim HPB As HPageBreak, FoundCell As Range Dim iCtr As Long, NumPage As...
(Multi-page thread 1 2 3)
May 27th, 2006 01:06 PM
by Dave Peterson Go to last post
25 275
how can I sort all cells in a sheet by a value in that cell? by [email protected]
The sheet is all words I want to sort all the cells by a name like "Bob" but bob is not always the first word in the cell. What I really need to do is list all...
(Multi-page thread 1 2 3)
April 13th, 2006 01:18 PM
by Dave Peterson Go to last post
25 443
How to allow "if then" text? by Kenshe
Looking for a way to allow only three possible entries into a field and using a one letter entry to spell out the full word of that entry, Example: If "P"...
(Multi-page thread 1 2 3)
December 12th, 2005 03:47 PM
by Dave Peterson Go to last post
25 449
Excel 2007 very slow to open even the simplest worksheet by John
I have worksheets that only have from 1 to 7 rows and Excel 2007 takes anywhere from 30 to 60 seconds to open these worksheets. I am running Windows XP...
(Multi-page thread 1 2 3)
March 26th, 2009 03:14 PM
by Roger Go to last post
24 378
pulling out Numbers by peyman
hi, how can I pull out numbers from a string?like: aa012985 to 012985 12ab-059 to 12059 the letters or characters might be either at the first, middle or...
(Multi-page thread 1 2 3)
August 22nd, 2007 06:27 PM
by Ron Rosenfeld Go to last post
24 265
email by rows by DaleL
hello All: I'm looking for a macro that will go down a sheet and look for the email address and mail every thing in that row to *ONLY* that person no matter...
(Multi-page thread 1 2 3)
July 28th, 2004 10:24 AM
by Ron de Bruin Go to last post
24 593
problem in VB codes by peyman
hi, I have a very simple code ,but I don't know why it doesn't work. Private Sub CommandButton11_Click() Range("G13:I32").Select ...
(Multi-page thread 1 2 3)
October 23rd, 2007 04:38 PM
by peyman Go to last post
24 193
A function to Turn Formula into Text? by lawson
Hello, as an engineer, I often have to show a formula from a book in one cell, show the formula with my values in it in the next cell, then show the...
(Multi-page thread 1 2 3)
January 3rd, 2008 10:57 PM
by lawson Go to last post
24 261
Counting non-numeric values by paljowestsub
I have a spreadsheet with the letter x in various cells. I want to count the number of x's in a particular row of cells. What formula do I use and how do I...
(Multi-page thread 1 2 3)
January 2nd, 2008 02:04 PM
by Don Guillett Go to last post
24 158
Changing a number into time by James
In my sheets for work i have basic formulaes to work out a basic time such as =SUM(F140/7+H140+J140-60) Which is this the amount of packs per hour (f140)...
(Multi-page thread 1 2 3)
January 13th, 2008 11:21 PM
by James Go to last post
24 195
Lookup function/sum function by Secret Squirrel
I have a worksheet (sales orders) that has a list of sales orders that I need to total up on a different summary worksheet by month. On the sales order...
(Multi-page thread 1 2 3)
November 21st, 2006 02:46 AM
by JMB Go to last post
24 146
option to prevent Excel changing 1-2-3 to a date by Vince
-- Vince ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion,...
(Multi-page thread 1 2 3)
March 3rd, 2009 09:49 PM
by Gord Dibben Go to last post
24 313
Deleting Duplicate items in a ListBox by CLamar
I have a Listbox in Excel and I am trying to loop through and delete the duplicate entries. How can I do this using VBA Thanks
(Multi-page thread 1 2 3)
June 13th, 2006 06:22 PM
by Dave Peterson Go to last post
24 336
Highlighting the 5 Largest Numbers in a list by [email protected]
Hi all, I have a Score column that runs into many entries. Is there a way to highlight the top 5 scores on the list in different colours. Conditional format...
(Multi-page thread 1 2 3)
April 17th, 2006 01:44 PM
by Don Guillett Go to last post
24 276
calculations quit working by CJ
Our new network administrator tried to keep all company computers from going on the internet, and in doing so he royally screwed up several spreadsheets on my...
(Multi-page thread 1 2 3)
November 17th, 2005 07:09 AM
by Doug T Go to last post
24 309
Importing unopened worksheet into an open Workbook by GrayesGhost
If an unopened Excel Workbook only contains a single worksheet, is it possible to import the data from that worksheet into another Workbook that is open,...
(Multi-page thread 1 2 3)
July 3rd, 2008 10:06 PM
by ACarella Go to last post
24 941
E-mail to every e-mail address in an Excel column? by MrMan&Fam
Say I have an Excel spreadsheet with one column of e-mail addresses. I want to send the same piece of e-mail (a WORD file) to each address. Is there an easy...
(Multi-page thread 1 2 3)
July 19th, 2006 09:35 AM
by milos Go to last post
24 427
Conditional Formatting - Getting pass the 3 condition limit by Cynthia
I have a spreadsheet where I have set a data validation for the colum to select from a list. The list has names of colors. (Red, yellow, etc) A total of 6...
(Multi-page thread 1 2 3)
May 20th, 2008 07:33 PM
by Judy Rose Go to last post
24 381
moving data from numerous colums into one colum by teresa
Hi, I have to move the data from numerous columns into one colum as a list, how can i do this? eg 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 to
(Multi-page thread 1 2 3)
August 4th, 2008 06:36 PM
by John C[_2_] Go to last post
24 234
Post New Thread


Display Options
Showing threads 61 to 80 of 139764
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 09:40 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.