Re: $$Excel-Macros$$ VBA

HI sumanth   Bhupendra Chaudari had send Xcellent link for VBA http://www.pdftop.com/ebook/vba+for+dummies/   Try to downoad a appropiate file Try it --- On Wed, 8/9/10, sumanth kumar wrote: From: sumanth kumar Subject: Re: $$Excel-Macros$$ VBA To: excel-macros@googlegroups.com Date: Wednesday,

$$Excel-Macros$$ Column Data in Rows Table

Hi , I have a case where I get the data in following format NameA B C D E AA 10 14 11 13 14 AB 13 13 14 14 12 AC 13 10 14 11 14 AD 14 10 10 13 13 I need to convert the

$$Excel-Macros$$ Line Charts: Help Required

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

Re: $$Excel-Macros$$ Capture DATA>From Web - Portfolio Tracker

Kamal, Thanks for the suggestion but i did not found any shortcut/query for extracting data directly in Excel. Regards, C.G.Kumar On Tue, Sep 7, 2010 at 7:07 PM, kamal shah wrote: > C.G Kumar, > > I assume you need realtime Stock prices coming to Excel sheet, is that > right? > I have utili

$$Excel-Macros$$ Lookup from date series

Dear Experts, I need a help, I want to lookup value from selected dates. File is attached Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

$$Excel-Macros$$ Help Required: Line Charts

Hi, I've a workbook where two tables given on the sheet1 showing sales for 2009 and 2010. I want to present the data through Line Char. There should be a dropdown on the top of the charts containing three values 2009, 2010 & 2009 Vs 2010. If I select 2009 then the chart should show only sales dur

RE: $$Excel-Macros$$ Re: Ned Maxif

You're welcome. Regards - Dave. Date: Tue, 7 Sep 2010 05:45:29 -0700 From: n8dine4ma...@yahoo.com Subject: Re: $$Excel-Macros$$ Re: Ned Maxif To: excel-macros@googlegroups.com Thanks so much. This worked perfectly. From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: S

Re: $$Excel-Macros$$ i want a coma

coma will be added only if you enter a sting in B column in sheet1 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count = 1 Then If Target.Column = 2 Then If WorksheetFunction.IsText(Target.Value) Then Application.EnableEvents = False Target.Value = Target.Value + "," Applicat

Re: $$Excel-Macros$$ VBA

I am unable to open the link on VBA can anybody help me out Please provide another link on VBA On Wed, Sep 8, 2010 at 12:42 AM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > Thank you Bhupendra very much > > --- On *Tue, 7/9/10, bhupsi1982 * wrote: > > > From: bhupsi1982 > Subject

Re: $$Excel-Macros$$ An excel data entry problem

hi try this assuming sheet1 is master see if it helps Sub Macro1() Dim i, z, k As Long z = 1 k = 50 For i = 1 To 50 Sheets(1).Select Rows(z & ":" & k).Copy Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Select Range("a1").Select ActiveSheet.Paste z = z +

$$Excel-Macros$$ Logic in VB

Hey all: Please see the attached excel sheet . I am trying to create a variable called flag and in this column i want to place the the column names wherever there is no x of ID .. i dont know how to attach a file to the post here.. please see the excel sheet test.xls http://groups.google.com/gr

$$Excel-Macros$$ An excel data entry problem

Hi, I have a data entry problem in excel. I have entered some 2500 entries ( 2500 rows and 8 columns) in the master sheet. Now I want 50 more sheet with just 50 entries on each sheet., resp. Please help me with any model/formulas/macro etc. that will fill these 50 sheets on its own the moment I ent

$$Excel-Macros$$ i want a coma

Dear to all i want a coma in a cell after i enter a name. Dnt use concatenate formula or a1&"," is look like that. Regards, Narasimharao ML -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ VBA

Thank you Bhupendra very much --- On Tue, 7/9/10, bhupsi1982 wrote: From: bhupsi1982 Subject: Re: $$Excel-Macros$$ VBA To: excel-macros@googlegroups.com Date: Tuesday, 7 September, 2010, 11:19 AM Hi, Hope the following would be helpful for you. http://www.pdftop.com/ebook/vba+for+dummies/

$$Excel-Macros$$ ADD-IN for retriving information from another sheet

Hi Group, Ihave to create a ADD-IN to use advancefilter on a database structure created on a excel workbook. Can it be done, by placing the database sheet within the add-in workbook? If not, then can we use a macro to use advance filters on a worksheet which is present in another workbook? Pl

Re: $$Excel-Macros$$ Examine data in rows and move some to columns

Use pivot table drag column A to rows drag column B to columns & details hide sum & grand totals srinivasan On Tue, Sep 7, 2010 at 4:26 AM, Bad at VBA wrote: > Hi everyone, > > I've got data that shows build information vertically in rows down a > column, but my users would prefer to see s

Re: $$Excel-Macros$$ Help Required......for conditional Large Function..

hi check the attachment see if it helps -- Regards Ashish Koul 9953979291 *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile On Tue, Sep 7, 2010 at 5:37 PM, NOORAIN AN

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi Vamsi, Password is there in the cell B1 of RSM sheet, which is there for the owner/admin of the workbook. If you are learning this stuff, then pw is of no use to you rather you should try creating this type of workbook on your own. :) Please feel free to get back in case any help is required

Re: $$Excel-Macros$$ Insert work sheet and rename when insert.

This macros is exellent, thanks from Puerto Rico. P Please consider the environment before printing this e-mail. This e-mail, including any attachments, is intended solely for the person or entity to which it is addressed and may contain confidenti

$$Excel-Macros$$ help

