Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

Please add my number in what'sup group 9910243729 Thanks Manoj On Thu, Aug 11, 2016 at 11:24 AM, Manoj Garg wrote: > Please add 9927199217 > > On Aug 11, 2016 8:51 AM, "Kishore P V K" wrote: > >> Please add 9348264783 >> >> On Wed, Aug 10, 2016 at

$$Excel-Macros$$ want to learn excel VBA

Dear Champs I want to learn excel VBA so can you send me the notes for the same. Thanks Regards Manoj Kumar -- 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

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

Dear members, I want to know the excel formula's becoz write now i am making the excel database if you have the information plz send me the excel formula's.on my email id manoj3...@gmail.com Thanks for your active participation in the group. Feel free to write back if

RE: $$Excel-Macros$$ Paste special using skip blank

).SpecialCells(xlCellTypeConstants, 2).Copy Range(C1)** ** End Sub ** ** ** ** * * *Warm Regards,* *Ravi Kumar.* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar *Sent:* Friday, October 18, 2013 10:59 PM *To:* excel

Re: $$Excel-Macros$$ Paste special using skip blank

Hi Ravi Thanks you so much. i got it. Thanks Regards Manoj Kumar On Sat, Oct 19, 2013 at 1:09 PM, Ravi Kumar excellearn2...@gmail.comwrote: Dear friend, ** ** ** ** I had also attached the screen shot of excel shortcut. Please see the attached file

$$Excel-Macros$$ Paste special using skip blank

Hi Team Can anyone suggest me that. How can I paste data using skip blank. That all the blank cell ignore and data comes in series. Please help me on this. Thanks Manoj -- 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

$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

On Thursday, May 10, 2012 4:19:25 AM UTC-7, NOORAIN ANSARI wrote: Dear Group, Please find attached Interview questions and answers for MS Excel+VBA+MS Access+SQL Server. If any one have this type of question and answers, Kindly share with group. Thanks ! it really Help to me.

Re: $$Excel-Macros$$ Total Count of Unique ID's

Try the below formula: =SUM(1/COUNTIF(A2:A595,A2:A595)) After entering this formula, you must press *Ctrl-Shift-Enter.* It will give the desired result*. * Best, Manoj Kumar* * On Mon, Sep 23, 2013 at 11:48 AM, Ashish Kumar kumar.ashish...@gmail.comwrote: Dear Seniors, I want total

$$Excel-Macros$$ Different Validateion

Dear Expert, In validation we select a range and put the text but i want a different validation. We can put any value in a cell but when we put No it will be not consider. Regard Manoj -- 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

$$Excel-Macros$$ Error in Excel Report

Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with p how many count in header. Regard Manoj -- 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 @

Re: $$Excel-Macros$$ Error in Excel Report

On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert, Please help to sove my Quiry file attached in mail. i need fill all data with p how many count in header. Regard Manoj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Error in Excel Report

please see the example what i need On Thu, Jul 4, 2013 at 5:02 PM, De Premor d...@premor.net wrote: On cell C5, paste this =IF($B5=C$3,REPT(p,C$3),0) Rgds, [dp] Pada 04/07/2013 18:19, Manoj Kumar menulis: On Thu, Jul 4, 2013 at 4:47 PM, Manoj Kumar manoj.11...@gmail.com wrote

$$Excel-Macros$$ Need City in Blanck Coloume.

Dear Expert. please help to solve query. regd Manoj -- 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, accurate thread titles. Poor

Re: $$Excel-Macros$$ formula required

Dear Prashant, Please use this.. SUMPRODUCT(($D$2:$D$5=A7)*($G$2:$M$5)) Regard Manoj On Mon, Jan 14, 2013 at 12:19 PM, Prashant Pawle ppawle.ex...@gmail.comwrote: Dear Team, Need a formula to look up a filed give sum of figure , sample file attached Regards, Prashant -- Join

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

website for the first 3 months for FREE! Manoj Kumar manoj...@gmail.com javascript: wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste

$$Excel-Macros$$ how to remove space between numbers only.

Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can

Re: $$Excel-Macros$$ Re: how to remove space between numbers only.

, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry

Re: $$Excel-Macros$$ convert excel file to text file

