|
Updating Data from Access
If I create a standard pivot table with specific parameters to pull
information from Microsoft Access can it be updated without any
additional manipulation?
...
|
2 |
15.09.2006 21:41:44 |
|
|
transfer data
Please help
How can I transfer (automaticly) data form one cell to another cell. That
other cell contains no formula or what so ever.
e.g. cell A1 is empty, and cell G6 contains the value 12345. How can I send
this value to cell A1 from cell G6 or any other cell.
Thanks,
Joop
--------------------------------------------------------------------------------
Mijn Postvak In wordt besc...
|
6 |
15.09.2006 21:36:08 |
|
|
numbers are not numbers in excel xp
I m sure this is obvious question, but I have been fighting long enough.
On excel xp, after choosing a group of cells, columns, or rows then
Format~Cells~category~NUMBER.
then each number added to each cell, it says number in cell is formatted as
text, bla bla and I need to click 2 times to convert it. Each and every
number that I enter in a cell needs me to do this before I can do my ...
|
6 |
15.09.2006 21:25:29 |
|
|
Excel 2003 calculation problem
Dear all,
version : excel 2003
I just want to a simple minus calculation for all cells in column C using
the formula A1-B2. After that , some of my cells content in column C differ
many decimal places.For example , if A1 = 0.1 , B1 = 0.05 , then after
A1-B1 , C1 = 0.0499999999999998 . I want C1 to be exactly 0.05 , what can I
do ??
Thanks !!
...
|
4 |
15.09.2006 21:22:01 |
|
|
Excel opens gibberish on startup -- Please Help
Hello,
I am running excel 2002 on a client machine in a domain environment. When
ever I open excel, it automatically opens several workbooks full of junk
text, one of which looks like an old backup listing of my IE favorites. I
don't know this happens, I've tried restalling the entire office suite and
then running office updates again with no change. However, if I log in as a
differen...
|
2 |
15.09.2006 20:13:53 |
|
|
Nested IF-statements
Hi group,
Sinve years I use nested IF-statements in Excel. But I have always had
this suspicion that I go about building them in the wrong way.
Generally I use the function wizard.
First of all I want to take out all zeros that would indicate an empty
cell, before I get into any serious stuff. Doing that I kind of do it
backwards, including a lot of copying and pasting, using notepad as ...
|
4 |
15.09.2006 14:20:55 |
|
|
Help with ComboBox
Hi,
I'm using Excel 2003
I have a spreadsheet using a ComboBox that allows selection of one of
several sets of data. Each set is a 3 column row of data. I have the
following properties set:
BoundColumn: 2
TextColumn: 1
When a selection is made the ComboBox displays the column 1 value.
The ComboBox seems to behave normally, except that when I close and open the
file the ...
|
4 |
15.09.2006 14:02:04 |
|
|
Finding all Combinations...
Hello all...
I have a set of data set up like this...
Column A: 1-10
Column B: 1-4
Column C: 1-6
I would like to have excel calculate and put every possible combination into
a separate cell for me.
So that it look like this... 1 1 1, 1 1 2, 1 1 3,.........8 2 1,.....etc.
Is this possible?
Any and all help greatly appreciated!
Thanks,
Shhhh
...
|
2 |
15.09.2006 12:51:02 |
|
|
From Access Query to Excel and Open the File
Originally I posted this in the Access Forum and was told doing it this
way will not work.
Does anyone on this side know how to do this??
See Original Post below:
Thanks,
Hans
I have imported the query into Excel and able to save it, but I have
people that complained about having to find the file somewhere....
How would I run this query and NOT save to My Documents, but create a
n...
|
3 |
15.09.2006 11:39:01 |
|
|
Finding a future date
I need to find the date when several events occur forward from today.
Typical would be the Wednesday in the second week of next May.
Given:
A1 = 2 (second week of the month)
A2 = 4 (fourth day of the week when Sunday = 1)
A3 = 5 (the fifth month - May)
Can you help me with the formula in A4?
I just cannot see it yet!
...
|
13 |
15.09.2006 10:12:10 |
|
|
Sort Alphabetically
I have six columns of entries. Each column of entries has several headings.
Under each heading the entries are sorted alphabetically but not the
headings themselves.
All is fine except for one list of entries that will not sort correctly.
Whatever I do it will insist on beginning with 'W' then F, I, K, P, S, T and
W again. The column then goes to "B" and lists correctly from there dow...
|
3 |
15.09.2006 08:41:27 |
|
|
Stopping spreadsheet save
Hi
We have a spreadsheet that we share among users by keeping it on a shared
location on server. The problem is that we want everyone to be able to
modify the sheet but we want to stop users making copies of the sheet to
avoid versioning issues. Is there a way to do that?
Thanks
Regards
...
|
3 |
15.09.2006 08:19:11 |
|
|
Assign Values to String Value
Hello,
I am trying to assign a numeric value to cells with string/text variables.
For instance, 10-2 would signify 4 hours... so the value I would like to
calculate would be 4. Is there an easy way to do this?
Thanks...
|
2 |
15.09.2006 01:43:01 |
|
|
Conditional Formatting with Arrays
Hi, I have a question regarding arrays and conditional formatting. I
have two columns. One is my master list which contains the numbers that
I need. The other column has numbers that may or may not be inclunded
in the Master list. Is there a way I can create a new column that would
return the number in Column B the color black if it is in the master
list and red if it isn't? Below is an exa...
|
3 |
15.09.2006 01:36:01 |
|
|
Consolidating Rows based on Cell Numbers
I have rows cells that I need to consolidate to another page by a
reference number found within the list. For example:
Sheet 1
A B C D E
Description Invoice Number Code Amount Date
Purchase 1 xxx 15000 $4.00 8/2/2006
Purchase 2 xxx 15001 $ 5.00 3/5/2005
Purchase...
|
6 |
15.09.2006 01:07:01 |
|
|
Using VLOOKUP to display required information
This is a multi-part message in MIME format.
------=_NextPart_000_000C_01C6D81E.1375E5F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hey all,
I'm trying to create a spreadsheet that references an existing Excel =
file that contains data in the following format:
Supervisor Name Email Phone #
Bob Joe a@b.com 555...
|
2 |
15.09.2006 00:55:36 |
|
|
Pivot Tables: Locking Certain Features
I'm looking for a way to prevent users from both adjusting pivot
filters or refreshing the pivot. Does anyone know a way to lock these
features, but still alllow users to move/add/remove fields from the
table or select data within the fields?
Help would be greatly appreciated.
...
|
2 |
14.09.2006 23:30:09 |
|
|
Using formulas for pivot table
I know you have the count field but is there away to input a formula?
For example customer ordered 25 cases and each case weighs 4 lbs and
the end result would need to be total pounds ordered.
Thanks!
...
|
2 |
14.09.2006 23:28:34 |
|
|
conditional formatting question
hello,
I have a list of prices from 2 stores with same part numbers.
I'd like to format the spreadsheet so if the part price from store 1 is
higher than store 2 - make that cell Blue.
The lower price (either store 1 or 2) should be Red.
I've tried this several times but the colors don't change.
I'm using the conditional formatting wizard under the Tools menu.
What am I missing?
...
|
2 |
14.09.2006 23:27:13 |
|
|
Pivottable with mulyiple input ranges
Is anyone familiar with the fact that creating a Pivottable with mulyiple
input ranges in Excel 2003 leads to a crash of the program?
Who has suggestions on how to solve this crash?
Ron...
|
2 |
14.09.2006 23:25:52 |
|
|
Wrap text and templates
I created a template that had some columns with wrap text turned on.
When I save the document as a template and tried to enter data in
worksheets based on the template, the row height would not change to
show all of the text. Even though I turned on wrap text again
(formatting palette, alignment&spacing, wrap text) and changed cells to
general again, the text would not show. The text wrappe...
|
4 |
14.09.2006 23:24:43 |
|
|
Excel 2003 100% CPU Usage
Hi,
I just upgraded a machine from Excel 2k2 to Excel 2k3. When trying to
open a 6.00 MB spreadsheet my system CPU goes up to 98% to 100%. The
system is still responsive to non-Excel related tasks (albeit very
slow) but Excel is hung and becomes non-responsive. The spreadhsheet
works fine in Excel 2k2. The issue can be repeated on any machine with
Excel 2003.
Any ideas on why this is ha...
|
1 |
14.09.2006 22:57:41 |
|
|
Analyze Survey Questions
Hi Folks - I need to provide counts and percentages of survey data. If
Question 1 has 5 possible answers (1,2,3,4,5), then i need to count how many
1's, 2's, etc., plus calculate the percentage of the counts to the total
number of answers.
The data looks like this:
Q1 Q2 Q3 ...... etc.
1 2 5
2 3 2
5 1 4
etc.
In the past, ...
|
4 |
14.09.2006 22:05:35 |
|
|
Find and Replace
Hi Folks - I have a range of cells that contain a single "character". The
character can be a digit or letter. I would like to prefix the contents of
each cell with the word "department,", so that a cell containing a 5 would
be replaced with department,5. Can this be done with Find and Replace?
Thanks.
Michael
...
|
8 |
14.09.2006 20:01:58 |
|
|
Merging Excel and Word Data
I have two documents I'm using,
one is an audit report recording form - its a spreadsheet containing
marks, comments and basic informatio n - this form is used by auditors
who are performing the audit via laptop. Within this is lots of
calculated fields.
the other is a word template which is our audit report which is sent to
unit managers. It contains an overview of scores and comments b...
|
1 |
14.09.2006 18:49:12 |