|
|
Make iteration default for a specific file by
bnmohan via OfficeKB.com
Hi!
I have an excel file that needs iteration. However, it appears the setting
saved with the file is sort of global: If it is opened with a fresh instance
of...
|
|
1 |
398 |
|
|
|
|
1 |
398 |
|
|
Stop Excel Rounding Dates by
leinad512
I frequently have to read .csv files into MS excel. These are textual
files, containing text fields, floating point numbers, integers and
times. The first item...
|
April 20th, 2005 04:19 PM
by Dave O
|
1 |
397 |
|
|
|
|
0 |
397 |
|
|
Installing: Microsoft Excel Feature by
Boblink
Hi, I recentlt Reinstall WinsowsXp Pro on my system and had to reinstall all
my programs and apps including OfficeXp.
When I opened Excel 2002, a message box...
|
|
0 |
397 |
|
|
|
December 23rd, 2009 05:17 PM
by luis r
|
6 |
397 |
|
|
I need a productif type function by
Mitch
I want to search a range of cells, say C:C for a value, if that value is
there i want to multiply the corresponding B cell and D cell together then
sum up all...
|
May 4th, 2006 05:33 PM
by Mitch
|
5 |
397 |
|
|
|
|
7 |
397 |
|
|
vba autosave by
totally lost[_2_]
Hi,
how do I get this to save the file to specific location, it just keeps going
to my documents.
Public Sub SaveAsE5()
ThisFile = Range("E5").Value
...
|
|
2 |
397 |
|
|
On Open by
Ian
Can anyone help me out with this?
I want a worksheet to preform these actions each time it
opens:
Automatically unhide any hidded rows (especially...
|
|
1 |
397 |
|
|
getpivotdata multiple items by
Raeven
Is there any way to have getpivotdata retrieve more than one set of
data, other than doing it like below?
=GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E...
|
July 26th, 2004 06:25 PM
by Raeven
|
0 |
397 |
|
|
drop down list multiple columns by
c
Greetings;
I have a question I am hoping someone will be able to help me with. My
overall goal is to create a dropdown list with a line of data in it. ...
|
January 27th, 2005 03:13 PM
by c
|
9 |
397 |
|
|
Show value, not formula in formula bar by
Derochema
We have a client that does not want to see the formula in
the formula bar. I decided to protect the excel report and
hide all formulas, but that is not good...
|
June 24th, 2004 07:58 PM
by AlfD
|
4 |
396 |
|
|
|
|
5 |
396 |
|
|
Concatenate text & number cell by
John
Hi all,
I need to concatenate a word and a number cell. eg,
Concatenate("Limit = $",A1) where A1 = $100,000. It shows
up like this: "Limit = $100000". However...
|
|
4 |
396 |
|
|
Automatically change tab reference by
TWC
I have 2 Excel files. One named "Actual" and one named "Budget". In each
file are tabs for the months of the year, "Jan" "Feb" "Mar" etc. The Budget
file Jan...
|
February 2nd, 2005 10:17 PM
by TWC
|
2 |
396 |
|
|
|
|
4 |
396 |
|
|
Limiting Size of Text Fields by
cynnyhelen
Is there a way to limit the size of a text field? I know the max in
Excel is 255 characters, but I have been asked to find a way to limit a
field to 50...
|
|
8 |
396 |
|
|
|
October 12th, 2004 11:52 AM
by Paul B
|
1 |
396 |
|
|
|
March 29th, 2005 12:37 PM
by Kassie
|
1 |
396 |