|
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
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
|
|
3 |
192 |
|
|
|
|
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
|
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
|
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...
|
|
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
|
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
|
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...
|
|
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...
|
|
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...
|
|
3 |
223 |
|
|
|
|
2 |
336 |
|
|
|
|
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
|
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...
|
|
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...
|
|
2 |
149 |