|
|
Select and Copy data in column. by
mick
Anyone know of a way I can do the following. I have a
column (B) on my spreadsheet with a given persons name in
every other cell. eg.
Col A Col B Col...
|
|
3 |
422 |
|
|
How to Activate Open Workbook by
Dean
I have a macro using two Workbooks. I am appending the sheets from the Trans workbook to the same sheets in the Master workbook.
I open the Master workbook...
|
|
1 |
425 |
|
|
A formula pls. by
Kirandeep Singh
Hi friends,
I have two coloumns 'Reason for leaving' and respective 'date of leaving'
I want to find out which people left in which month. Like there is a...
|
July 5th, 2004 03:40 PM
by Andy B
|
7 |
245 |
|
|
Rank column with changing # of rows by
Amy
Is there a formula I can use that will Rank with changing # of rows. Currently my formula is for example : =RANK(C8,C8:C43) but when I insert rows it throws...
|
|
1 |
299 |
|
|
|
|
1 |
155 |
|
|
Multivariable regression (t-stat) by
Im trying to run a multivariable regression using excel,
and was wondering what the t-stat variable represents.
How do I use it to know if that certain...
|
|
1 |
632 |
|
|
Worksheet Protection by
Matthias Büchler
Hi,
I encountered the following problem:
If I protect a selection of cells in a worksheet the
grouping funciton doesnt work anymo
Does any body know the...
|
|
1 |
159 |
|
|
Date function help by
itty
I have order received date. I will start the order on the next coming
THURDAY always. My delivery date is 9 days from the start.
eg. Received date = 5/7/2004....
|
|
4 |
173 |
|
|
absolute hyperlinks in excel 2002+ ?? by
neowok
I have a bunch of hyperlinks in a big spreadsheet that links to some
folders on our network. This spreadsheet needs to be both on the
network and on the...
|
|
1 |
424 |
|
|
Pivot Table Problem - Excel 2000 by
Debra Dalgleish
How did you create the pivot table? Where is the source data?
Merlin wrote:
I have come across a problem using pivot tables.
After creating the pivot...
( 1 2)
|
July 5th, 2004 10:31 AM
by Merlin
|
10 |
690 |
|
|
Dependent List in Control Combo-Box by
Abdul
Can any body tell me that is it possible to create dependent lists in
Combo-boxes ?
Thanks
---
Message posted from http://www.ExcelForum.com/
|
July 5th, 2004 08:54 AM
by Abdul
|
7 |
207 |
|
|
Searching Data in Rows/Columns by
aernst
Hi
(A)
does anyone know how to search for the text content of a cell through a
column and then return the value/content of the cell of a certain other
column...
|
July 5th, 2004 08:28 AM
by Max
|
1 |
227 |
|
|
auto-insert rows? by
jacob farino
Is there any way to automatically insert a row? For example, I have a
spreadsheet that displays totals in the 40th row for all the data in the
columns above it...
|
|
1 |
175 |
|
|
|
|
4 |
572 |
|
|
Worksheet in Reverse by
Bob Vance
--
What have I done all my new worksheets now are backward A1 being the very
right now!
Thanks in advance.........Bob Vance
|
|
1 |
148 |
|
|
Problem with sort macro by
Ken G.
I have the following macro to sort a range of data: (using Excel 2002)
Selection.Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlNo, OrderCustom:=1,...
|
July 5th, 2004 03:00 AM
by Ken G.
|
2 |
352 |
|
|
kind of countif by
Micos3
Hi!
I want to make a kind of countif, to ensures me that no number is repeated in a column. i have that column numbered in sequence, so i would like that once...
( 1 2)
|
July 5th, 2004 12:30 AM
by Micos3
|
14 |
407 |
|
|
Months List: changing the case by
Mr. Tambourine
I did a months list as it is teached in the book Financial Statements,
but I can't change the case of the month title.
I mean, the date format is mmmm dd, yyyy...
|
|
2 |
146 |
|
|
|
|
3 |
446 |
|
|
duplicate names in Pivot Table by
K. Georgiadis
The more I use Excel, the more surprises I get!
I have a Pivot table based on a 16-column data list, one
of the columns being "End Uses," say, office...
|
|
3 |
255 |