$$Excel-Macros$$ TIIPS - Best BA LLB, BA (JMC), B.Tech, BBA, BCA Institute in Delhi NCR - Greater Noida

Best Computer Science Engineering, Electronics and Communication Engineering, Information Technology, BA LLB, BJMC, BBA, BCA Institute in Delhi NCR CONTACT Name: TIIPS Contact No.: +91 120 232 3123 Email:i...@trinity.com Website: https://www.tiips.ac.in/ Best Computer Scien

Re: $$Excel-Macros$$ Getting syntax error for a basic vba code

t; can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Rohan Kapuria > > *To:* excel-...@googlegroups.com > *Sent:* Thursday, July 24, 2014 1:0

$$Excel-Macros$$ Getting syntax error for a basic vba code

Hi all, I am new to excel VBA and I copied this peace of code from excel vba for dummies and i am getting a compile error (syntax error) The option to declare variables explicitly is off. Error statements marked in RED Need help! Sub GuessName() Msg = “Is your name “ & Application.UserName & “

$$Excel-Macros$$ US$ currency Format

*Hi Experts* * how do get US$ currency format from 1234567 to 1,234,567* thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, ac

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

On Wed, Jun 18, 2014 at 6:50 PM, Vaibhav Joshi wrote: > ActiveSheet.Range("G" & j).Value = strFile ITS DONE now, Gr8 dear, excellent thanks alot bro, very-2 thanks to you :-) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Fac

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

thanks a lot bro, this is awesome and that's i need very-2 thanks bro On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi wrote: > PFA > > You need to customize send key letters to get desired output. > > Cheers!! > > > On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young w

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

its already set on both side printing by default but when i am taking print through that its coming on one side printing On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi wrote: > You need to set duplex printing option as default before printing.. > > > On Thu, Jun 12, 2014 at 5:

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

one more thing if you can add on this that is both side printing coz our organization preferred that or excel could take own-self the setting of both side printing as default thanks On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young wrote: > please also solve my query of folders of mails logb

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

please also solve my query of folders of mails logbook regds On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young wrote: > thanks a lot bro > > > > > On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > >> PFA >> >> Cheers!! >> .*show(Time)* >>

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

thanks a lot bro On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi wrote: > PFA > > Cheers!! > .*show(Time)* > > > On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young wrote: > >> no bro, >> >> i want Repeat Top row should come in print on every individual sh

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

ibhav Joshi wrote: > If there is sheets 1 to 10..You want to repeat 1st row of sheet 1 on all > pages of sheet 1,2,3 etc.. > > it it correct?? > > > > On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young wrote: > >> hi, >> >> i am talking about the "Repeat

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

> > Cheers > On Jun 11, 2014 9:39 PM, "Rohan Young" wrote: > >> >> On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young >> wrote: >> >>> Dear Group, >>> >>> I need to repeat header rows in prints in specific sheets after

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young wrote: > Dear Group, > > I need to repeat header rows in prints in specific sheets after that no > need to print header rows on remaining sheets. > > Thanks in advance > ROHAN > > -- Dear Group, I need to repeat header

$$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

Dear Group, I need to repeat header rows in prints in specific sheets after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

bro, i want it from .msg file On Wed, Jun 11, 2014 at 2:23 PM, Vaibhav Joshi wrote: > Rohan > > you want from .msg file or .pst foder? > > > On Wed, Jun 11, 2014 at 12:45 PM, Rohan Young > wrote: > >> Thanks Vaibhav bro its excellent & it will help me in

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

n it. Thanks Bro ROHAN On Wed, Jun 11, 2014 at 11:28 AM, Vaibhav Joshi wrote: > Hi > > Check this, you can select folder one by one. If you want to Import from > one folder only then once data is imported press escape key when prompted > for second time. > > Cheers!! > >

$$Excel-Macros$$ Repeat Header Rows in prints upto initial selected sheets

