|
|
Populate table based on criteria by
Kam
Hi,
First of all thanks a ton for all help in the past. I need again help on
some excel macro, which can Populate table from Data for selected customer...
|
December 8th, 2009 03:57 PM
by Kam
|
1 |
98 |
|
|
choose last cell with a value in a column by
jcheko
need to figure a function that identifies the last cell with a value (could
be a number or a letter) in a column....I will be updating this every other
day,...
|
|
6 |
110 |
|
|
Displaying data using a variable by
Maracay
Hi Guys,
I have stored in a variable (TXTFNAME) the name of field’s table, the table
is call BasicData and the field is call FNAME, I need to display the...
|
|
1 |
128 |
|
|
inserting datestamps by
Shane Sauter
I have a cell that changes from "In Process" to "Completed" once a series of
tasks have been completed in the worksheet. Once that cell changes to...
|
|
1 |
151 |
|
|
Colour One cell with two colors by
Muffi Zainu
I want to know how to :
1. Colour One cell with two colours… the top half in one, and the bottom in
another
|
|
2 |
90 |
|
|
Transpose Microsoft Query by
tmacdonald
I need to transpose some data that I bring in via a microsoft query, however
when I do the copy and special paste it works properly the first time,
whenever...
|
|
2 |
121 |
|
|
VB macro using in SAP by
Kanagam, Nagarajan
Dears,
If is possible to Excel VB macro using in SAP?
I need put macro in SAP(i.e., that macro inputs put automaticaly in SAP
fields and get output to...
|
December 8th, 2009 02:54 PM
by Bob I
|
1 |
226 |
|
|
|
|
3 |
101 |
|
|
Set values in an Array by
jlclyde
Is there a way to load an array with data from a worksheet? Here is
the code I have.
ActiveSheet.ListObjects("List12559").Range.AutoFilter...
|
|
9 |
136 |
|
|
|
|
0 |
107 |
|
|
|
December 8th, 2009 02:20 PM
by JLatham
|
2 |
90 |
|
|
Excel formula - Anyone up for a challenge? by
NEHicks
I need to provide the percentage by hour per month of hospital discharges.
Discharge data is kept by date then by hour of discharge. Each day could
have 1...
|
|
6 |
133 |
|
|
adding arrows by
SageOne
I have an IF function that determines if one cell is greater than another
cell.....is there a way to display and up or down arrow as the result of an
IF...
|
|
3 |
109 |
|
|
to find diffrence in time by
pol[_2_]
Hi all,
Please anybody can help me to write a general function that can be used in
excel as well as outside excel. I have the following information
opening...
|
|
3 |
94 |
|
|
|
|
0 |
103 |
|
|
|
|
1 |
90 |
|
|
What wrong with sumproduct function? by
Eric
I would like to sum all numbers, which match following conditions,
=SUMPRODUCT(($B$1816:$B$2400=$A2402),(C$1816:C$24000),(C$1816:C$2400))
press ctrl + shift...
|
|
4 |
97 |
|
|
Dates in different formats by
David Biddulph
If the dates are in A1 and B1 respectively, the formula is
=DATEDIF(A1,DATE(LEFT(B1,4),1,0)+RIGHT(B1,3),"m")
--
David Biddulph
"GARY"...
|
|
0 |
87 |
|
|
Macro problem by
The Message
I have had someone write me a macro as below. This basically copies the top
10 numbered rows from Sheet 1 and pastes into Sheet 3. However it pastes the
rows...
|
|
2 |
89 |
|
|
Errors in Excel 2007 Calculation by
Mike Tan
Hi,
I'm having problems with Excel 2007
When I total up a number of cells, the value that is shown is 0. For
instance, totalling G3+j3+N3, I get 0. The...
|
|
4 |
109 |