Re: $$Excel-Macros$$ Question in Excel

Hi Rajan, Thanks a lots for solving my queries. On Wed, Jan 18, 2012 at 9:09 PM, Rajan_Verma wrote: > Try this: > > ** ** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *neil johnson > *Sent:* Jan/T

Re: $$Excel-Macros$$ Question in Excel

Thanks Noor Ji, For your quick reply. On Tue, Jan 17, 2012 at 11:38 AM, NOORAIN ANSARI wrote: > Dear Kapil, > > Pls see attached sheet with Index+Small > > > On Tue, Jan 17, 2012 at 11:08 AM, neil johnson > wrote: > >> Thanks a lots . >> >> >>

Re: $$Excel-Macros$$ Question in Excel

Thanks a lots . On Tue, Jan 17, 2012 at 10:41 AM, Maries wrote: > > *Find the attachment...* > > On Tue, Jan 17, 2012 at 8:34 AM, neil johnson > wrote: > >> Hi, >> >> I make dummy sheet to get to know , where i am facing problem , and I >> marked as Ye

$$Excel-Macros$$ Question in Excel

Hi, I make dummy sheet to get to know , where i am facing problem , and I marked as Yellow Color . I also give my solution , but that is only half , I need complete solution. I need your help . Please find the attached sheet. -- FORUM RULES (986+ members already BANNED for violation) 1) Use con

Re: $$Excel-Macros$$ Help in Learn advanced excel in noida

Noor is the best teacher . you can contact him. he has great skills in excel . On Sun, Oct 23, 2011 at 10:10 PM, ashish koul wrote: > Contact Noorian Ansari "NOORAIN ANSARI" , > > > On Sun, Oct 23, 2011 at 11:11 AM, ram gopal yadav wrote: > >> Hi all, >> >> Kindly tell me that from where i can l

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Hi Karan, Please find the attached sheet. I am trying my level best to help you . On Thu, Oct 20, 2011 at 1:55 PM, karan 1237 wrote: > Dear all, > > Help me in this..! > > > Kaяan > > >

$$Excel-Macros$$ How to extract number in cell

Hi All, How to extract number form the cell . For example abc123abc wc34agh 783abcd Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceld

Re: $$Excel-Macros$$ Most Helpful Member Sep'11 - Noorain Ansari

Hi Noor, Congratulation Thanks On Sun, Oct 2, 2011 at 10:17 AM, Nikhil Shah wrote: > Hi Noorain > > Excellent work Noorain. > > Regards > > Nikhil > > On Sun, Oct 2, 2011 at 12:43 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for the

Re: $$Excel-Macros$$ find doubling

Hi Anil, Please find the attached sheet. here i am using countif function with if function . and later on autofilter to draw the value of duplicate value. and then then later on you can copy that A-Column data. On Wed, Sep 28, 2011 at 12:46 PM, anil kumar wrote: > Hi everybody, > > I have a file

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

Congratulation Rajan. On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan wrote: > Congratulations Rajan...! > > Regards, Haseeb > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips t

Re: $$Excel-Macros$$ Please explain about loop

Hi Jorge, all loop which used in excel sheet On Mon, Jul 25, 2011 at 9:55 PM, Jorge Marques wrote: > Are you refering to loop while,or loop until? > Hi > > 2011/7/25 neil johnson > >> Hi All, >> >> Please explain loop with real example in sheets . much a

Re: $$Excel-Macros$$ use of indirect function

p://noorain-ansari.blogspot.com/> > > > On Mon, Jul 25, 2011 at 9:04 PM, neil johnson > wrote: > >> Hi All, >> Is indirect function is good function to make dashboard. Please explain >> about indirect function and provide me some example. how c

$$Excel-Macros$$ Please explain about loop

Hi All, Please explain loop with real example in sheets . much appreciated if you will provide attached sheet with example of loop . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tip

$$Excel-Macros$$ use of indirect function

Hi All, Is indirect function is good function to make dashboard. Please explain about indirect function and provide me some example. how can i use indirect function while to make dashboard. Thanks -- -- Some importan

Re: $$Excel-Macros$$ Hi I need your help , Please explain it with example.

ctionChange(ByVal Target As Range) >With ActiveWindow >.ScrollRow = Target.Row >.ScrollColumn = Target.Column >End With > End Sub > > > CMIIW > > > > > On Fri, Jul 15, 2011 at 6:45 PM, neil johnson > wrote: > > > > Hi Sir

$$Excel-Macros$$ there are two code , please explain this code.

Hi, I need your help . I have query in VBA. Please help me . Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 3 And Target.Column = 3 Then 'calculate criteria cell in case calculation mode is manual Worksheets("ProductsList").Range("I3").Calculate Worksheets("ProductsList").Range

$$Excel-Macros$$ Hi I need your help , Please explain it with example.