the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Manoj Kumar kmrmanoj1...@gmail.com To: excel-macros@googlegroups.com Sent: Thu, December 6, 2012 12:54:18 PM Subject

$$Excel-Macros$$ convert excel file to text file

Hi Expert I want to convert many excel file in text format. So is this possible to convert file without open a file or save as options. becouse i have to consolidated many excel file in one excel so is this any suggestion so please help Thanks Manoj -- Join official Facebook page of this forum

Re: $$Excel-Macros$$ Sum required from different sheet..

Hi, Anybody please help me... Regard Manoj On Wed, Nov 7, 2012 at 12:53 PM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert, Please help me ...when I add new sheet (3) it should be change like that..SUM('1:3'!B2) Regard Manoj -- Join official facebook page of this forum

Re: $$Excel-Macros$$ Sum required from different sheet..

Sorry for delay... yes Pravin.. On Wed, Nov 7, 2012 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote: *you mean to say that the formula should be changed automatically, whenever you create a new sheet? * -- Forwarded message -- From: Manoj Kumar manoj.11...@gmail.com

Re: $$Excel-Macros$$ inquiry

I found it... Me.Pictures.Visible = False change false to true... u can see all picture one by one.. Regard Manoj On Tue, Nov 6, 2012 at 1:50 PM, DELIN FRANCIS delin_1...@yahoo.co.inwrote: Dear Anil, if add more names then how can add more pics please tell me the way boss regards

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

May be this will work for you. Thanks shekar. It was very helpful to me. On Sunday, 4 November 2012 05:51:21 UTC+5:30, shekar wrote: edit a cell and press enter On 3 November 2012 22:10, Rohan Young rohan...@gmail.com javascript:wrote: hi raja, its not working regds On Sat,

$$Excel-Macros$$ Recover Excel File

Dear Expert, Please tell me any body how can i Restore my excel file after save... I save my excel file and closed. can i get old.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1)

$$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

Dear Expert, Please help me to get the currect ans with attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

Re: $$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

Anybody Please help me On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar manoj.11...@gmail.com wrote: Dear Expert, Please help me to get the currect ans with attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Need sale report combine with Date, XX Airtel from next sheet'

File allready attached... On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya amreshkushw...@gmail.comwrote: send me attachment. On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar manoj.11...@gmail.com wrote: Anybody Please help me On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar manoj.11

Re: $$Excel-Macros$$ Re: Need sale report combine with Date, XX Airtel from next sheet'

Thanks yaar.. it realy wonderful, it help me to make report so easy.. On Fri, Oct 26, 2012 at 2:16 PM, Vabz v...@vabs.in wrote: PFA Cheers//Vabs On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: Dear Expert, Please help me to get the currect ans with attached file

Re: $$Excel-Macros$$ Re: Need sale report combine with Date, XX Airtel from next sheet'

hello,, formula is wrong. On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar manoj.11...@gmail.com wrote: Thanks yaar.. it realy wonderful, it help me to make report so easy.. On Fri, Oct 26, 2012 at 2:16 PM, Vabz v...@vabs.in wrote: PFA Cheers//Vabs On Friday, October 26, 2012 12

Re: $$Excel-Macros$$ Re: Text need in different collume

Please confirm it is possible without macro Regard Manoj On Tue, Oct 23, 2012 at 12:17 PM, Vabz v...@vabs.in wrote: Hi PFA Att It contains various methods.. Chherz//Vabz On Tuesday, October 23, 2012 11:19:06 AM UTC+5:30, Manoj Kumar wrote: Dear Expert, I have data witch has

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

Hi, U Can buy Acer Aspire S3-I5.. Regard Manoj On Mon, Oct 22, 2012 at 4:49 PM, v...@vabs.in wrote: ** Wooww! Gud input.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -- *From: * CoRe neculae.vale...@gmail.com *Date: *Mon, 22 Oct 2012 04:17:49 -0700

$$Excel-Macros$$ Re: Text need in different collume

Dear Expert, I have data witch has Text and Number i want to do saperate text and number in next collume. man25oj kuma112r ro444ha25n 25s26on7 Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already

Re: $$Excel-Macros$$ Abc in a column

