|
|
|
April 29th, 2010 10:44 PM
by FErd
|
0 |
227 |
|
|
Keeping the format but update the data by
JoeM
I have a report I run everyday. I want to update the data, but keep the
column sizes and formatting. Any suggestions? Anybody suggest a good ebook to
become...
|
April 29th, 2010 08:47 PM
by JoeM
|
2 |
153 |
|
|
Count Text to get a Percentage by
Craig
Hi,
I have 12 offices and each needs to do a reporting exercise.
Part of that exercise is to enter a Yes or No into a column - example would
be: 'Have you...
|
April 29th, 2010 08:00 PM
by Craig
|
4 |
174 |
|
|
date from sheet name by
JBoulton
I'd like to turn a sheet name into a date.
Apr28 to 4/28/10 (as a date)
and
Apr28-30 to Apr28-30 (as text)
TIA and thanks for any ideas.
Jim
( 1 2 3)
|
|
21 |
407 |
|
|
|
|
1 |
155 |
|
|
ActiveX from 2003 in 2007 by
Doug
Iave saved a 2003 workbook with activeX controls in 2007 as a xlm. How do I
get these controls to work in the newly saved workbook?
|
April 29th, 2010 07:17 PM
by Doug
|
0 |
152 |
|
|
SUMIF? or not? by
Scott A
Hello,
I have 3 columns, the first with a rating of 1-10 in each row, the second is
blank and the trird has a description for the rating. When someone picks...
|
April 29th, 2010 07:12 PM
by JLatham
|
1 |
163 |
|
|
|
|
1 |
150 |
|
|
Formula issue. by
LCdebaca
I am creating a formula to copy data from one cell to another and I always
get the $ in my formula. I do not want to copy the same data that is in that...
|
|
2 |
120 |
|
|
SUMIF Help by
Steve M
I want to sum the values in rows 2 to 100 in column G where the text in
columns D or E match the text in a given cell (say F3). I would like to be
able to...
|
|
3 |
169 |
|
|
|
|
1 |
150 |
|
|
Copy is criteria met by
Kitten74
I am having trouble finding a function that will copy the data in a given row
to another worksheet if one of the columns contains the word Yes.
For example...
|
|
3 |
169 |
|
|
Copy is criteria met by
Don Guillett[_2_]
Sub GETDATA()
With Sheet2.Range("a1:a200")
Set c = .Find(What:="FILE ID #", LookIn:=xlValues, LookAt:=xlPart, _
SearchOrder:=xlByRows,...
|
|
2 |
139 |
|
|
Combine an And OR function by
Woodi2
I have a little function that i need help with.
=IF(AND($B9="Z",AE9=35,J9=1),1000). This function works fine, however I
need to add in somehow that J9 could...
|
|
4 |
152 |
|
|
Excel Workbook with Multiple worksheets by
Carol
I have a workbook with 3 worksheets, 1 main (total inventory), 2 sub
worksheets.
One of the sub worksheets tracks part #, store # and qty out, the other one...
|
April 29th, 2010 05:04 PM
by Carol
|
2 |
171 |
|
|
dates on worksheets by
Ann
I want to type the date and day (05/01/2010 Sat) on my 31 sheets.
How can I type in the first day of the month and have each successive sheet
advance one day...
|
|
5 |
164 |
|
|
|
April 29th, 2010 04:25 PM
by UKMAN
|
4 |
195 |
|
|
Copy is criteria met by
Don Guillett[_2_]
Meant for another question
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett" wrote in message...
|
|
0 |
172 |
|
|
|
|
4 |
159 |
|
|
|
|
9 |
368 |