Hi Sir, Can you please tell me what is difference between these two codes, Please guide me. Private Sub Worksheet_Change(ByVal Target As Range) End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub --

Re: $$Excel-Macros$$ discussexcel.com Launched today

Hi , Congratulation to you sir On 3/20/11, Ayush Jain wrote: > Dear Excel Group Members, > > I am very glad to share that* discussexcel.com > *website is launched today. The website development was initiated three > months back and here is what I achieved. As promised

$$Excel-Macros$$ I want to apply formula in excel sheet can you implementation this formula.

I want to apply formula in excel sheet can you implementation this formula. Fibrotest = 4.467 × log [α2-macroglobulin] −1.357 × log [haptoglobin] + 1.017 × log [GGT] + 0.0281 × [age] + 1.737 × log [bilirubin] − 1.184 × [apolipoprotein A1] + 0.301 × Sex (female=0, male=1− 5.540. --

Re: $$Excel-Macros$$ Queries

dd-up in the > first cell value. > > Harmeet 100+1000 > OR > Harmeet 100 > 1000 > > Best Regards, > DILIPandey > > On 11/28/10, neil johnson wrote: > > Hi Everyone. > > > > I have large data in excel. for example in sheet 1. and we

$$Excel-Macros$$ Queries

Hi Everyone. I have large data in excel. for example in sheet 1. and we have name in sheet 2 . I use vlookup function and fetch the production using vlookup . now when i saw the total there is difference between two . When i see in the sheet 1 . there is duplicate name as well as value is differen

$$Excel-Macros$$ Delete rows including blank row except few members

Hi Everyone, I have data in rows("A:A") like . Now I want to delete blank row and *C, D, E, F till last range in" A". how can I make macros for this * Name B C A B C A A A A B C C C C C B B C C C D E E F F F -- ---

$$Excel-Macros$$ Query regarding macros

Hi Everyone i have two workbook , workbook 1 workbook 2. I make macro in workbook 1. now i want to run macro in workbook2. How i can run macro independly in every workbook. Is there any solution . Thanks -- -- Some

$$Excel-Macros$$ Happy Diwali

Hi Everyone, Wish you happy Diwali to all my sir, and friends . Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ finding the last row

Hi, To Find the last non empty row try this syntax : dim lastrow lastrow = cells(rows.count,1).end(xlup).offset(1,0).row msgbox(lastrow) Or you can use Dim lastrow lastrow = Cells(Rows.Count, 1).End(xlUp).Row + 1 MsgBox (lastrow) step 2 ( if you want to color to last row) cells(lastrow,1).int

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

ange("A" & Rows.Count). _ > End(xlUp).Offset(1, 0) > rng.Value = Me.ListBox1.List(item, 0) > rng.Offset(, 1) = Me.ListBox1.List(item, 1) > End If > Next > End Sub > > regards > r > > > > 2010/10/26 neil johnson > >

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

ber and the second is to > pass the column number. > Check the file. > > I hope I could help you. > > cheers > Sergio > > 2010/10/26 neil johnson > >> >> Hi Everyone, >> >> I need your help. I make listbox using user form in excel . in listbox

$$Excel-Macros$$ Hi Sir, I need your Help

Hi Pandey Sir, We are very lucky and we would like to appreciate to you because we are getting more solution from you of any query in excel. Sir I need your help I want to make dashboard in excel . Can you suggest me or send me excel sheet .( dashboard excel sheet). Thanks -- ---

$$Excel-Macros$$ Fwd:

Hi Everyone , I have rows of data with which I'd like to forecast the next 2 periods of data for. What is the formula to do this. I'd like to do this in excel all on one row as shown below: monthJan Feb March April May June July Aug Sep(current Month) Next remaing month ---

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

Dear Sir, Congratulation . where is the treat ? On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing technical expertise > in Excel technical communities for past one

$$Excel-Macros$$ Please tell me what is meaning of this code

Hi Sir, I am sending attached excel sheet in which user form display the dynamic range. When we select range in user form with the help of list box data goes to another sheet. Sir My question is the highlighted.: Why we do listcount -1 and other question is that highlight cell .Sir I need your hel

Re: $$Excel-Macros$$ Please explain that code Which I highlighted

k first: if (Target.count = 1) then > > > In the case of: > * If Cells(Target.Row, 1).Value <> "" Then* > > the macro looks at column "A" of the row in which a cell is changed > and checks to see if it is not blank before proceeding. > > hope thi

$$Excel-Macros$$ Please explain that code Which I highlighted

Dear Excel member, I need your help. Can you explain that code. Private Sub Worksheet_Change(ByVal Target As Range) *If Target.Row = 3 And Target.Column = 3 Then* ( What is that Means ) 'calculate criteria cell in case calculation mode is manual Worksheets("ProductsList").Range("I3").Calculat

Fwd: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम है......पाण् डेय MR. दिलीप जी.

Hi , Dilip Pandey is great personality . That is truth. He is genious and great knowledge of excel vba. I slute to you . -- Forwarded message -- From: Jai Deo Tiwari Date: 2010/9/29 Subject: Re: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम है..पाण्डेय MR. दिलीप जी. To:

Re: $$Excel-Macros$$ Show Values in List

Hi Deepak, Check this Sheet. On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote: > Dear all > > I attached a sample file, the problem is > there are two lists one is Sales_head & other is cities comes under that > sales head > my problem is when i select the sales head in one list then all the

Re: $$Excel-Macros$$ Show Values in List

Hi Deepak, Please check this sheet. It can help you . On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote: > Dear all > > I attached a sample file, the problem is > there are two lists one is Sales_head & other is cities comes under that > sales head > my problem is when i select the sales head

$$Excel-Macros$$ Question about list box

Hi Sir, - *I am not understanding that Code : When I use listbox.value it shows index number like 0 in excel sheet. While When I use listbox.list(listindex) display the value correctly. * *What is difference between them. * Thanks and Regards -- -

$$Excel-Macros$$ HIGHLIGHT CODE Please explain it

Hi Sir, Please explain that highlighted code . What is that means. Dim i As Long, j As Long For i = 0 To Me.ListBox1.ListCount - 1 If Me.ListBox1.Selected(i) Then * Worksheets("Sheet1").Range("A" & i + 2).Resize(1, 6).*Copy Worksheets("Sheet2").Range("A" & Rows.

$$Excel-Macros$$ Explain about list box properties

Hi Everyone, Can Someone Explain about Listbox properties in VBA. . When I use listbox in user form . and list box properties. there is *COLUMN COUNT* . *Why we user -1 in Column Count?* Please explain the properties of LIST BOX except this question. Thanks and Regards -- --

Re: Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

her I can directly copy the autofilter's > choices. But given Neil's result, I think it is fine as I can easily > sort the unique list. > > Thank you so much!!! > > On Sep 10, 2:20 am, neil johnson wrote: > > -- Forwarded message -- > > Fro

$$Excel-Macros$$ How can me make dynamic range in vba

Hi Everyone, How can we make dynamic range in excel vba. Please explain it . How can we fetch date in *user form by using dynamic rage in excel* *in vba coding *. Please solve this problem . Thanks and Regards -- -

Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

-- Forwarded message -- From: Meimei Date: Fri, Sep 10, 2010 at 6:55 AM Subject: $$Excel-Macros$$ How to copy the list of autofilter selection? To: MS EXCEL AND VBA MACROS Hi all, I have a question about copy the list of unique values generated by autofiltering in VBA. For exam

$$Excel-Macros$$ Fwd: what will be the code of previous and next button in excel

Hi Sir, Can you sort out that problem. Thanks and Regards -- Forwarded message -- From: neil johnson Date: Aug 22, 2010 2:25 PM Subject: what is coding of previous and next button in excel To: excel-macros@googlegroups.com Hi Everyone, I make user form in excel. But I don&#

Re: $$Excel-Macros$$ Excel

Hi Dear, I you have any query , you can ask . i will try to solve it . On Sat, Aug 28, 2010 at 12:10 PM, nilesh kapure wrote: > Hi, All, > > > > > I am fresher in ms excel & wanted to learn about basic and advance excel. > > Can someone please help me in this. > > Regards., > Niesh > 993070482

$$Excel-Macros$$ what is coding of previous and next button in excel

Hi Everyone, I make user form in excel. But I don't know how to run *"Previous button and next Button" in *excel by making vba code. Please help . What is Syntax of this button ? I know only Syntax = dim lastrow lastrow = range("A65550").end(xlup).row+1 range("A" &lastrow).value = textbox1.text

$$Excel-Macros$$ Excel vba link

Hi Everyone, Please check this link of excel vba http://www.excel-vba-easy.com/vba-basic-msgbox.html Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://tw

$$Excel-Macros$$ Problem

Hi , I have problem in this sheet. Please solve it . Please find the attached sheet Thanks and Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter

$$Excel-Macros$$ Problem in list box when using refedit control

Hi Everyone I make user form , and i reterive cell range through refedit contorl . when i select the range in refedit control and it show single range value in listbox MY *problem is that when i select more range it show error in list box.* *Can you sort out that prolblem as soon as possible.* I n

$$Excel-Macros$$ pivot table and dashboard

Hi, Please help me to tell that what is pivot table and how to make dashboard. Please provide me excel sheet with example. Thanks and regards Gaurav -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ Power point

Hi, How can i send the excel data into power point through excel vba. Please solve my problem. Thanks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.

$$Excel-Macros$$ Power point presentation

Hi, I want to send excel data into power point through excel vba . Thanks and Regards -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip