|
Linked Cells on Separate Worksheets
I have two worksheets. One worksheet is my "template" and the other is a
worksheet that I have cells linked to cells in my template.
I would like to sort my "template" worksheet while keeping my cells linked
correctly in my second worksheet.
Example:
Worksheet Template.
Column A
Hat
Dog
Cat
Coat
Worksheet #2 - Linked to the above
Hat
Dog
Cat
Coat
I want to sort Worksh...
|
1 |
25.09.2006 21:34:02 |
|
|
Elimintae wierd charecters
I have the following list, with spaces, charecters and numbers:
12345
54784 N01
121545 N02
..451452
How would I be able to pul the list in two columns? without any weird
charecters?
12345
54784 N01
121545 N02
451452
...
|
2 |
25.09.2006 21:24:01 |
|
|
Find and Copy
Good Morning,
I have a list of over 2000 items with several columns per entry. I was able
to use the 'find' function to find entries with a specific word in them and
where they were within the list but now I'd like to isolate those item, copy
them and place them in a separate sheet. Is there anyway to do this easily?
Thanks!
Carol...
|
5 |
25.09.2006 21:09:20 |
|
|
how can I set up a custom filter to ignore the last few digits
trying to screen out the last 4 digits of a telephone number...
|
3 |
25.09.2006 21:06:01 |
|
|
Highlighting fields while in edit mode of formula
Is there any way to change the format (i.e. shaded) of the fields that are
highlighted when you are in edit mode of a formula that references those
fields?...
|
1 |
25.09.2006 20:51:02 |
|
|
Adding actual Cells
Hello! I would like to add actual cells, and not their values...
example :
in $A$1 I have 1
in $A$2 I have 1
in $C$1 I would like to write an equivalent to this :
=$A$(1+1)
OR, can I replace the A or 1 of my $A$1 with a variable to be able to
retrieve certain info?
For example :
$A$1 = 1
$B$1 = Company name
$B$2 = Address
$B$3 = Phone number
then in another sheet, I use a p...
|
2 |
25.09.2006 20:45:47 |
|
|
how do i put bullets side by side?
how do I put bullets side by side
...
|
3 |
25.09.2006 20:38:01 |
|
|
Hide zero values in a PivotTable report
How do I hide zero values in a PivotTable report. It didn't work what was
suggested under the Office site....
|
2 |
25.09.2006 20:32:21 |
|
|
Release Memory
Hi,
I have a macro, and it uses an array that is pretty big Array(7000,361,26)
So if I call the macro that uses this array over and over, is there any way
to "erase" the array so the memory is used more efficiently and the macro
runs faster? Like a clear memory command?
Thanks...
|
2 |
25.09.2006 20:28:56 |
|
|
how to make a bar chart
I have a column on my excel file that has ages of different people. I
would like to make a bar chart that gives me the no. of persons on the
Y axis, and different age-groups on the X-axis(for example 30-40,
40-50....)
Any help would be appreciated.
Thanks in advance.
Roohbir
...
|
10 |
25.09.2006 20:21:56 |
|
|
How do I print an Excel spreadsheet on a plotter?
...
|
1 |
25.09.2006 20:21:01 |
|
|
Create Dialogue Box
This is what I want to accomplish but I do not know how. I am new at this.
In cells D-I, I want to be able to click on the cell and bring up a dialogue
box that consists of a list of checkboxes, which I can check off as
completed, tasks if you will. I would also like the option of a comments box
as a part of this dialogue box.
If you can understand at all what I am trying to get at, ...
|
1 |
25.09.2006 20:15:02 |
|
|
How to Switch between different work sheets Randomly
If i want to Open Specific Work Sheet without using CTRL+Page Down or
CTRL+Page Up, how to do that? since if i use CTRL+Page Down or CTRL+Page Up i
should move in Sequential Order, i want to know how to Open work sheet in
Random Order...
|
3 |
25.09.2006 20:12:17 |
|
|
V lookup in separate TABS!
hi,
can anyone tell me how to count the number of times an item "i.e no, yes,
maybe" appears in a column, but the catch is how do I do it when they're on
separate sheets? The counted number is displayed in a different tab than the
values counted. Is it a v-lookup, but how do i control which tab to look in?
THANKS! ...
|
2 |
25.09.2006 20:12:02 |
|
|
I get a comma instead of a decimal why ?
I believe this is an old version of exexl
It has been working fine untill today.
When you type 19.5 you get 19,5
it will not change no matter the number format
...
|
3 |
25.09.2006 20:08:58 |
|
|
Custom Field label
How can I enter a formula in a cell, but but a custom text label be displayed
in the cell instead of the value of the formula?
Thanks...
|
9 |
25.09.2006 19:58:02 |
|
|
New Worksheet
Is it possible to have sub-sheets?
I would like to have five main worksheets, and then worksheets under them....
|
4 |
25.09.2006 19:48:01 |
|
|
how pdf picture appears when copying and pasting one sheet to anot
How come a picture of pdf icon apperas when a user copy information from one
excel sheet to another...
|
1 |
25.09.2006 19:44:02 |
|
|
how do i eliminate leading 0 in a text cell
I have ID numbers that are alpha numeric. Some are all numeric formatted as
text, others are actual alpha numeric combinations. Most all have leading
"0s". I want to easily eliminate them....
|
3 |
25.09.2006 19:43:01 |
|
|
Translation/formula.
Hey.
I'm having some trouble with my excel. I have lines such as this:
4Nm 24V AC/DC 2/3 PKT. IP55 90 sek
I need to change the "sek" into "sec" so that it is the only element in the
sentence being changed (i.e. if I later on copy-paste, the "sek" will always
be changed into "sec", while the remainder of the sentence may or may not
change). Is there a formula that will do this?
Bes...
|
7 |
25.09.2006 19:34:02 |
|
|
CountIF
I am trying to count a range of cells with multiple conditions. I know
CountIf will not allow two conditions; however, I am trying to count cells
with numbers in cells D2:d23 >9 and <20.
Please help!
...
|
12 |
25.09.2006 19:03:02 |
|
|
?
I have a list that have numbers:
12345
54784 N01
121545 N02
..451452
How would I be able to pul the list in two columns? without any weird
charecters?
12345
54784 N01
121545 N02
451452
Thanks...
|
1 |
25.09.2006 18:49:02 |
|
|
Formula doesn't find last entry
This is the formula.
=IF(ISERROR(INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:2)))),"
",INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:1))))
This is on Worksheet "Monthly log" and the data is on "Log".
Q1 is the beginning of the month and Q2 is t...
|
4 |
25.09.2006 18:34:35 |
|
|
file save error: the file or directory cannot be created
When I try to revise and save an excel file that is on a flash drive, I get
an error message that says "the file or directory cannot be created."...
|
2 |
25.09.2006 18:07:54 |
|
|
Display n x n array
Hi,
Iwant to take an array and put the values into excel, i tried this but it
doesn't seem to work:
For i = 1 To 3
For j = 1 To 3
t3(i, j) = Rnd
Next j
Next i
Sheets("Sheets2").Range("A2:C4").Value
=Application.WorksheetFunction.Transpose(t3)
Does anyone know how to fix this?
Thanks for your help.
...
|
3 |
25.09.2006 18:06:01 |