Hi it's really work thanks a lots experts. Regards Manoj On Oct 20, 2012 10:05 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Hi expert I want ABC in a column. So can u help me on this. In a column ABC from a to z. Thanks Manoj -- Join official facebook page of this forum @ https

$$Excel-Macros$$ Abc in a column

Hi expert I want ABC in a column. So can u help me on this. In a column ABC from a to z. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Fwd: Need formula to update status

-- Forwarded message -- From: Manoj Kumar manoj.11...@gmail.com Date: Thu, Oct 18, 2012 at 12:29 PM Subject: Need formula to update status To: excelvbacli...@googlegroups.com Dear Expert, Please Find the attachment.. Please provide me a formula to update status in coll F

Re: $$Excel-Macros$$ Re: Need formula to update status

Thanks On Thu, Oct 18, 2012 at 1:05 PM, Vabz v...@vabs.in wrote: Hi PFA.. Cheers.. Rgds//Vabs On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote: -- Forwarded message -- From: Manoj Kumar manoj...@gmail.com Date: Thu, Oct 18, 2012 at 12:29 PM

$$Excel-Macros$$ Hard to find Status for me...

Dear Expert. Please help me.. File attached below.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Re: Introduce Yourself !!

Hi, This is manoj kumar from new delhi.. I am add my new id on this group.. Regard Manoj On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your

RE: $$Excel-Macros$$ Automation in excel

Waiting for reply On Oct 10, 2012 11:52 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Actually I don't know about the coding in vba where I can learn coding for vba. I know only record macro. I want to do coding in my way. What I want I get it from my data. Thanks Manoj On Oct 10

$$Excel-Macros$$ Automation in excel

Hi experts I want to learn automation in excel first of all tell me. What is automation. how I use in excel. Please give any notes and suggestions to learn. Waiting for reply. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

RE: $$Excel-Macros$$ Automation in excel

://excelvbaprogramming.wordpress.com/ * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Manoj Kumar *Sent:* 10 October 2012 10:48 *To:* excel-macros@googlegroups.com *Subject

Re: $$Excel-Macros$$ St id Reqd on Max Date

Dear Viper, Please can you solve it without erry..please help.. On Fri, Oct 5, 2012 at 11:47 AM, The Viper viper@gmail.com wrote: pfa On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, Request you to kindly help me on this matter... Please

Re: $$Excel-Macros$$ St id Reqd on Max Date

, Oct 5, 2012 at 11:51 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Viper, Please can you solve it without erry..please help.. On Fri, Oct 5, 2012 at 11:47 AM, The Viper viper@gmail.com wrote: pfa On Fri, Oct 5, 2012 at 10:58 AM, Manoj Kumar kumarmanoj.11...@gmail.com

$$Excel-Macros$$ Excel Macro Reqd for Folder to Folder

Dear Export, I have one folder x witch has contain mail's, every mail contain an excel file, i want to copy all excel file from folder x to onther folder with different name.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

12:47:18 PM UTC+5:30, Manoj Kumar wrote: Dear Export, I have one folder x witch has contain mail's, every mail contain an excel file, i want to copy all excel file from folder x to onther folder with different name.. Regard Manoj -- Join official facebook page of this forum @ https

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Dear vabz, Thanks. but it's not working.. Regard Manoj On Wed, Oct 3, 2012 at 1:15 PM, Vabz v...@vabs.in wrote: Hi PFA Files.. Cheers.. Rgds//Vabs On Wednesday, October 3, 2012 12:47:18 PM UTC+5:30, Manoj Kumar wrote: Dear Export, I have one folder x witch has contain mail's

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

*- -- *From:* Manoj Kumar kumarmanoj.11...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, October 3, 2012 3:52:31 AM *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder Dear vabz, Thanks

Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder

Wesley *- -- *From:* Manoj Kumar kumarmanoj.11...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, October 3, 2012 7:34:09 AM *Subject:* Re: $$Excel-Macros$$ Re: Excel Macro Reqd for Folder to Folder Sorry

Re: $$Excel-Macros$$ Presentation Vba Code

anybody please help me. On Thu, Sep 27, 2012 at 11:58 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, i am making Power point presentation i have a macro to do same size of all pitcher. but all pitcher showing in different aria. i want to do all picture in center

$$Excel-Macros$$ Need Help in AutoComplete with Custom List