Dear Group, I need a UDF for repeat header rows in prints upto selected sheets (i.e. initial 5 or 6 no. sheets) after that no need to print header rows on remaining sheets. Thanks in advance ROHAN -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

ng folders? > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Rohan Young > *Sent:* Tuesday, June 10, 2014 4:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO > >

Re: $$Excel-Macros$$ Outlook Mails log in Excel through MACRO

of mail* abc xyz 123 Hello 10-Jun-14 16:51 thanks in advance Regds ROHAN On Tue, Jun 10, 2014 at 3:46 PM, finu kodokodan wrote: > Hi Anil , > > Good work , If the email id added in one column (As per attached ) we have > to sent detail to corresponding emails . please advise h

$$Excel-Macros$$ Outlook Mails log in Excel through MACRO

Hi Group, I have two folders of mails (incoming & outgoing) and I need a macro to make a log of mails separately of both folders in excel with the following details From, To, CC, Subject, Date, Time Please do the needful ASAP Rgds ROHAN 9818247278 -- Are you =EXP(E:RT) or =NOT(EXP(

$$Excel-Macros$$

http://thereferraljob.com/?refer=33938 pls conform the above link to conform your payment thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1

$$Excel-Macros$$ Copy data from one sheet to another by matching column header

Hi Friends, I Have an workbook, where i want to copy data from one sheet to another sheet by matching column header and also to format the destination column in general format is there any VB Code for it i have this code with me but it gives me error 400, please help Sub Test() Dim rng As Ran

Re: $$Excel-Macros$$ Re: Calculation Automatically Not Updating.

Prince ji happy diwali, i thing me want to share wid u why u always share wid new mail, why dont wid related quary? thanks On Wed, Nov 14, 2012 at 8:39 AM, Prince wrote: > Hi Anjali, > > Please set the below option in your workbook. > > Tools -> Options -> Formulas -> Calculation Options ->

Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member October'12

Congratulation Rajan On Tue, Nov 6, 2012 at 11:28 AM, Rajesh Nair wrote: > Congrats Rajan > > > On Tue, Nov 6, 2012 at 10:23 AM, Kuldeep Singh wrote: > >> >> Hi, >> >> *Congratulations* Rajan Sir. >> >> Regards, >> Kuldeep Singh >> Back Office Executive (MIS) >> Info Edge India Limited (naukri.

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

ok then use LEFT($B$12,2)&LEFT($C$12,2)&LEFT($D1$2,2) On Sat, Nov 3, 2012 at 11:43 PM, cyberuser wrote: > Hi, > > The text is located in a single cell and it can be of variable words... > > example: > > Cells A1: "John Doe Junior" > Cell B1 should return "jodoju" > > or > > Cell A1: "John Doe"

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

plz put range as per ur requirement On Sat, Nov 3, 2012 at 11:24 PM, Rohan Young wrote: > HI, > > TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) > > REGDS > > > On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > >> Hi, >> >> Is there a

Re: $$Excel-Macros$$ Excel formula to retrieve the two first characters from a name

HI, TRY DIS =LEFT(B12,2)&LEFT(C12,2)&LEFT(D12,2) REGDS On Sat, Nov 3, 2012 at 11:14 PM, cyberuser wrote: > Hi, > > Is there a formula that would the 2 first characters from a name, eg. > first, and/or second, and last name? > > example: > in cell A1: > "John Doe Junior" > in cell B1 the formu

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi raja, its not working regds On Sat, Nov 3, 2012 at 10:03 PM, RAJA SEKAR wrote: > > > > On 3 November 2012 15:44, Pravin Gunjal wrote: > >> *Thanks Kuldeep for your reply.* >> *I want the cursor should go in the cell "D1" when the ENTER key is >> pressed.* >> * >> * >> On Sat, Nov 3, 201

Re: $$Excel-Macros$$ Can cursor will go to cell "D1" when we press enter

hi, Click the mouse in the Name Box (the area to the left of the formula bar that shows an address of present or selected cell(s)) press D1 and enter. redgs On Sat, Nov 3, 2012 at 3:44 PM, Pravin Gunjal wrote: > *Thanks Kuldeep for your reply.* > *I want the cursor should go in the cell "D1"

Re: $$Excel-Macros$$ Pls help

Hi, try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc regds On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi, > > How to select particular cell value within one click.I need to select > value 2 only. > without using macr

Re: $$Excel-Macros$$ Serial no

hi Prashant, PFA regds On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ me

Re: $$Excel-Macros$$ If greater then the cell color should be red else green

hi, try this Regds On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics) < prasad.kam...@imrbint.com> wrote: > Hi Sundarvelan, > > > PFA…done with conditional formatting. > > ** ** > > Regards, > > Prasad K > > *From:* excel-macros@googlegroups.com [mailto: > exc

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Oh mere NOORAIN Bhai, Sabki toh le li BADHAI. Ab apni hai baari aayi, Mubarak ho aapko apni, KABLIYAT ki yeh kamai. Many-2 Congrts NOORAIN bhai.. KEEP IT UP On Sat, Aug 4, 2012 at 10:48 PM, SAGAR KASANGOTTUWAR wrote: > Congratulations Noorain, > > All the best ... > > You are the

Re: $$Excel-Macros$$ Need formula to take out total number of boy and girl

just correct your answer =COUNTIF($E$10:E49,"GIRL") On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote: > Dear all, > > Can you please help me to find out the total number of boy and girl ? I used > countif for their grade and it worked. However, for girl and boy > seggregation it isnot working

Re: $$Excel-Macros$$ Mails IDs from Outlook

item.Subject 'Sheets("Inbox Scan").Cells(i, 4).Value = oitem.Body 'Sheets("Inbox Scan").Cells(i, 5).Value = oitem.ReceivedTime i = i + 1 Next End Sub On Mon, Jul 9, 2012 at 4:08 PM, NOORAIN ANSARI wrote: > Dear Rohan, > > Please che

Re: $$Excel-Macros$$ Mails IDs from Outlook

Dear Ashish Ji, thanks but i m not getting the result, can you please send me the add in or anything else for it regds ROHAN On Thu, Jul 5, 2012 at 10:58 PM, ashish koul wrote: > try this see if it helps > > Sub Scan_my_outlook_inbox() > 'TOOLS ->Refrence -> micro

Re: $$Excel-Macros$$ Mails IDs from Outlook

; On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young wrote: >> >> Dear Group, >> >> how can i get all mail IDs from my outlook to excel to make a list of >> all IDs and Co., please help me out >> >> Thanks & Regds >> >> ROHAN >> >> --

$$Excel-Macros$$ Mails IDs from Outlook

Dear Group, how can i get all mail IDs from my outlook to excel to make a list of all IDs and Co., please help me out Thanks & Regds ROHAN -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!

Congratulations to both of you and thanks for being with us On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey wrote: > Thanks Ayush..!! > > Thanks to all the members of this group for giving us many chances to > learn by sharing their queries. ;) > > It is a great group.. . Thanks once

Re: $$Excel-Macros$$ I want to repeat the text or number,

Dear Neeraj, See the attachment, if help Regds ROHAN On Tue, Jun 26, 2012 at 2:11 PM, Neeraj Chauhan wrote: > Siwaya > > Sikhera 1 > > Maithna Inder Singh > > Salarpur > > Niit > > Pela Sofipur > > Ganga Nagar > > P

Re: $$Excel-Macros$$ age month days calculations - Reg

try this =+DATEDIF(A1,NOW(),"y")&" Years, "&DATEDIF(A1,NOW(),"ym")&" Months, "&DATEDIF(A1,NOW(),"md")&" Days " Regds On Fri, Jun 22, 2012 at 1:29 PM, Suman wrote: > Hi Dear ! > Please use this formula if its help you. > =Text(Today()-that cell which contain ur birth date,"yy") > > Regards, > @S

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

*Congratulation Nootain Bhai * - Keep it up On Thu, Mar 15, 2012 at 3:40 PM, raghunandan rallapalli < raghunandan.rallapa...@gmail.com> wrote: > Congratulations... Mr.Ansari.. Hope will continue your good work... > Radha Lakshmi.. > > > On Thu, Mar 15, 2012 at 11:39 AM, jmothilal wrote: > >> Con

Re: $$Excel-Macros$$ Custom Format Examples

Gud1 Noorain Bhai - carry on On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed wrote: > Hi Noorain, > One small question how can I set this formats as default in my excel. > > Thanks > Waheed > On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel wrote: >> >> NOORAIN ROCKS ONCE AGAIN >> >> >> >> R

Re: $$Excel-Macros$$ Series and Justify in Excel 2010

Thanks for the effort xlstime. But these are not what I am looking for in Excel 2010. I am looking for Home - Editing - Fill button(editing section). Please help me with any tutorial for this section if possible. Thanks !! Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1

$$Excel-Macros$$ Series and Justify in Excel 2010

Hi Group, Could anyone please share some tutorials for the "Series"and "Justify" features in the Fill dropdown of Excel 2010. Thanks in advance. Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titl

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

CONGRATULATION NOORAIN BHAI, CARRY ON. On Sat, Feb 4, 2012 at 10:47 AM, Venkat CV wrote: > Congrats... > > Noorain & Everyone... > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > > On Wed, Feb 1, 2012 at 10:11 PM, Ayu

Re: $$Excel-Macros$$ Liniking Pivot Tables

concern. Thanks, Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Index & Match Formula

Really dont understand your output completly. Could you please explain the requirement more clearly even if sam's answer above solves your query. Thanks Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$ Amazing... Excel Menu Bar... Try it... you will like it

Nice Work. Thank you !! Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2

$$Excel-Macros$$ Re: Analytics

Additionally, this is required for pure marketing and sales, so that I can attract the team and the leadership on the importance of data and analytics and also how it can help us improve on efficienc and forecasting. Any help in this regard will be deeply appreciated. Regards, Rohan. -- FORUM

$$Excel-Macros$$ Analytics

related slide, please attach the slides. Thank you !! Regards, Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick

Re: $$Excel-Macros$$ Re: Help On Print

format, in which its there in the sheet. If the issues persists, you can get back to me with the error...!! Thank you !! Regards, Rohan. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$dividing my data set in 70-30 Ratio

20 130 140 150 160 170 180 190 200 200 213.333 221.9047619 Paste this in the first column and try running the macro. See if it helps.on the same basic ground that I have used, u can modiify the macro as well..Thank you !! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violat

$$Excel-Macros$$ Best Wishes 2012

excel experts join this group, people who can code for multiple and diverse applications(MS Office) and people who can solve tougher problems. Thanks to all and keep learning... Best Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Create Uni Code

Aamir, range error. Corrected. Thank you ! Sub Macro1() Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select Application.CutCopyMode = False Range("C1:D" & Cells(Rows.Count, "D").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "F1"), Unique:=T

Re: $$Excel-Macros$$ Create Uni Code

Range( _ "F1"), Unique:=True Columns("G:G").EntireColumn.AutoFit End Sub Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Please !! Thanks Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don&#

$$Excel-Macros$$ Re: Fwd: Vba Code for Outlook

You can use a macro to send the emails, however you would have to a Excel sheet to store the name of the recipients and email address. Can write a macro if that works fine for you !! Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Compare character types in 2 character string

=TYPE(VALUE(LEFT(H2,1)))=TYPE(VALUE(RIGHT(H2,1))) Here you go. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

$$Excel-Macros$$ Re: Financial Tools in excel.

Not sure what your requirement is. Finance is a huge subject. Please try to create some sample and let us know, what exactly are you tryingy to accomplish. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ shortcut key .

Yes, to check and uncheck the filters you can use the bar. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Re: Help On Print

nge("A1:B" & LR).AutoFilter Field:=1, Criteria1:=i        ActiveWindow.SelectedSheets.PrintOut Copies:=1        Rows("1:1").Select        Selection.AutoFilter    Next i End Sub Regards, Rohan -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accura

Re: $$Excel-Macros$$

Thanks Noorain..!! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a qu

$$Excel-Macros$$ Re: Help On Print

Hi, You can do a filter and take a print out.!! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick

$$Excel-Macros$$ Re: how to formatting the vba code using Notepad ++,can anyone help me?

Hi, Choose the language that you are using from the toolbar - language menu. There is a specific format for each specific language there. Hence, as you choose VBA, and paste in your code there you ll see the formattying appear. Dont think you can change that Regards, Rohan. -- FORUM RULES

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

Have just replicated the same on my own using some sample data. Attach your sheets and I will replicate the same in your sheet as per your needs. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

$$Excel-Macros$$ Re: VBA code automatic typesetting and show code row number

of codes that you have. Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

Re: $$Excel-Macros$$ Plz help urgent

Make a pivot - Right click - Value Field settings - Show values as - Select % of grand total. Thanks, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ Re: Rename and search files.....need some extra help

Cant open the vba file...its password protected. Send the password to the group plz and we can try to add additional functionalities. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Macro work

Plz share the details and the requirement and the details...will give it a try Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ Cell editing VBA

Try this... !! Sub Test() Range("B2").Select Do If ActiveCell.Value = "" Then Exit Do ActiveCell.Offset(0, 3).Activate Loop End Sub -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, For

$$Excel-Macros$$ Re: VBA code automatic typesetting and show code row number

Garcia, Not sure what exactly you're asking for. If I understand, you want to record steps in Excel and see the VBA for the same ?? -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formul

Re: $$Excel-Macros$$ No. of Occurrence of char in string

This will count the input that the user makes in the input box prompt and will display the count in a Message Box. Sub Test() Dim StartVal As Integer Dim Count As Integer Dim InputCount As Variant InputCount = InputBox("Please enter the input u want to count") For StartVal

$$Excel-Macros$$ Re: Excel Books or classes

I would say start topic wiseLearn each at a timelike, basics,formulas and functions, charts, pivot tables and then on to vba/ macros. You can start following any basic book about excel.. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. P

Re: $$Excel-Macros$$ Conditional Formatting using VBA

If Cells(i, "B").Value < Application.WorksheetFunction.Average(CelRng) Then Cells(i, "B").Interior.Color = vbCyan End If Next i End Sub Thanks, Rohan -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

formula in the Conditonal Formatting dialog box, where it says "Applies to" Lemme know, if you have questions. Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

Re: $$Excel-Macros$$ Extract Number In String - EXCEL Formula

You can use this as well... =MID(C9,1,FIND("_",C9)-1) Thanks Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

Re: $$Excel-Macros$$ Need Help

Guys, Cant figure out what these files do. Please explain with example, how exactly do you use these two excel files. Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ Data validation not working properly

Ensure that you are using the correct formula and remove unnecessary blanks from the sheet. Also, check the Ignore blanks in data vlaidation box. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

$$Excel-Macros$$ MS Access solution

about accomplishing this. If you already have worked on a solution like this which helps in daily reporting by comparing the value from the previous day report and if you can share the solution with me, that will really give me ideas and would be really appreciated. Thank you !! Regards, Rohan

$$Excel-Macros$$ Re: Correction in Formula

Just use >9 as ">9" =COUNTIFS($G$3:$G$14,B4,$H$3:$H$14,">9") Thanks, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ MS Access Help

incase if there is any discrepancy. Thanks, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be

$$Excel-Macros$$ Re: MS Access Help

Hi Experts, Any info on the above issue!! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be a

$$Excel-Macros$$ MS Access Help

not a good idea to Link-import a Excel sheet with formulas to MS Access. Please guide. Thank you ! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

$$Excel-Macros$$ Interact with other applications

is, please let me know, what kind of applications(other than office applications), I can interact with and in order to do that what specific branch of VBA i can use. Along with this, if you can help me with some learning resource, that would be kind on your behalf friends. Thank you ! Rohan

Re: $$Excel-Macros$$ Re: How to use Advance filter

Hi, The link that's provided is very good. Just checked it out, in see nearly all the info there. If you have not tried this link, please have a look and it should solve all your queries about' Advanced Filters" Rohan. -- FORUM RULES (925+ members already BANNED for violation)

$$Excel-Macros$$ Re: How to use Advance filter

Using advanced filter you can filter your data, as per a specific criteria. Advanced Filter: List Range: Select the range that you want to filter. Criteria Range: Select the range on the basis of which you want to filter the data. Unique Records only: You can select this, if you want your results

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

Dear Paul, please do the needful thanks & regds ROHAN On Wed, Sep 28, 2011 at 11:31 AM, Rohan Young wrote: > Dear Paul, > > one more thing your indirect formula is not working in master sheet, > would u please explain > > thanks & regds > > On Tue, Sep 27,

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

- > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > ----

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

riginal Message----- From: Rohan Young > Sent: Tuesday, September 27, 2011 12:47 AM > To: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help > > Please see the attchment > > regds > > On Mon, Sep 26, 2011 at 7:19 PM, dguille

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > ----- > > > From: Rohan Young > To: excel-macr

Re: $$Excel-Macros$$ Fwd: Required Latest No. of Drawing - Help

2-Mar-11 date, then it'll take some more work. > > > Paul > > - > “Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the peopl

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

revision no. is can be RO, R1, R2 OR C0, C1, C2 OR P0, P1, P2, i need formula or vba code this these 3 conditions, - Thanks & Please Help - SAMPLE ATTACHED. Regds ROHAN On Sat, May 28, 2011 at 3:42 PM, Rohan Young wrote: > Dear Ashish Ji, > > Please help me out on thi

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

Dear Ashish Ji, Please help me out on this, THANKS ROHAN On Sat, May 28, 2011 at 3:01 PM, Rohan Young wrote: > waiting for reply, please > > someone can help on it > > Regd > > ROHAN > > On Sat, May 28, 2011 at 11:09 AM, Rohan Young wrote: >> Dear Hanumat, &g

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

waiting for reply, please someone can help on it Regd ROHAN On Sat, May 28, 2011 at 11:09 AM, Rohan Young wrote: > Dear Hanumat, > > Thanks a lot, its working but i required cell colours in green & how > can i add this function in another file because its just sample, i >

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

Dear Hanumat, Thanks a lot, its working but i required cell colours in green & how can i add this function in another file because its just sample, i have a master file with 5-7 another sheets like this - Please help Thanks & Regd ROHAN On Fri, May 27, 2011 at 8:59 PM, hanumant shind

$$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

ther change also revision no. is can be RO, R1, R2  OR  C0, C1, C2  OR P0, P1, P2, i need formula or  vba code  this  these 3 conditions, - Thanks & Please Help - SAMPLE ATTACHED. Regds ROHAN -- -- Some importa

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

Thanks very much Ashish Ji & Zafar Regds ROHAN On Tue, May 10, 2011 at 9:30 PM, ashish koul wrote: > to find total --- > > > =INDEX($C$12:$K$12,0,MATCH($N$2,$C$2:$K$2,0)) > > > > > On Tue, May 10, 2011 at 5:39 PM, Rohan Young wrote: > >> Thank

Re: $$Excel-Macros$$ Total of sum of Diff. criteria according to date

Thanks Ashish Ji, as i knew that i will got the answer first from your side, but 1 more thing if i do not have column A (skilled & unskilled type), in that situation what is the formula? please reply Thanks & Regds ROHAN On Tue, May 10, 2011 at 5:16 PM, ashish koul wrote: >

$$Excel-Macros$$ Total of sum of Diff. criteria according to date

thanks & regds ROHAN -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?g

  1   2   >