General Discussion - Page 6904

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Select a random value from a column of values by Trevor someone else will give you a simpler formula, but, if not, the following will work: =INDIRECT("A"&ROUND(RAND()*(20-1)+1,0)) "Paul Gupta"...	July 19th, 2004 11:13 PM by JE McGimpsey	2	148
Formatting Columns of Percent Data by TK Is there an easy way to align percentage data that has a percentage symbol visible with percentage data that does not show a percent symbol? The proper way to...	July 19th, 2004 11:02 PM by TK	2	359
Need to suppress chart error message by Peter Bernadyne Hello, I have a workbook containing a chart with dynamic ranges and I would like to use the workbook as a template for my charting needs. This means that to...	July 19th, 2004 10:52 PM by Peter Bernadyne	2	144
Auto fill criteria/questions on filling formulas down by JAnderson I am aware of all the basic features of the fill handle- filling down, auto fill, dragging, absolute/relative references, etc. My question refers to what...	July 19th, 2004 09:45 PM by Bernie Deitrick	2	690
Excel error message - #VALUE! by jeff Hi, It seems as though either you're not entering the formula as an array formula (ctrl+shift+enter), or somewhere down the column is an invalid value...	July 19th, 2004 09:45 PM by jeff	0	96
shifting of nonblank cells by Paula Monahan I'm trying to insert a column on a worksheet. All the columns are unhidden and no cells are merged. When I try to insert the column, I get this error...	July 19th, 2004 09:12 PM by Gord Dibben	2	143
code for text to columns by Vato Loco Let's say I want a worksheet to do "text to columns" (delimited) every time it opens? For example: Text to columns, delimited, by space for column A. Thanks...	July 19th, 2004 08:50 PM by Nick Hodge	2	145
Checking of workbook open by freekrill Hi, I ithink I have read before how to do this, but I can't locate the informatioin now that I need to use it. In my code, I wish to activate a workbook...	July 19th, 2004 08:23 PM by Dick Kusleika	4	139
Help with a checkbook register by Snoogee I made a checkbook register in Excel and am wondering if there is a way I can get the ending balance to show only on the last line that has a check entered. ...	July 19th, 2004 08:17 PM by ray	2	272
save as filename by Vato Loco Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) ActiveWorkbook.SaveAs FileName:=ActiveSheet.Range("o6") End Sub I am using the above code...	July 19th, 2004 07:32 PM by Vato Loco	3	131
formula by Humbertt I'm trying to create a formula or a solution, when any text or character is typed into a cell it will equal a set value. Such as if cell A1 has a name then i...	July 19th, 2004 07:22 PM by Jason Morin	3	123
Work Breakdown Structure (WBS) by Tom Burke is anyone aware of feature in Excel like that in MS Project that enable easy creation of multi-level work breakdown structures. Project has an indent and...	July 19th, 2004 06:53 PM by Ken Wright	1	138
Summarizing data from one worksheet to another by Scott Lyon This is (hopefully) an easy question (with an easy answer), but I'm not having much luck figuring it out on my own. I've got a workbook that consists of two...	July 19th, 2004 06:16 PM by Domenic	3	226
Filtering of prescription rows (records?) for Excel 2000 by GBL Hi: I have been keeping prescription rows (records?) data on Excel 2000 with several fields of worksheet data, one of which is a depletion date (the...	July 19th, 2004 05:52 PM by BarryB	3	309
formula by Kirandeep Singh Hi Group, Need your help. I have these coloumns: Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed Level GENDER LOCATION	July 19th, 2004 05:46 PM by Peter Atherton	1	117
arrow keys changed function by tim A few days ago I noticed that the arrow keys in excel no longer move me from one cell to another but now they scroll the current window. If I am in cell A1 and...	July 19th, 2004 05:46 PM by	3	354
Change to upper caseUpper case by Jim C Is there a quck way to change all lower case text to upper case TIA Jim C	July 19th, 2004 05:32 PM by Ron de Bruin	2	288
Install Report Manager add-in by Creator How do I instal the Report Manager add-in for Office 2003? I don't see it on the list of available add-ins on the install CD. -- Creator	July 19th, 2004 05:17 PM by Ron de Bruin	2	206
formula/s by Kirandeep Singh Hi Group, Need your help. I have these coloumns: Employee Code Name Status Position DOJ DOL Tenure Reason of Leaving Ed Level GENDER LOCATION	July 19th, 2004 05:15 PM by Frank Kabel	2	102
Current Printer is Unavailable by Chris Smith Office XP, SP3, running on Windows 2000 Server through a terminal services session. Everything worked fine until Friday, and now users cannot print from...	July 19th, 2004 05:03 PM by Chris Smith	0	508

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed