|
|
Resize columns wider for pick list by
Joe M.
I have some code that widens certain colums when clicked upon so I can see
the pick list entire width but don't need the column to stay that width after...
|
|
5 |
289 |
|
|
Conditional Format by
Pass-the-Reality
I need a conditional format formula that says if D1 = "N" than cells B1&C1
should be gray. What should I type in the conditional format statement?
|
May 11th, 2010 02:47 PM
by Max
|
1 |
254 |
|
|
Locking a file by
MD
Is there a way to lock a file so that it can not be copied?
|
May 11th, 2010 02:40 PM
by MD
|
4 |
215 |
|
|
Excel 2003 VBA problem by
BJ&theBear
Never used R1C1 notation before and I;m not certain that I understand
it.
The routine below posts a copy of "ProjectID" to the next available
line but am...
|
|
4 |
290 |
|
|
|
May 11th, 2010 12:13 PM
by Mike H
|
1 |
319 |
|
|
adding to lines by
balurrpr
Hi,
i am getting an output with two rows like -
Item Description Category
2300798-2 1.5T HEAD/BODY
Receipt Receipt
Date Number
|
|
0 |
224 |
|
|
|
|
1 |
288 |
|
|
|
|
6 |
321 |
|
|
|
|
1 |
236 |
|
|
Eureka!! by
berticus
Works very well, works on Excel 2007 (XLSX) spreadsheets as well!
|
|
0 |
167 |
|
|
Need to populate data from different sheet. by
Joe Spindola
I have a drop down list of branch names in one sheet. The source sheet
(separate one) contains the values of this list and addresses and contact
information,...
|
|
1 |
206 |
|
|
Conditonal formatting problem! by
chrissy2391
Here is what I have:
Ideal Variance Minimum Maximum Actual
5 2 3 7 8
0.00375 0.0025 0.00125 0.00625 0.00725
6 2 4 8 3
The numbers in the Ideal, Variance &...
|
|
1 |
181 |
|
|
|
|
2 |
252 |
|
|
small type when printed by
kmonhoff
My worksheet is compressed to really tiny print when I print it to a printer
or pdf Create. Only one tab is small print. I can not see anything in page...
|
|
2 |
209 |
|
|
Industrial Time look up sheet by
Pepino
Hello,
I am trying to create a time lookup sheet where at the cross point of Start
and End time the result is shown in 100 of an hour. So Row 1 has the start...
|
|
1 |
216 |
|
|
|
|
1 |
281 |
|
|
date sorting by
rcc
When I try sorting a column of dates, excel puts (for example) 06/2000 first
and then 01/2001 next. It obviously makes sense that it would do that, but
what...
|
|
4 |
190 |
|
|
Formula Help by
Peter
I need to have a cell reference another cell if it meets within a certain
time period, So in this case I will use 18:05 as the time.
=if(M5=U2,R5,...
|
May 10th, 2010 10:45 PM
by Peter
|
4 |
197 |
|
|
|
|
2 |
277 |
|
|
Sum Vlookup where there are blanks by
KneeDown2Up
Hi
Excel 2002 sp3.
I have a sheet which has 7 tables (one per day of the week) in which a
number of members of staff are listed. Not all the staff are in...
|
|
2 |
253 |