|
|
Macro/VB coding question by
melExcel2007
I want a macro to work for a worksheet name which will always be the same
directory and file name but the data inside worksheet will periodically
change -...
|
|
3 |
995 |
|
|
Separate AM/PM from time. by
cuartetto
In column B I have 1000 time entries with the following format. 9:30AM,
10:30PM. I would like to move the AM or Pm into a new column. I've tried
"fixed...
|
|
2 |
1,002 |
|
|
Consolidating data by
BDT
Hi,
I need to consolidate some lines of data in a 19K line spreadsheet and then
change its basic format.
I have 3 columns of data: ID# | date |...
|
|
1 |
920 |
|
|
How to set the default format on excel? by
Eric
Does anyone have any suggestions on how to set the default format on excel
2003? such as font, size, center align, whenever I open, it is all set.
Thanks in...
|
|
3 |
1,096 |
|
|
DROP DOWN LIST by
Dave
Hi
I would like to create a drop down list if names that opens when the
spreadsheet opens so people can pick theyre own individual sheets.
How can this be...
|
|
3 |
1,199 |
|
|
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,051 |
|
|
Command Button - Shrinking Font by
opieandy
I have a new 200" landscape monitor that replaced my traditional 17". The
resolution automaticallyl resized on connection and looks fine.
However, when I...
|
|
2 |
1,341 |
|
|
formula question by
tom
Hello,
I am trying to write a formula that first looksup a number and then runs a
calculation from that number. Here is a look at what I have so far:
First...
|
June 5th, 2010 12:21 AM
by tom
|
2 |
1,003 |
|
|
Macro Message Bar by
jen2018
I have set macros to be automatically disabled with a notification but the
message bar doesn't always come up. Does anyone know why this may happen and
how I...
|
|
2 |
989 |
|
|
Pick list width by
Joe M.
I have a column that is 4 wide. The data validation pick list is much wider
which is good because the pick list data is wide. I don't need the column any...
|
|
4 |
1,329 |
|
|
Convert to hrs:min by
da
hello
Is there any way to convert the following numbers to show as hrs:min without
manually insterting a colon?
e.g.15:45 ...
|
June 5th, 2010 12:50 AM
by da
|
2 |
889 |
|
|
Move rows into columns by
TR53
I have an Excel sheet that has 8000+ rows that include contact information.
I'd like to move them from all of those rows into 6 columns. Currently it...
|
|
3 |
1,023 |
|
|
Multiple Conditions with Gradients by
Kurt
Hi, I'm having some trouble with conditional formatting. I'm hoping someone
will know, is it possible to have multiple conditions for the same set of
cells...
|
June 5th, 2010 03:34 AM
by Kurt
|
0 |
933 |
|
|
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,078 |
|
|
|
June 5th, 2010 10:24 AM
by mhf
|
2 |
1,110 |
|
|
|
|
1 |
1,321 |
|
|
Excel chart - great variation in values by
Ann
I am trying to create a column or line chart where a value for 9 variables
are given for each month of the year. My problem is that the values are
mostly...
|
|
1 |
1,081 |
|
|
Copy parts of a number by
GeniE
If I have a cell with a digit 123,4567 - how can I copy the content of the
cell to another cell with only two digits after the comma. In other words - I
only...
|
|
2 |
1,118 |
|
|
|
June 5th, 2010 02:37 PM
by Correl
|
0 |
1,020 |
|
|
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,076 |