|
|
|
|
5 |
1,108 |
|
|
Consolidating data by
Don Guillett[_2_]
Sent OP this
Option Explicit
Sub SAS_MakeTable()
Dim lr As Long
Dim c As Range
Dim mm As Double
Dim mr As Long
Dim mc As Double
|
|
0 |
1,108 |
|
|
wpexcel by
questions123
when i open excel. WPEXCEL opens up first. How do I stop that from happening?
Thanks
|
|
3 |
1,108 |
|
|
Macro to hide rows by
markstro
I have a certified payroll spreadsheet in which I want to display only
the employees that have pay data entered that week.
I often unhide all rows, enter data,...
( 1 2)
|
|
14 |
1,107 |
|
|
How to determine the values? by
Eric
Does anyone have any suggestions on how to determine the value?
For example,
Under following columns:
1 174 198 222
7 180 204 228
9 182 206 230
A given...
|
|
1 |
1,106 |
|
|
Formula omits adjacent cells by
Ali
Hi there
I have a spreadsheet with a SUM formula in Column k. Example K3 formula is
=Sum(D3:I3)
I clicked and dragged this formula all the way down to K...
|
March 22nd, 2009 06:19 AM
by Ali
|
2 |
1,102 |
|
|
Copying Interest formula to 214 cells. by
BradP
I am doing a project for work and need to copy a interest formula to the
next 214 months (Ipmt function). Ii am receiving an error when I try to
fill the...
|
|
4 |
1,102 |
|
|
Finding duplicate names by
Matt in AZ
Thanks. That worked great!
--
Matt in AZ
"Max" wrote:
Try this ..
Assuming the data in cols A and B are in row1 down
|
June 14th, 2004 08:18 PM
by Max
|
1 |
1,100 |
|
|
Excel printing by
dj[_3_]
In Quattro Pro I was able to print a selection of data from several
sheets just by selecting the area in each sheet. Quattro Pro would
then put all the...
|
|
6 |
1,099 |
|
|
Group Dates from SQL Query by
wjvii
I have the results of a SQL datasource providing the data for a pivot table.
Several of the fields are dates however I cannot group them like they were...
|
|
1 |
1,096 |
|
|
Text Qualifiers by
Wavequation
I imported a tab-delimited text file, with quotation marks as the text
qualifiers. Excel removed the marks, and now I need to save the file back as
text,...
|
|
1 |
1,092 |
|
|
How to disable or remove Save button. by
jdtivoli
Is it possible to disable the Save button automatically on the Excel
toolbar only when a particular workbook is opened?
I have problems with my forms being...
|
|
3 |
1,092 |
|
|
Evitar digitação de dados duplicados by
Lindomar
Como fazer para evitar a digitação de dados duplicados nas células de uma
coluna do Excel. Ou fazer com que o excel me informe que já exite uma célula...
|
|
0 |
1,086 |
|
|
|
|
1 |
1,086 |
|
|
Sorting a list of numbers by
BRB
I have inherited an excel file with numbers across 100 columns and over 300
rows with several blank cells (likely 15%). I would like to format these
numbers...
|
|
3 |
1,081 |
|
|
|
April 19th, 2005 02:33 PM
by JoD317
|
6 |
1,071 |
|
|
Vlookup and Hlookup help by
Nikki
I have a situation where I need to lookup Product A but then lookup Company A
in a column that changes.
vlookup("Product A",A1:T25,hlookup("Company...
|
June 4th, 2010 04:43 PM
by FloMM2
|
3 |
1,068 |
|
|
|
June 4th, 2010 08:13 PM
by Vicki
|
2 |
1,066 |
|
|
Sorting a list of numbers by
Don Guillett[_2_]
Option Explicit
Sub SASLineEmUP()
Dim lr As Long
Dim i As Long
Dim lc As Long
Application.ScreenUpdating = False
Columns(1).Clear
lr = Cells.Find("*",...
|
|
0 |
1,066 |
|
|
|
|
1 |
1,064 |