Please Help! #6

WOW, this formula is GREAT, it saved me a lot of time, THANKS A LOT!!

samsg's Profile:
View this thread:

11/12/2004 8:14:50 AM
excel.misc 78881 articles. 5 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 52

You're welcome ! Glad it helped.
Thanks for posting back
xl 97
GMT+8, 1� 22' N 103� 45' E
xdemechanik <at>yahoo<dot>com
"samsg" <> wrote in message
> WOW, this formula is GREAT, it saved me a lot of time, THANKS A LOT!!!
> :)
> -- 
> samsg
> ------------------------------------------------------------------------
> samsg's Profile:
> View this thread:

demechanik (4694)
11/12/2004 9:38:06 AM

Similar Artilces:

CToolBar Help
Hello, I've been trying to add a toolbar to my dialog following the example from MSDN a But for some reason I just can't add the toolbar I created. Here is my code: CToolBar m_toolbar; if (!m_toolbar.Create(this, WS_CHILD | WS_VISIBLE | CBRS_TOP | CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC, IDR_TOOLBAR1)) { MessageBox("Error -1"); } m_toolbar.LoadToolBar(IDR_TOOLBAR1); Could somebody please tell what, if anything, I am doing wrong? Thank you, V...

Email Signatures #6
Hi, I have a problem which I cant resolve so I wonder if anyone can help me. I have a domain with Exchange server running and all client computers run outlook 2000. I want all users to have a personalised email signature with their name, direct phone, fax, email etc etc. I have set up a couple of users with the signature on the machine they would usually sit at using the signature picker/creator in Outlook. These users have now reported that if they work at another computer the email signature does not come up on their email. Is there any way of setting the signature on their user acc...

Outlook 2003 Messages and Calendar Appts Received as PLAIN TEXT
SGVsbG86DQoNCkkganVzdCBnb3QgYSBuZXcgbGFwdG9wIHdpdGggVmlzdGEgSG9tZSBCYXNpYyBv biBpdCBhbmQgSSBjb3BpZWQgbXkNCnBzdCBmaWxlIGZyb20gbXkgb2xkIGxhcHRvcCB0byB0aGUg bmV3IG9uZS4gRXZlcnl0aGluZyB3b3JrcyBmaW5lDQpleGNlcHQgYWxsIGUtbWFpbCBtZXNzYWdl cyBhbmQgY2FsZW5kYXIgYXBwdHMuIEkgcmVjZWl2ZWQgYXJlIGluIHBsYWluDQp0ZXh0LiBJJ3Zl IHNlYXJjaGVkIGV2ZXJ5d2hlcmUgZm9yIHRoaXMgZml4LCBidXQgZm91bmQgbm90aGluZy4gDQoN CkRvZXMgYW55b25lIGhhdmUgYW55IHN1Z2dlc3Rpb25zIGZvciBtZT8gDQoNClRoYW5rIHlvdSEN ClNwdWRkeQ0K <> wrote: > I just got a new laptop with Vista Home Basic on it and I copied my > pst file...

Office 2007 Professional: Help Files Issues
Gents, I cannot find a solution to this odd issue and before I submit a support ticket I thought I would ask the community. We have office 2007 professional (volume licensing) on a Window 2003 terminal server. We have a few users out of a bunch that get the "This page is unavailable" I have tried the Refresh and back. I've tried online and offline modes. In offline I get the table of contents to the left but same unavailable message when I click the links. I noticed on testing some other users, that apparently never used the help. That there are some prompts...

