Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



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 ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us