Group:  Microsoft Excel » microsoft.public.excel

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Threads Replies Last Post
326 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>  
leading representative organisation for people
My site 'home incest' (http://freehardcorevideo.org/homeincest.html)'home invasion rape' (http://freehardcorevideo.org/homeinvasionrape.html) 'incest brother and sister' (http://freehardcorevideo.org/incestbrotherandsister.html)'incest brothers' (http://freehardcorevideo.org/incestbrothers.html) 'incest cartoon' (http://freehardcorevideo.org/incestcartoon.html)'incest chat' (http://freehardcor...
1 19.08.2006 07:42:14
First login & last Logout
Hi Experts; I need to make a report of first login & Last logout time. Please help me. Sample Data:-- =========== Agent Logged In Time Logged Out Time 103134 - Verma, Naveen 8/16/2006 4:11:11 PM 8/16/2006 9:07:59 PM 103134 - Verma, Naveen 8/16/2006 9:12:20 PM 8/17/2006 12:03:36 AM 104226 - Sehgal, Rajiv 8/16/2006 4:49:48 PM 8/16/2006 5:01:16 PM 104272 - Gupta, Ruchi 8/16...
3 19.08.2006 05:19:05
Hidden source data
Hi. I wonder.... Why does my graphs go blank when I hide the cells containing the source data? Is there a way to omit this annoying occurrence? -- Hilsen Øyvind Granberg ...
3 19.08.2006 03:37:59
worksheet linkage
hi, The details is please see teh attached file, you can see on the file Worksheet B of B62, I typed 15254", it col name "yarn count" and the product code you can see is Q921 at cell A62. Worksheet A, you can see F2 is Q921, col name is "product code". Now I just plugin a vlaue B62 ='15254' and I want it shows on worksheet A - G2 but remember it must match the product code of work...
1 19.08.2006 02:54:10
number format
How can I get 1 to show up as 01 yet still be considered a number? I can only get it to show up as 01 by changing the format to text. I want a list like this: 01 01 03 04 05 06 07 08 09 10 11 12 etc, going no higher than 99 (which if that were the case I'd want 001). Thanks. ...
3 19.08.2006 02:43:01
Problem exporting workbook to HTML
Hi all I work in a call centre, and we are looking at moving towards stats and all manner of other things to a web based system. We currently export our agent statistics from servers as csv files, run some macros and end up with workbook with 32 tabs (one for each day of the month and one for the monthly totals). As we have a number of departments and managers, each sheet within the...
2 19.08.2006 01:00:46
drop down and more
I hope that someone can help me out with this. I have a worksheet that contains a list of computers and their details - serial numbers, etc. I have another workshop that contains a list of where I need to put them. I'd like to set it up, so that working on the list of computers, I have a column where I can pick from one of the locations that I need to put one, and that after it is u...
2 18.08.2006 23:50:45
numbering pages of worksheets in one workbook
Could you please let me know, in simple steps, how to number sheets like page 1 of --, 2 of --, 3 of --, etc. in a larger workbook? Remember I am not a MVP otherwise I would not ask this Thank you Aamir...
4 18.08.2006 22:36:09
Excel Only Customer Database
I am trying to help a friend build a small database of his customers. Hopefully there is a template that is already built that I can use. I'm thinking of a template that would give a defined window, for lack of a better word, that displays the pertinent customer information from another tab of data. I hope I described that clearly. Thanks in advance should you have such a template t...
1 18.08.2006 22:23:32
=3DMOde(6,6,2,2,1)_=3D_=BF6=3F
Hi, I have a problem finding the mode, If the range contains, 1,1,2,2,2 the mode is clearly 2 but if the array is 3,3,5,1,1 then there is no mode but Excel returns 3. I found this problem in Excel 2003 SP2 But not in 2002 SP3. Is there a function to replace it? Thanks. ...
4 18.08.2006 21:16:58
Removing Password protection.
I know the password to the Workbook. I need to remove the protection but, it is greyed out under Tools\Protection. I also tried to Save As\Tools\General Options but, it was greayed out there also. I do have Admn rights to this machine. Thanks in advance for your response and help....
2 18.08.2006 19:32:12
Timed macro
How can I get a specific macro I have created to do it's function every 1 minute automatically? Any help would be appreciated. ...
4 18.08.2006 19:05:52
Look, there can be somebody it is useful
Hi all! Look, there can be somebody it is useful: 'oem software store' (www.masterbell.net) - www.masterbell.net Full version software at the best possible prices - 90% OFF ! 7000+ every possible software for pc and mac! Here some examples: 'Microsoft Visual Studio 2005 Team Edition For Software Developers (1 dvd)' (http://www.masterbell.net/index.php?target=desc&progid=5360) is only...
1 18.08.2006 18:51:46
PLEASE HELP!!!!! MAcro Emergency
maybe now someone will help me?? noone has responded to my last 2 posts so I am trying to figure it out myself, am trying to build a macro and need to select RELATIVE REFERENCE before I record it, that "stop recording" toolbar was there the first time i tried to record the macro with the button to select relative reference but now every time i try to record the macro that toolbar isnt there anym...
3 18.08.2006 18:44:58
THE NAME BOX
I have been using commands/formulas where i need to specify range names farily often. It is not so burdensome that i need to download the add-in, but i am interested in anyone that know a quic command that will take you from being active in a worksheet, to being active in the "Name Box" where i can specify a range name. Anyone? jws ...
3 18.08.2006 18:06:11
protecting cell depending on value of another cell
I tend to limit data entry on my worksheets by unchecking the "Lock" box (Format Cells -> Protection -> then uncheck lock box) and then protecting the sheet (Tools -> Protection -> Protect Sheet) with only "Select unlocked cells" checked. I am creating a worksheet where some of the cells require entry only if there is a certain value in a certain cell. For example: if J3...
2 18.08.2006 17:52:12
gathering data?
I am a day trader and I look at live market data in Excel. Basically I input a stock symbol and the price is updated each time a trade goes through. What I am trying to do is this: Is there any way to capture what the highest or lowest number that came through the "price" cell? I mean I can watch it all day and record it manually, but is there any way to have another cell that will automat...
3 18.08.2006 17:51:21
Excel left click produces right click menu
Help! I've been in the industry for many years but this is a first. I have a user that when he opens a spreadsheet (blank of otherwise), and left clicks in any cell, he instantly gets a right click menu. I have replaced the mouse and mouse drivers, checked the mouse settings, looked through all the Excel options and frankly I am stumped. I am planning on reloading his Notebook, but I woul...
5 18.08.2006 17:17:45
Errors Detected In File Since SP3
We're running Office XP and recently started installing SP3. On one PC since installing SP3 when the user opens certain Excel files they receive a prompt that says errors were detected in the file. This doesn't happen with all files, just some files. If the user goes through the repair process and saves the file all is well and the error doesn't occur again for the same file. This ne...
1 18.08.2006 17:12:08
Hyperlink Macro to 2,500 PDF files?
Fellow Forum Members, I have 2,500 PDF ebooks on a variety of subjects all contained in one folder named "Ebooks". I already have all the 2,500 ebook titles inside Excel in Column A, Sheet 1. Now I want to hyperlink each title to the actual PDF file and doing this hyperlink operation 2,500 times is something I want to avoid like the plague. Can anyone out there please help me in developing a ma...
3 18.08.2006 15:51:38
Cum Shots Huge Cock Shemales Asian Girls Hand Job Tranny Bisexual
BEST DATING - 'ADULT DATING' (http://allsupergirls.info/adultdating/) Hottest XXX sites: 'Huge Cock Shemales' (http://allsupergirls.info/shemail/) 'Asian Girls' (http://allsupergirls.info/asian/) 'Hand Job' (http://allsupergirls.info/handjob/) 'Big Dick' (http://bigdick.sbn.bz) 'Cum Shots' (http://cumshot.sbn.bz) 'Tranny' (http://sex-tranny.150m.com/) 'Bisexual' (http://bisexual.freespa...
1 18.08.2006 15:22:24
Using cell value in VBA sub
I'm using the following sub Sub FindRow() Dim rngFound As Range Set rngFound = Range("A:A").Cells.Find(What:="test", _ LookIn:=xlFormulas, _ LookAt:=xlPart, _ MatchCase:=False) If rngFound Is Nothing Then MsgBox "Sorry ""test"" was not found" Else rngFou...
3 18.08.2006 14:10:00
Activating Multiple Web Links At Once
Well, noone answered my last post regarding this, maybe the planets werent aligned properly, i'll try my luck one more time: I have a list of web links in a column in excel, I do a task frequently in which I open 15 to 60 of these websites all at once, is there a way to open up each link all at once in its own web browser rather than having to click each one individually? thanks -- Ralph...
1 18.08.2006 14:02:40
Please Help
Hi Guys. I'm new here, done a lil excel work at college and along time ago now. I thought i would try and help a friend at work out, and got in a lil to deep i think. Right this is what i need if you can help. He has decided once again to do a sun dream team for us employees, this is going to entale between 15-20 (ish) teams, I thought we could have a spread sheet for each...
2 18.08.2006 13:53:58
Multiple variables
Hi all I have a large workbook containing 10 columns and 10-15000 rows. In column A I have customername and in column B I have articlenumber. I would like to make a new workbook where I put inn customername and articlenumber in C3(cutomer) and D3(article) and have the whole row returned to row 6 in my new workbook. How do I proceed?...
6 18.08.2006 13:47:53
326 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>  

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net