Help with Regexp, please
Hi, The regular expression (\d{15,16}) matches a substring in a cell. I want to extract the remaining part of the cell ie. from the character after the matched substring till the end of the string in the cell using a regular expression. Is it possible to do this? Thanks in advance for the help. Regards, Raj Raj, with abcd15,16xyz in a cell the code below abstracts abcxyz. Maybe you can use this as a basis to develop your code Function GetSubstring(S As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Pattern = &quo...

Spell Check Help
I have this code in the AfterUpdate in a TextBox set for a memo: If Len(Me!casefacts & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If everytime the spell check executs, it check the whole form. How can I get it to just check that one textbox and not everything else. bladelock wrote: >I have this code in the AfterUpdate in a TextBox set for a memo: > >If Len(Me!casefacts & "") > 0 Then > DoCmd.RunCommand acCmdSpelling > Else > Exit Sub >End If &...

Publisher 2007 Trial Help
I installed the trial version of Publisher 2007 and want to uninstall it now. I have tried to remove in the "add/remove" programs section. And I have also tried a suggestion I found in an earlier post about going to the "installer" and trying to uninstall it there. Oh and I tried repairing it and then trying to uninstall it. I can't even open the program from my programs menu and I can't get into the language section to check the language. It tells me that the language isn't compatible with my version or something to that effect. Nothing has worked...

Default Value on Form Help
I have a query that calculates the total of a field in my table - Field Name in my Table is Total Value which calculates the total for a series of records that has the same invoice number. Field in in my query is Aggregate Value. I now have a form where I bring in the Aggregate Value. I need to create another Text box Value Verified where I bring in the Aggregate Value as a default, but I may have to change it if the Value has changed - but the Aggregate Value has to remain the same. I tried using default value on the form for the Value Verified Text control that brings in ...

I Have an emergency... I deleted a macro !!! I have 60 rows with checkboxes on cells A1 trough A60 that automatically as checked were inserting current dates on the cell next to it. for some reason a disaster happened and the macro was deleted or messed up. I tried searching for help in these groups, but none so far. I found one, but it is not a macro besides when I use that function all the other previous dates keep changing when other checkboxes are checked on in different days of the week. If you can please guide me to the right answer I will appreciated. Hope I made sense with my explana...

Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home (Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file on a network drive I get the message: "path..filename could not be found. Check the spelling of the file name and verify that the file location is correct". Once I get the message on that file, I always get it on the file....but there might be 27 others in the same folder that I can open. And I get the message if I try to open the file via explorer or via Excel. If I copy the file to my C: drive it opens fine. I even tried t...

Sum Function Help Please
I have created two Option Groups, setting up values against the radio buttons. The output from both boxes works fine (thanks to the Wizard), however when I'm creating a formula on the report, I'm unable to add the two returned values together. If I type in =([Q1]+[Q2]) then I get both numbers concatenated together (ie returned value from Q1 is 1 and returned value from Q2 is 2, the answer I get is 12 !!!!.) Interestingly if I enter =([Q1]-[Q2]) then I get the correct answer. Any help would be greatly appreciated here. I could be wrong, but it seems like access i...

2nd request for help -PLEASE PLEASE PLEASE
went through a windows update and was asked to reboot which I did. I had Outlook open and closed it before rebooting - it was opened to contacts. when I tried to access Outlook I got an error message saying "your personal address book could not be opened. the file is either not accessible or not a personal address book. choose retry to access your personal address book, or choose cancel to not open your personal address book with this application." I have no other application to open this address book with! my contact info is detrumental to me as well as my Calendar ...

In Word How do I switch off auto date insertion please
How can I disable? ...

Remove template help task pane from startup
I created an invoice using one of Microsoft's templates. The help template appeared when I was designing the invoice. Now that the invoice is finished, I would like for the help template to NOT appear. I went to Tools-Options and unchecked "startup task pane" and also went to Tools-Customize and unchecked "Task Pane". This made the task pane go away, but only until I opened it again. Is there any way to make it not show up every time I open the document? ...

Can't SEND SSL email out!! Please Help... it HURTZ!
OKay... being a bit silly about he hurting part. I have a strange email issue with some of my computers at home that I use for work. We have 4 computers. 2 of them work FINE, the other 2 have issues. I know the email accounts are working correctly because if I run them on the 2 *good* computers they work like they should. Configurations: (GOOD Notebooks) 1 - HP AMD-XP notebook with WinXP-Home SP1, Office 2000 2 - Sony P4 Notebook with WinXP-Home SP1, Office 2000 (Bad systems) 3 - Dell P3 notebook with WinXP-Pro SP1, Office 2002 4 - Compaq AMD-XP with WinXP-Home SP2, Office 2000 ALl ma...

Help with formula #3
I need to edit this formula 2 ways =COUNT(J1:J5) first way I need it to count any cell with a value lower then 10 as 1 and any cell with a value of 10 or higher as .75 For example if cells j1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be 4.75 Second formula I need is to count J1 to J5 only the cells with a value of 10 or higher as .25 For example if cells J1 to J4 are all valued at 6 but cell J5 is value at 11 the total I get would be .25 Hi Leave Alone! First problem: =COUNTIF(J2:J6,"<10")+COUNTIF(J2:J6,">=10")*0.75 Second pro...

Please Please Please help
Hi I have a Worksheet with option buttons and I need the users to be able to click on the options but not be able to drag or move them. I don't want the users to be able to click into or type anything in any of the cells - only these options buttons???? How is it done. I have tried unlocking all cells and then locking the individual ones, but the user can still drag the option button around and they could do this by mistake thus upsetting the design of my sheet! I have tried protecting the sheet for Objects - but then I can't click on the option at all ....Please someone help...

I need help with SQL please
I have a form with a group box on it. The code for it is: 20 Select Case grpPlan.Value Case 1 30 strMon = "WorkRec" 40 Case 2 50 strMon = "IntRec" 60 Case 3 70 strMon = "FinalRec" 80 End Select After I select the one I want then the SQL is build based on the selection and a report is generated. strWhere = "EmpSuper.WorkRec=""" & strMon & _ """ or EmpSuper.IntRec=""" & strMon & _ &quo...

Help with series data
I am trying to create a sheet.. But In A1 i need to to look like this: TOTE20000 TOTE20000 TOTE20000 TOTE20000 TOTE20001 TOTE20001 TOTE20001 TOTE20001 BUT i need to keep this series up to TOTE24999 Can anyone help me with a simple solution? It wont see the pattern with TOTE infront but will with just the numbers, But when I do a Replace it starts chunkign the numbers to decimals. I appreciate any help! I have to read between the lines a bit because I'm not really clear on what you want. Let's say you want to enter 20000 in the cell, but you want it to be displayed as TOTE20000...

conditional formatting help please 07-19-07
Hello, I am having trouble using the conditional formatting. I want the background of the "End Date" to turn red when the "Start Date" is entered and then for the red background to go away after an "End Date" is entered. I used the expression ("Start Time" Is Not Null) and that made my background red but I can't seem to figure out how to get the red background go away. I tried a couple of diffrent expression like setting another condition ("End Time" Is Not Null) but it didn't work. Can some please help me find the right express...

Help with vlookup results for summary
I gotta vlookup table and on tha other worksheets people enter the info from dropdown boxes. I need to show the books sold and the average of looks at it after being chosen to be listed as a summary. A B C red book $15 x Blue book $10 x red book $20 w So if a "red book" "$15", a "blue book" "$10" and a "red book" "$20" was sold, and I want to list red book or W books, how can I display this summary info? It should look something like this so i can use the figures for sums and division. Red Book | 2 | ...

formula help #34
cell J2 has starting balance of 500,000 cell J3 has running sum from column D column D has both positive and negative entries The running sum in cell J3 is 25% of total entries in column D I need to subtract cell J3 from cell J2 but when I enter too many negative numbers the initial amount goes past 500,000 in J2. How do I keep cell J2 from going past the initial 500,000? Excel 97 SR-1 Thanks, Steve T If you're saying you don't want it to SHOW less than 500,000, then you could use something like: =IF(MYFORMULA<500,000,500,000,MYFORMULA) If you want to be ALERTED when it's ...

modify macro
Hi everyone I'm VBA dumb so please bear with me. I have a macro that inserts a row at the selection and then I want it to copy the cell below the selection and paste into the new row's cell. Here's what's in the macro now Selection.EntireRow.Inser Range("D23").Selec Selection.AutoFill Destination:=Range("D22:D23"), Type:=xlFillCop Range("D22:D23").Selec When I run the macro, a row is inserted above the cursor's location (no matter where it's placed) but the AutoFill is always to D23. My question is how do I get the cod...

Smart List Help
I am trying to create a Smartlist for receivables aging and I having some difficulty. I want to be able to see all customers with an outstanding balance and the associate the outstanding unpaid documents to the customer. I can get the aging information but I am unable to get the documents that responsible for the balance. I can get the information from I need that is displayed but I can’t get the information from “receivables transaction inquiry” window I am looking for. I want to be able to show any document with a dollar amount in the remaining amount field and only show the document...

Workbook_Open Help #2
Hello Frank, Here's the code Private Sub Workbook_Open() ' Call Unhide_Sheets ' Sheets("CONTROLPANEL").Select Range("A1").Select Call Splash End Su -- Fabl ----------------------------------------------------------------------- Fable's Profile: View this thread: Hi and there's no application.screenupdating=false statement in your unhide procedure? -- Regards Frank Kabel Frankfurt, Germany "Fable" <Fable.1d07w...