Search results for query: *

Hi "Caveman 123", I have a suggestion that "might" be useful. dalewatson at mts dot net

This is from a previous posting. Hopefully it will help. SOLUTION FOR LOTUS 123-R5 FOR USE WITH WINDOWS XP I've been able to get Lotus 123-R5 working completely without any problems whatsoever - in Windows XP. Try the following steps: 1) Create a desktop shortcut for loading Lotus 123-R5...

I only have release 5.0, but in case the steps are similar to your version, try (from the menu)... Tools > SmartIcons I hope this helps, Regards, Dale Watson

Hi Michelle, Enter this formula in an adjacent column (C for example), and copy down. =IF(COUNTIF(B:B,A1),A1,"") It will test the value in column A, and if it exists anywhere in column B, it will show the value (in column C). And if the value does not exist in column B, the formula will show...

Will, Perhaps where there's a "Will", there's a Way ;-) I've been using the power of Excel's "database formulas" for some time, and can confirm that they are SUPER fast. There is a bit of a learning curve, but you might find the time investment worthwhile. Setting up database formulas is not...

Hi, Have a look at Conditional Formatting. From the menu, it's under "Format". A quick way to get rid of the colors would be to: a) format a cell with the formatting you want, b) Copy the cell c) click on the columns, d) Paste Special - Formats. This will leave your current formulas/values...

Craig, It's always good to experiment / explore by recording macros; however, you'll likely find the following useful. Please Note: If the ranges include field names, then you'll need to change the rows that reference the Header - i.e. change "Header:=xlNo" to "Header:=xlYes". From your...

Hi Skip, great to see you're still doing well. ;-) I can't see a Business Case, either; however, it's "kinda neat" to know of this. Now I'll know NOT to do something "dumb" like... bet against someone who claims they can consistently crash Excel with ONLY 4 keystrokes and a click-of-the-mouse...

Slight "assist" required ;-) ... John's instructions are close but are not really demonstrating AutoFill - because in effect only the formula gets copied. * In A1, enter 15000. * In A2, enter 30000. ( or alternatively you could type =A1+15000, hit the "Calc" key <F9> to convert to a value...

You might also want to check out faq68-1161. Regards, Dale Watson

Hi Spunky, With VBA, it should be as simple as Sub Get_Value() Dim val As Double val = [A4].Value MsgBox "Value is: " & val End Sub A preferred method, however, is to reference a cell that has been assigned a "range name". This way, if the sheet gets modified, then you don't have...

combo, Nice addition ===> STAR Regards, Dale Watson

Dee, I occasionally get an opportunity to help Skip. :-) Where Skip refers to "ButtonObject", he means for you to replace "ButtonObject" with the actual name of the button. You can identify the name of the button by right-clicking on the button, and looking in the "Name Box" (top-left-corner...

Excel's "Advanced Filter" is a powerful component that is often overlooked. One of its many "powers" is its ability to extract data - whatever data you require... by way of the criteria you specify. - AND you can easily pick WHATEVER COLUMNS you want, - AND you can place the columns in...

Hi Jaffey, This should help. I can appreciate that while the results one gets from recording a macro are helpful, there is MUCH more in-depth knowledge one needs to gain (in order to create an effective piece of code). Sub Insert_Rows() 'Inserts row every 2nd row. 'Place cursor on top row of...

Jim, For me, the easiest method of creating sheets with IDENTICAL row-heights and column-widths... 1) If different data already exists on the "destination" sheet (the one to be made the same as the "template" sheet, then copy the data to a separate (temporary) sheet - for later copying back...

I like it. I like it. ;-) Thanks Skip and John. Stars to you both. Regards, Dale Watson

Another option... =LEFT(A1,3)&MID(A1,5,3)&MID(A1,9,4) This will eliminate ANY characters, but unlike John's Substitute function, this requires that the characters to be stripped are in the SAME position. You've probably got John's formula working, but in case not, here's a (slightly) modified...

Akribie, I was "browsing" and noticed the VERY significant contributions you've been making regarding Premiere - and I feel it's also VERY important to show appreciation by awarding you a *PURPLE STAR* I hope other Tek-Tips members will begin to notice the bottom-left-corner of a contributor's...

Other options... 1) AutoFilter - useful if the users will be required to modify the data. 2) Advanced Filter - If the users will only be viewing the data, this can be used to extract data for each group to a separate sheet (at the click of a button - with VBA code attached of course). To...