Hi, Is there an way to autocomplete the words from the custom list. When someone type the first word, the word should be automatically filled and display the rest word in should be in selection. Regards, Manoj -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

PM UTC+5:30, Manoj Kumar wrote: Hi, Is there an way to autocomplete the words from the custom list. When someone type the first word, the word should be automatically filled and display the rest word in should be in selection. Regards, Manoj -- Join official facebook page of this forum

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

value from drop down. Regards, Swapnil. On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar manoj.s...@gmail.com wrote: Not able to understand clearly. can you please the solution in the attached file. On Tue, Sep 25, 2012 at 5:07 PM, Vabz v...@vabs.in wrote: Hi Please refer link

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

complete option. It will give you dropdown for cell and user have to select value from drop down. Regards, Swapnil. On Tue, Sep 25, 2012 at 5:16 PM, Manoj Kumar manoj.s...@gmail.com wrote: Not able to understand clearly. can you please the solution

Re: $$Excel-Macros$$ subtitute function infirmation required

...@gmail.comwrote: Hi see below links: http://office.microsoft.com/en-us/excel-help/substitute-function-HP010062578.aspx http://www.techonthenet.com/excel/formulas/substitute.php Regards, Kuldeep Singh On Wed, Sep 19, 2012 at 11:17 AM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear

$$Excel-Macros$$ subtitute function infirmation required

Dear Expert, i want know about subtitute. anybody tell me about subtitute function.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Need help - To divide the string into three parts

Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your

$$Excel-Macros$$ help on Power point

Dear Expert. Please tell me how can i re-size all slide in one time.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.com wrote: Hi All Experts, Pl solved challenging formula for passing. Appreciate the help very much -- Join official facebook page of this forum @

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

Dear Amar, Please Use it... =IF(OR(F11$F$10,G11$G$10,H11$H$10,I11$I$10,J11$J$10,K11$K$10,L11$L$10),Failed,Pass) Regard Manoj On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

then show failed (required output in yellow) (looking Minmum marks on Row numbers 10) F10:L10. If anyone got marks less than minimum marks then show failed. On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear amar, Please tell what is passing marks... Regard Manoj

Re: $$Excel-Macros$$ Required Passing formula (More confusing)

failed. On Wed, Sep 5, 2012 at 1:10 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear amar, Please tell what is passing marks... Regard Manoj On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.comwrote: Hi All Experts, Pl solved challenging formula for passing

Re: $$Excel-Macros$$ How to count the items except repetition

Dear Amresh, if we need unique agency and unique city how can we find... Regard Manoj On Wed, Sep 5, 2012 at 11:04 AM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi Pravin, find the attached solution. use this small formula. =COUNTA(C3:C39) Regards Amresh On Wed, Sep 5, 2012 at

Re: $$Excel-Macros$$ Lookup data when there are repeated data with diff amt

Dear Rakesh, Use *=SUMIFS(Sheet1!$D$2:$D$18,Sheet1!$B$2:$B$18,A2)* Regd Manoj On Mon, Sep 3, 2012 at 1:00 PM, Rakesh Kumar Sharma rakeshks@gmail.comwrote: Hi Experts, I need the actual remit amt agnst tracking on sheet2 when data was found repeated on sheet1 with positive or nigative

$$Excel-Macros$$ Need Help

Dear Expert, Please help me to find rank in attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Need Help

Dear Pravin, Please provide ans.. Regard Manoj On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote: Pl use a meaningful subject for immediate response on your issues On Mon, Sep 3, 2012 at 3:59 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, Please

Re: $$Excel-Macros$$ Need Help

. Regards Amresh On Mon, Sep 3, 2012 at 4:30 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Pravin, Please provide ans.. Regard Manoj On Mon, Sep 3, 2012 at 4:15 PM, Pravin Gunjal isk1...@gmail.com wrote: Pl use a meaningful subject for immediate response on your issues

Re: $$Excel-Macros$$ Need Help

Dear Kuldeep, Amresh put formule in value but i change range in percentage it's working.. Regard Manoj On Mon, Sep 3, 2012 at 4:45 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Thanks for all Amresh's formula is ok for me.. Regard manoj On Mon, Sep 3, 2012 at 4:39 PM, Amresh

Re: $$Excel-Macros$$ Need Help