Hi everybody, Please tel me the use of and when I need to use of these- '' '' '' $ { [ ] """,,,""' what are the functions of dees -- Thanks & Regards Shivashankar.C.Katageri. -- -- Some important links for excel

Re: $$Excel-Macros$$ Re: Ned Maxif

Thanks so much.  This worked perfectly. From: Dave Bonallack To: "excel-macros@googlegroups.com" Sent: Sun, September 5, 2010 2:40:20 AM Subject: RE: $$Excel-Macros$$ Re: Ned Maxif Hi, Please see the attached for a possible solution. Regards - Dave.     _

Re: $$Excel-Macros$$ Examine data in rows and move some to columns

I will give this a try. Thank you so much! On Sep 6, 7:57 pm, ashish koul wrote: > check the attachment see if it helps you.. > > Regards > Ashish koul > akoul.blogspot.com > > On Tue, Sep 7, 2010 at 4:26 AM, Bad at VBA wrote: > > > > > Hi everyone, > > > I've got data that shows build informati

$$Excel-Macros$$ Help Required......for conditional Large Function..

Dear Experts, I need a help. I have a list of Employees and his Salaries. I want to retrieve 2nd highest salary of a particular employee. I am unable to retrieve it through Large() function.Please help File is attached. Thanks in advance Noorain Ansari -- -

Re: $$Excel-Macros$$ URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi Could you be more precise on your requirement ? On 9/7/10, farha naaz wrote: > > Hi All, > > can anyone help me in including the picture in the mailer using macro > pl. > > Thanks and Regards, > farha > > -- > > ---

$$Excel-Macros$$ Sorting Searching

Hi All I have creating a searching form with searchlist. i want same search criteria like google. any body have any code pls provide me.. Thanks & Best Regards Kishor -- -- Some important links for excel users: 1.

RE: $$Excel-Macros$$ Need help

Hi, Please see the attached. Regards - Dave Date: Tue, 7 Sep 2010 11:23:17 +0530 Subject: $$Excel-Macros$$ Need help From: rajputpanka...@gmail.com To: excel-macros@googlegroups.com Hi all i have a excel sheet need help, i wanted to use excel formula not pivot table or chat -- Warm Reg

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Hi Vamsi, Thanks for your continuous interest. The VBA macro is working fine in my system and the code which you have mentioned is just for testing purpose and is not getting used anywhere. The code which is actually hiding the rsm sheet while opening is :- Private Sub Workbook_Open() Sheets("RSM

Re: $$Excel-Macros$$ Need help

check the attachment Regards Ashish Koul 9953979291 *akoul*.*blogspot*.com *akoul*.wordpress.com My Linkedin Profile On Tue, Sep 7, 2010 at 11:23 AM, Pankaj Kumar wrote: > Hi all i

Re: $$Excel-Macros$$ Need help

Hi Please find the attached file. On Tue, Sep 7, 2010 at 11:23 AM, Pankaj Kumar wrote: > Hi all i have a excel sheet need help, i wanted to use excel formula not > pivot table or chat > > -- > *Warm Regards > Pankaj kumar > M: 9899816107 > e-mail: rajputpanka...@gmail.com >rajputpank

Re: Fwd: $$Excel-Macros$$ Urgent Help Required

Hi, Pls have a look this solution (monthwise) and let me know if it helps. Thanks, Bhupendra On 9/7/2010 11:55 AM, Deepak Pal Singh wrote: Hi Guy's, Don't we have any specific formula to get this done in excel 2007. Bhupendra, I appreciate your innitiative to solve this query but I need the

Re: Fwd: $$Excel-Macros$$ Urgent Help Required

Hi, The attachment is wrong. Pls find this one. Regards, Bhupendra On 9/7/2010 1:10 PM, bhupsi1982 wrote: Hi, Pls have a look this solution (monthwise) and let me know if it helps. Thanks, Bhupendra On 9/7/2010 11:55 AM, Deepak Pal Singh wrote: Hi Guy's, Don't we have any specific formu

RE: $$Excel-Macros$$ Urgent Help Required

Hi Deepak, Have a look at the attached to see if it's what you need. Regards - Dave Date: Tue, 7 Sep 2010 10:21:26 +0530 Subject: $$Excel-Macros$$ Urgent Help Required From: deepaktheind...@gmail.com To: excel-macros@googlegroups.com Hi Guy's, I've a worksheet containing three columns Se

$$Excel-Macros$$ Capture DATA>From Web

Dear All, I need to capture Current Market Price of given scrip in Excel.I have used DATA>From Web. But, it difficulty is that it captures entire data and not only scrip CMP. Thanks & Regards, C.G.Kumar -- -- S

Fwd: $$Excel-Macros$$ Urgent Help Required

Hi Guy's, Don't we have any specific formula to get this done in excel 2007. Bhupendra, I appreciate your innitiative to solve this query but I need the count of New and Carry Forward. Saurabh can we do it without adding a new column? Thanks Deepak Kumar -- Forwarded message -- F

Re: $$Excel-Macros$$ VBA

Hi, Hope the following would be helpful for you. http://www.pdftop.com/ebook/vba+for+dummies/ Best, Bhupendra Chaudhari On 9/7/2010 10:48 AM, shashank bhosle wrote: Hello All Can anybody suggest me any course or books that will help me to learn VBA. Please help me out. Current ro

$$Excel-Macros$$ URGENT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Hi All, can anyone help me in including the picture in the mailer using macro pl. Thanks and Regards, farha -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http:/

$$Excel-Macros$$ Need help

Hi all i have a excel sheet need help, i wanted to use excel formula not pivot table or chat -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com* -- -