|
|
Common range name for 2 sheets by
David
Excel2000
I've been scouring the archives for what I want and all posts seem to
advise against it, but I want it!!!
I have a workbook where each sheet has a...
|
|
6 |
130 |
|
|
|
|
1 |
189 |
|
|
|
|
9 |
215 |
|
|
Shared Workbook Protection by
Mike
I need to share a workbook with several people. The workbook will contain one
worksheet where the user will be able to enter certain information....
|
|
1 |
83 |
|
|
Paste special formulas? by
mturner
I've used the paste special formulas option after copying a column.
However it is still pasting the values aswell. Anybody have any ideas
why this is...
|
|
1 |
179 |
|
|
Want to paste ASCII, not "formatted" by
KHashmi316
If I paste text *directly* into a cell, Excel formats the text to look
like the original. If I paste the text into the formula bar, the text
in the cell is...
|
|
5 |
125 |
|
|
|
|
1 |
113 |
|
|
Linking Cells with Hidden Data by
mellowe
Hi All
Just a query here.....is it possible to have a cell expand with more
data or linked to more data that can be accessed by clicking on that
Cell:
e.g...
|
January 24th, 2006 04:06 PM
by mellowe
|
2 |
70 |
|
|
nested formulas by
Ctrl-Alt-Del
I am trying to get a previously built worksheet to properly run some
formulas. We have three product types, designated "C", "P", and "M". The
worksheet has a...
|
|
3 |
90 |
|
|
Forumla to recognize text by
Woody13
I'm trying to use a basic IF THEN statement but I need the IF function to
recognize whether there is text in a cell or if its blank. =IF(cellA2 has
text,...
|
January 24th, 2006 04:17 PM
by Max
|
2 |
101 |
|
|
Drop Down Box & Macro by
A.S.
Hello,
I want to create a macro so that when I select a country from a drop down
box, then hidden data for the country appears. For example, I select
Argentina...
|
|
3 |
93 |
|
|
|
|
2 |
81 |
|
|
Automating Linear Interpolation by
smurray444
Hi there - thanks for looking,
I have a large dataset with various columns of data for global climate
(meteorological) stations, however the dataset is not...
|
|
0 |
79 |
|
|
|
|
4 |
96 |
|
|
#VALUE error with XIRR by
bdyer30
The XIRR function returns #VALUE with the following data (no guess). Excel
help says that #VALUE is returned when dates are not valid, but when I use
more...
|
|
7 |
108 |
|
|
|
|
2 |
99 |
|
|
|
|
1 |
108 |
|
|
|
|
1 |
67 |
|
|
highlighter by
jlm@yell-o-glow
Does anyone know of a tool that highlights the row, column, or both that you
are currently in?
|
|
1 |
79 |
|
|
|
|
1 |
101 |