ok kuldeep it's my mistake...cell N4 value is wrong... Regard Manoj On Mon, Sep 3, 2012 at 4:47 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Kuldeep, Amresh put formule in value but i change range in percentage it's working.. Regard Manoj On Mon, Sep 3, 2012 at 4:45 PM, Manoj

$$Excel-Macros$$ Need help

Hi, Please help me to collect data in attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Need help

** * On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Hi, Please help me to collect data in attached file.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation

Re: $$Excel-Macros$$ Need help

. --- Ms.Exl.Learner --- On Wed, Aug 22, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: i need the formula witch divide randomly A3, in cell A4 to A8 when i add A4 to A8 it show 200.. On Wed, Aug 22, 2012 at 3:01 PM, Pravin Gunjal isk1

Re: $$Excel-Macros$$ Need help

= 1 To EndCol For j = 1 To Cells(2, i).Value Cells(3 + j, i).Value = Cells(3, i).Value / Cells(2, i).Value Next j Next i End Sub --- Ms.Exl.Learner --- On Wed, Aug 22, 2012 at 2:50 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote

Re: $$Excel-Macros$$ is that is sunday

Hi Sundarvelan, Tri it.. =Text(a1,ddd) Regard Manoj On Fri, Aug 17, 2012 at 3:12 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Sundarvelan, Please share a sample worksheet. Regards, Kuldeep Singh On Fri, Aug 17, 2012 at 3:09 PM, Sundarvelan N nsund...@gmail.com wrote: Dear

$$Excel-Macros$$ Barcode

Dear group I want to make a barcode in excel. So i how make a barcode plz help me on this. Thanks Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Barcode

Thanks dear Manoj On Aug 9, 2012 8:58 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj, One easy way to create bar code in excel Please visit here http://strokescribe.com/en/create-barcode-excel-2007-activex.html On Thu, Aug 9, 2012 at 8:31 PM, Manoj Kumar kmrmanoj1

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

*Cong Noorain! Ji* On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote: Good work! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Ayush Jain jainayus...@gmail.com *Sent:* Friday, August 03, 2012 12:40 PM *To:* excel-macros

$$Excel-Macros$$ Can anybody tell me about Indirect

Hi, Please provide value from use Indirect.. Regard Manoj -- 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

Re: $$Excel-Macros$$ conditional formatting

Dear Smitha, Please find the attachment.. it will help you... Regard Manoj On Thu, Jul 26, 2012 at 11:44 AM, Smitha S R sperdwo...@gmail.com wrote: Hi, Please help in conditional formatting or use of if formula in the following case. Excel attached. Closing Stock Verification stock

$$Excel-Macros$$ Please provide me Excel 2003 2007 Short Key

Hi. Please provide me Excel 2003 2007 Short Key Regard Manoj -- -- 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$$ Please provide me Excel 2003 2007 Short Key

Thanks dear..€. On Thu, Jul 19, 2012 at 12:50 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please find attached short cut for excel 2003,2007 and 2010. On Thu, Jul 19, 2012 at 1:18 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Hi. Please provide me Excel 2003

Re: $$Excel-Macros$$ Help Me

www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, Please help me to make report I have data in 1 sheet I want make report in sheet 2. Regard Manoj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Help Me

* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj

Re: $$Excel-Macros$$ Please help me.

Thanks Noorain Ji... its working.. On Wed, Jul 11, 2012 at 1:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, You can also try =IF(ISERROR(SEARCH(C9,B9))=TRUE,Not Found,Found) On Wed, Jul 11, 2012 at 1:01 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert

Re: $$Excel-Macros$$ Text - Splitting - Help Required through Formula

:- =RIGHT(A3,LEN(A3)-FIND(#,SUBSTITUTE(A3, ,#,LEN(A3)-LEN(SUBSTITUTE(A3, ,) Thanks Regards, *Deba Ranjan P* On Wed, Jul 11, 2012 at 5:26 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear JP, Select the range Press ALT+D+E Click Delimited Next Click Space Click

Re: $$Excel-Macros$$ Index Formula Help

Dear Sudhir Please find the attachment... Regard Manoj On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA newinex...@gmail.com wrote: Dear All, Please look at attachment and help me. thanking u Regards Sudhir -- FORUM RULES (986+ members already BANNED for violation) 1) Use

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

columns to it just by adding column name with , and the same column in group by seperated by ,) Regards, Lalit Mohan On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote: Dear Experts, I have data in month wise data in Access in different query.. Please help me to find unique id

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

