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 Reverse Sort Order Replies Views
Very slow Excel by Berend Botje
Hi, Recently my excel has trouble opening and closing my workbooks. It takes about 30 seconds to open or close a workbook. Furthermore, it takes far too long...
July 2nd, 2004 08:10 PM
by Gord Dibben Go to last post
2 214
Matching data and returning header by matman17
I have a list of Employees and I want to lookup and copy each employee's department into the next field. Right now I have it setup on two spread sheets. One...
July 2nd, 2004 07:57 PM
by Domenic Go to last post
2 361
Unable to Update Links. by Shelley
I moved some workbooks into new folders that contained various links to other workbooks. After doing this, even though the formulas have the correct location...
July 2nd, 2004 07:29 PM
by Shelley Go to last post
0 595
Hiding password characters by mxleite
Hi! I've just added an InputBox function to my macro that requires users to enter a password, otherwise the other procedures do not run. However, there's a...
July 2nd, 2004 07:18 PM
by mxleite Go to last post
2 169
Pivot Table Max Columns - 2000/2002/2003 by TimS
Dear All, An annoying problem with pivot tables, when working with users with various versions of excel. We use excel to allow end users to look at data via...
July 2nd, 2004 06:50 PM
by Nathan Strom Go to last post
4 161
How do I invert matrices? by Aja
How can I make a matrix that looks like this Jan Feb Mar 95 A B C 96 D E F 97 G H I look like this 95 Jan A 95 Feb B
July 2nd, 2004 06:28 PM
by Harlan Grove Go to last post
3 192
migrate from Lotus 123 - roundup doesn't convert by willstevenson
I am trying to migrate Lotus 123 (.WK4) files to Excel 2000. Macros have been rewritten in VBA, nested (if) statements rewritten so as not to be 7 levels,...
July 2nd, 2004 06:21 PM
by Harlan Grove Go to last post
5 237
What function would I use? by Capn_Chord
I am making a spreadsheet for my work. In this spreadsheet I enter data such as the name of a customer, additional products they may have purchased, and...
July 2nd, 2004 06:15 PM
by CLR Go to last post
3 141
Need to GOTO a calculated cell reference by Dave Harker
I'm trying to create a household expenses/income sheet. I'm entering the day's income and expenditure figures and totalling them at the bottom of my worksheet....
July 2nd, 2004 06:10 PM
by jeff Go to last post
1 344
switch 2 cells around by whitedevil
Is there a way to switch two cells around? Copy something from cell A to cell B and from B to A without using any extra empty cells. Maybe using some...
July 2nd, 2004 05:52 PM
by whitedevil Go to last post
2 196
Format/Row/Autofit by
Can someone please tell me why my text will not fit in Autofit row. It just needs to be a little bit wider. It never used to do this, is it because I'm now...
July 2nd, 2004 05:40 PM
by Go to last post
4 594
Auto update of Pivot table by K. Georgiadis
C. Pearson's website includes VBA code for automatically updating a Pivot table upon opening the worksheet. Does the code need to be inserted in "This...
July 2nd, 2004 05:21 PM
by jeff Go to last post
1 400
Finding Value of a Cell in a Range by Wendy L
In cell C1 I want to place a formula that will return a value of 1 if the value of cell A1 is contained in the range of cells B1:B127 and a value of 0 is the...
July 2nd, 2004 04:55 PM
by Wendy L Go to last post
6 374
"Replace With" option by Joey
Hi all I would like to amend a column with phone numbers and change only the first two characters to a "0" Most of the numbers look like this; 44131 555...
July 2nd, 2004 04:47 PM
by Don Guillett Go to last post
2 152
convert formulas to values in place by K. Georgiadis
I know how to convert formulas to values by copying to another sheet with Paste Special. Is there a way to change the formulas to values in place, without...
July 2nd, 2004 04:34 PM
by Don Guillett Go to last post
3 223
Changing format for a single cell by jb1977
Is there any way to change the height of a single cell without it affecting the cells surrounding it?
July 2nd, 2004 04:11 PM
by Rufus V. Smith Go to last post
2 336
Pivot Table Error: Cannot group that selection by
Hello I'm trying to group invoice dates in a pivot table by month and year. Too bad there is no "reason" button? heheh Any suggestions are greatly...
July 2nd, 2004 04:07 PM
by Mark G. Go to last post
4 281
Reorganize excel listing by Dean
I need to develop a product/order list from an existing list in a different format. I have attached both. Is there VBA code that can do this for...
July 2nd, 2004 03:31 PM
by Dean Go to last post
2 231
Number Format by Alec Kolundzic
Can anyone help. The following code is part of a number generator, that fills a column with numbers in the format "0000" ie on 5 instances of AI, numbers 0700...
July 2nd, 2004 12:03 PM
by Ron Rosenfeld Go to last post
3 482
If statements by ExcelDummie
i cant get the OR bit right!!! i want it to check whether Cell $a$40 or $B$40 matches $S$29 then H36-$K$2 if tru and "" if false i can get it to do it for...
July 2nd, 2004 11:38 AM
by Norman Harker Go to last post
2 149
Post New Thread


Display Options
Showing threads 138681 to 138700 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 08:20 AM.


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