Re: $$Excel-Macros$$ Removing or extracting lettres from List in Excel

I think your solution is best. On Wed, Dec 23, 2009 at 3:18 PM, Dilip Pandey wrote: > Dear Gobet, > > Use following formula in the column B and drag it down. > > =RIGHT(A2,LEN(A2)-FIND("@",A2)+1) > > solved workbook is also attached. Thanks > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA

Re: $$Excel-Macros$$ Help on Graph

have hidden column to calculate min & max. refer attachment On Wed, Oct 27, 2010 at 9:12 AM, Shrinivas Shevde wrote: > Dear Remy > Can u attached a file? > Shrinivas > > On Tue, Oct 26, 2010 at 7:09 PM, RemyMaza wrote: > >> That's interesting. I cleared the contents of the cell and the >> form

Re: $$Excel-Macros$$ Help on Graph

Dear Remy Can u attached a file? Shrinivas On Tue, Oct 26, 2010 at 7:09 PM, RemyMaza wrote: > That's interesting. I cleared the contents of the cell and the > formulae began to work. > What exactly do you mean: "It doesn't work?" > > Matt > > On Oct 26, 5:08 am, Shrinivas Shevde wrote: > > Dea

$$Excel-Macros$$ Populating ComboBox using a named range on another worksheet.

I have a workbook ("Access List") comprised of two worksheets ("Access List" and "Info"). I've got a UserForm ("AddNewUser) setup to insert information provided into the sheet "Access List". This is working just fine. I'm having issues populating the several ComboBoxes ("CMB_Area" and "CMB_Role"

$$Excel-Macros$$ Re: New Member

Im glad you joined On Oct 26, 2:47 pm, Ted wrote: > Hi, just joined the group to take a look at what I could learn. I'll > be posting any questions I have shortly. -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ Fwd: Practice

try: Private Sub CommandButton1_Click() Dim item, rng As Excel.Range For item = 0 To ListBox1.ListCount - 1 If Me.ListBox1.Selected(item) = True Then Set rng = Sheet2.Range("A" & Rows.Count). _ End(xlUp).Offset(1, 0) rng.Value = Me.ListBox1.List(item, 0) rng

Re: $$Excel-Macros$$ csv macro to convert to .txt

Anyone has a different take on my problem. I would like to get a .txt file output to a file location rather than a conversion within the sheet so I don't have to copy and paste. Pleas!! Any help is greatly appreciated On Oct 22, 1:54 pm, Cesar Delanoval wrote: > Thank you for the re

Re: $$Excel-Macros$$ manage lengthy database

How about when we move the the cursor into row 10 the color of range B10:M10 is yellow thanks On Tue, Oct 26, 2010 at 11:27 AM, ashish koul wrote: > HI > > use it ony if you are not using any background colors in file > > > code: > Private Sub Worksheet_SelectionChange( > ByVal Target As Range)

$$Excel-Macros$$ New Member

Hi, just joined the group to take a look at what I could learn. I'll be posting any questions I have shortly. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw

Re: $$Excel-Macros$$ Help on Graph

That's interesting. I cleared the contents of the cell and the formulae began to work. What exactly do you mean: "It doesn't work?" Matt On Oct 26, 5:08 am, Shrinivas Shevde wrote: > Dear Remy > Thanks for reply but it doesnt work > Shrinivas > > > > > > On Mon, Oct 25, 2010 at 6:08 PM, RemyMaz

Re: $$Excel-Macros$$ Re: Sales Territory's MAP

The url's can't be opened On Tue, Oct 26, 2010 at 1:35 PM, anandydr wrote: > Hi, > > Please see Tushar Mehta's website. > > > http://www.tushar-mehta.com/excel/charts/0301-dashboard-conditionalshapecolors.htm > > Check this site for creating the kind of map you want. I hope this > would help. >

Re: $$Excel-Macros$$ Need Suggestion!

ok On Tue, Oct 26, 2010 at 12:19 PM, amrahs k wrote: > Dear Experts, > > I need quick suggestion to solve the below issue. > > Issue: Team use to update a spreadsheet for tracking their hours details > for extending the shift. After a day the values in the spreadsheet gets > changed this is beca

$$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

-- Forwarded message -- From: sudheer lolla Date: Mon, Oct 25, 2010 at 10:42 AM Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE To: Paul Schreiner , MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> Hi Theres no one who can help me out...Please guys Re

Re: $$Excel-Macros$$ Help on Graph

Dear Remy Thanks for reply but it doesnt work Shrinivas On Mon, Oct 25, 2010 at 6:08 PM, RemyMaza wrote: > You have a white text cell of =na() for the month of May. You also > need to format the cells into numbers. After those two tweaks, the > min & max worked for me. > > Cheers, > Matt > > O

$$Excel-Macros$$ Re: Sales Territory's MAP

Hi, Please see Tushar Mehta's website. http://www.tushar-mehta.com/excel/charts/0301-dashboard-conditionalshapecolors.htm Check this site for creating the kind of map you want. I hope this would help. Anand Kumar On Oct 25, 2:57 pm, sushilck wrote: > you can provide the you sale territory lis

Re: $$Excel-Macros$$ Filter criteria of one row - show previous row...

Dear Robert, Please provide sample sheet...if possible.. Thanks & regards, Noorain Ansari On Mon, Oct 25, 2010 at 9:42 AM, Robert Jacobs wrote: > Thanks in advance to the expert that can help me > > > I have an excel document with thousands of records, each record has a > message associate

$$Excel-Macros$$ Need Suggestion!

Dear Experts, I need quick suggestion to solve the below issue. Issue: Team use to update a spreadsheet for tracking their hours details for extending the shift. After a day the values in the spreadsheet gets changed this is because people might miss use it. So I want a backup spreadsheet of this