distinct [Store ID] FROM [Apr'12]; union SELECT distinct [Store ID] FROM [May'12]; Regards Prince Dubey. On Friday, 29 June 2012 15:14:18 UTC+5:30, Manoj Kumar wrote: Dear Experts, I have data in month wise data in Access in different query.. Please help me to find unique id From

Re: $$Excel-Macros$$ Excel Q A

Tkanks Krishna On Thu, Jun 21, 2012 at 12:09 PM, Maries talk2mar...@gmail.com wrote: Nice Collection Thanks On Wed, Jun 20, 2012 at 9:11 PM, Anil Gawli gawlianil8...@gmail.comwrote: Hi Krishna, Thanks 4 sharing ... Regards, Gawli Anil On Wed, Jun 20, 2012 at 8:35 PM,

Re: $$Excel-Macros$$ Progress Bas for macro status - Help Required

Dear Avinash. Sub gg() For a = 1 To Sheets.Count Sheets(a).Activate Range(a1:dd5).Select Selection.Font.Bold = True Next End Sub Regard Manoj On Sun, Jun 17, 2012 at 11:39 PM, Avinash avinash007pa...@gmail.com wrote: Dear Experts, I have 1 workbook and there are 10 subsheets in

Re: $$Excel-Macros$$ formula

/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote: Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- FORUM RULES (986+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ formula

Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- 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,

Re: $$Excel-Macros$$ Advance HappyChristmas

merry christmas to all regards manoj On 12/23/11, sunil bn bnsuni...@gmail.com wrote: Hi Friends, Happy Merry Christmas In Advance...[?][?] -- [image] *Regards* **Sunil B.N ***9035858585 [image] -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ MIS Opening

Dear Sir, Thanks for your suggestion... Regards Manoj On Mon, Aug 29, 2011 at 7:10 PM, Manoj Kumar kmrmanoj1...@gmail.com wrote: Dear Sir, Please find the attached CV in this mail, and revert for the same ASAP. Regards Manoj Kumar On 8/25/11, Rahul Gandhi myname.ra...@gmail.com wrote

Re: $$Excel-Macros$$ Prefix 0 before the number- Help

See if this helps... Best, Manoj Kumar On Tue, Oct 11, 2011 at 1:14 PM, waheedb...@gmail.com wrote: Hi group, I have numeric data in column, each cell contains 5 to 6 numeric values but are less 7 characters. For example: 12345, 385469. What I want is, what ever is the count it should

Re: $$Excel-Macros$$ kindly suggest me how can I Unhide all the hide sheet in a single go.

u can try this code... *Sub UnhideAllSheets()* *Dim wsSheet As Worksheet* * * *For Each wsSheet In ActiveWorkbook.Worksheets* *wsSheet.Visible = xlSheetVisible* *Next wsSheet* *End Sub* Best, MKV On Wed, Aug 24, 2011 at 12:54 PM, jayendra gaurav

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

Me Too... Thanks... Regards, Manoj Kumar On Mon, Aug 22, 2011 at 9:33 AM, pankaj gmail account pankaji...@gmail.comwrote: Please forward same to me also Thanks Pankaj 2011/8/20 Venkat CV venkat1@gmail.com You are welcome *Best Regards,* *Venkat * *Chennai* * * On Sat, Aug 20

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Hi, you can use this formula as well in cell B2:- =LOOKUP(99^99,--(0MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A20123456789)),ROW(INDIRECT(1:LEN(A2)) Best, Manoj Kumar On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY amit...@iocl.co.in wrote: I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

Congrats Ashish, keep it up. Best, Manoj Kumar On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of May'11 He has posted 67 posts in May 2011 and helped many people through his

Re: $$Excel-Macros$$ Recovering corrupted excel file

Dear experts Can you tell me what is use of snerios in excel. Regards Manoj On 5/24/11, Rajan_Verma rajanverma1...@gmail.com wrote: Send your File.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, May 23, 2011 11:33

  1   2   >