|
|
Macro for auto refresh by
Kim
Is there a macro where I change a cell in one sheet and the pivot table will
auto refresh.
If I change the cell B18 in Dashboard sheet, the pivot table in...
|
October 6th, 2009 02:22 PM
by Luke M
|
1 |
121 |
|
|
Formatting Data by
Gazz_85[_2_]
I can export from my MRP system into an excel format, but this does it in a
way so that i can't manipulate the data. all the cells have a ' before the
value....
|
|
3 |
129 |
|
|
Convert Text to a Formula by
dhstein
I needed to create a text string which is a formula. I did it and now have
400 entries like the following:
=DATE(2003,10,04)
Each of these entries is a...
|
October 6th, 2009 02:08 PM
by Al[_8_]
|
5 |
144 |
|
|
Pivot Table Drill into Details by
stevedemo77
I have a pivot table with 155 values and the count for each value. I know
that by double clicking on the count in the data area the details will open
in a...
|
|
3 |
114 |
|
|
EXCEL 2007 Gives error message when starting by
Analog Dave[_2_]
The message is: Opening the VBA project in this file requires a component
that is not currently installed. This file will be opened without the VBA
project....
|
|
0 |
154 |
|
|
excell by
dam
need help incrementing a row of inventory numbers (that are preceded by a
letter)
formula to increment U0750 to U0751..to U0850.
also another column of alias...
|
|
4 |
113 |
|
|
Specific Names by
yoly
I have a column of comments about certain Names in individual rows. I also
have a column with a list of just names. all of the names in column A are...
|
October 6th, 2009 01:53 PM
by yoly
|
2 |
123 |
|
|
|
|
3 |
234 |
|
|
format string by
Rusty
I have a string imported from a ".csv file (phone number) as follows. "=1
123-456-7890).
I need to end up with a string formated as a # as followes...
|
|
2 |
105 |
|
|
|
October 6th, 2009 01:29 PM
by JLatham
|
3 |
285 |
|
|
Count problem by
L-O[_2_]
I have one excel-file that contains some values; ABC, CBA, AAA etc.
Then I have another file which contains all of these values and more (its
actually text)....
|
|
5 |
152 |
|
|
Sheet Right Aligned by
adeel via OfficeKB.com
I have installed windows xp & ms office 2007 on my PC, I am facing the
problem that excel sheet is opening with every thing right aligned, for
example: First...
|
|
1 |
120 |
|
|
hyperlink solution requested by
driller
Dear All...
Just a few ago. I have 2 nice codes that works visually very well.
The good thing is, these Codes do not require me to go thru the
menuselection...
|
October 6th, 2009 01:07 PM
by Joel
|
1 |
141 |
|
|
|
October 6th, 2009 01:06 PM
by Angela
|
7 |
250 |
|
|
IF MID formula by
scootr
A B
1 a20
I want cell B1 to read "act" if A1 begins with an "a"
or
B1 reads "avsp" if A1 begins with an "av"
or
B1 reads "hp" if A1 begins with...
|
October 6th, 2009 12:54 PM
by scootr
|
4 |
123 |
|
|
|
October 6th, 2009 12:34 PM
by Rechie
|
4 |
118 |
|
|
|
October 6th, 2009 11:45 AM
by gonggo
|
0 |
115 |
|
|
pivot table multiple column fields by
Natalie
Hi, I have a pivot table with multiple column fields: Part number, warehouse
location, workstation location. I would like to display the fields in the
order...
|
|
3 |
125 |
|
|
Sheet Right Aligned by
adeel via OfficeKB.com
I have installed windows xp & ms office 2007 on my PC, I am facing the
problem that excel sheet is opening with every thing right aligned, for
example: First...
|
|
0 |
121 |
|
|
add notes by
reza
Hi guys....
can we add detail if we link cell...
example
Col A
1 100
2 8
now in another sheet i want to link col A1.
usually the simply way just =A1...
|
|
2 |
117 |