selecting different columns
Thu, 25 Feb 2010 14:53:01 -0800
I want to do a select case that picks a specific column based on another,
independent variable. Something like:
select case colno
case1
if a=1 then colno="C" (Select column C)
if a=2 then colno="M", etc.
Then I want to do a range select, such as range(2,colno).select, or
range("colno,2").select, or someth ...
|
selecting different columns
Thu, 25 Feb 2010 14:44:01 -0800
--
Bill Roberts ...
|
Search and find test
Thu, 25 Feb 2010 16:12:29 -0500
I want to find all cells that contain whatever text I am searching for.
Ctrl+F will do this and display everything it finds in a separate window.
What I would like to do is have all of the cells and contents in the row
displayed that the search finds.
. ...
|
Querying Excel tables from Microsoft Query
Thu, 25 Feb 2010 10:46:01 -0800
Apologies if this posts twice. Since my posting hasn't shown up in 5 hours,
I'm assuming it got lost.
I cannot query a Microsoft Excel workbook with Microsoft Query.
The error message I get is "the data source contains no visible tables".
But the workbook that I am trying to query contains two named tables.
...
|
Sub Totals as a calculated field in a pivot table
Thu, 25 Feb 2010 08:11:02 -0800
I have a pivot table that pulls revenues product line and displays in
monthly columns.
Can I create a subtotal that displays quarterly data as a calculated field?
In another pivot table I have revenues and costs associated with a variety
of projects. Is there a way to subtotal the costs separately from ...
|
Evaluating 3 Excel Sheets
Thu, 25 Feb 2010 15:41:36 +0100
Hi newsgroup
I have a excel file which has 3 sheets. This 3 sheets are feeded with data
of a database.
In the first Sheet i have data from a table 'questions'. This table has a
ID.
in the second sheet i have data from a table 'candidate'. This table has an
id too.
in the third sheet i have data from ...
|
Calculation & Negative Help
Wed, 24 Feb 2010 21:10:54 -0000
Hi All,
Please can someone check my maths below & calculations as it doesnt look
right!
Im looking in particular at the -100.00
The idea of this little table, shows how much debit & credit you have had,
and against a target, with a variance %
it should be that a negative number is bad, positive good. ...
|
|
|
VBA Help
Tue, 23 Feb 2010 19:06:23 -0800 (PST)
Hello.
I can do this with formulas, but I am getting wrapped around the
syntax for the code which I use with a macro button.
If D11 = "Yes" and D13 = "Same", then if the text in D14 is not equal
to the text in D9, put up a messagebox that says "D14 cannot equal D9.
Please fix, then try again." and stop the ...
|
Excel 2007 Macro/VB Question DDE Question
Tue, 23 Feb 2010 18:38:01 -0800
Hi,
So I have a column of cells that are the combination of a other cells in
the row and a result of a few "if functions." The value comes out exactly as
planned however in order for the data to be sent to the DDE server I need to
press F2, go the beginning of the cell to insert an "=" sign and then pres ...
|
Fixed width
Tue, 23 Feb 2010 17:03:01 -0800
When using Text-To-Columns, Excel "recognizes" that the data fits the Fixed
Width criteria and PRE-assigns the width.
In most of the cases I work with Excel is wrong 99% of the time.
Is there a way to force Excel to NOT pre-assign the width (leave everything
blank)?
The data I would like to parse is in the fo ...
|
