$$Excel-Macros$$ Re: Help required in excel

Check if it helps ... [image: Inline image 1] Regards, ZAFAR IQBAL +966 (14) - 325 1654, 325 3484, 325 4148 - Ext - 2011 On Sat, Jul 15, 2017 at 5:31 PM, Srinivas G wrote: > Hi Friends, > > I want to help in Excel > > ramu Ramu False > Raju Raju

$$Excel-Macros$$ Re: Help required on making pivot caches / tables

Hi All, I am trying to make pivot table using VBA.but I am getting runtime error 5 or so. Can someone suggest me a code to make pivot cache and then table. Thanks Abhishek Bhalla From: amar takaleamartak...@gmail.com Sent:Thu, 25 Feb 2016 10:20:12 +0530 To: excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Help Required

> > PFA !! Ticket closed > Regards, Mandeep baluja -- 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$$ Re: Help Required

Dear sir, Thanks sir !! Kindly share the formula. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Thursday, January 14, 2016 4:50 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Help Required PFA !! Ticket

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

] *On Behalf Of *Mandeep Baluja > *Sent:* Thursday, January 14, 2016 4:50 PM > *To:* MS EXCEL AND VBA MACROS > *Subject:* $$Excel-Macros$$ Re: Help Required > > > > PFA !! Ticket closed > > Regards, > > Mandeep baluja > > -- > Are you =EXP(E:RT) or =NOT(EXP(

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

> > Your Date is not date but to convert a date to number you can simply > multiply it with one this scenario works most of the cases but not for all. > For Example your date is in A1 put formula in b1 = A1*1 Regards, Mandeep baluja ticket closed -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

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

Dear sir I cannot understand kindly brief/example From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Thursday, January 14, 2016 6:15 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Re: Help Required Multiply date

$$Excel-Macros$$ Re: help required

> Hi Sam > Thank you very much for your quick response > Later i researched on the particular question and i concluded a result > which may be seen in the attach workbook...but thank you very much for your > quick response > > -- > *Izhar Ul Haq* > > > > Cell# 009203069072597 > -- Are

$$Excel-Macros$$ Re: HELP REQUIRED

I've tried so many times in the past but failed to do so, the reason was, when I tried to search a file in which I have to find something I typed the word with the extension of the software which was unsuccessful but now I tried to search without the extension I find whatever I required. In the

Re: $$Excel-Macros$$ RE: Help required

Hi Neeraj Please use this, ​ Alt+D+E then Delimited next click Date and choose format DMY then finish. ​ *Regards,* *Anand Tiwari* On 4 August 2015 at 16:14, Neeraj Chauhan neerajchauhan...@gmail.com wrote: Dear experts I want to change the date format Date I want this format

$$Excel-Macros$$ RE: Help required

Dear experts I want to change the date format Date I want this format 31/7/2015 31-Jul-15 -- 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

RE: $$Excel-Macros$$ RE: Help required

Thanks Anand From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anand Tiwari Sent: Tuesday, August 04, 2015 4:24 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ RE: Help required Hi Neeraj Please use this, ​ Alt+D+E

Re: $$Excel-Macros$$ RE: Help required

@googlegroups.com] *On Behalf Of *Anand Tiwari *Sent:* Tuesday, August 04, 2015 4:24 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ RE: Help required Hi Neeraj Please use this, ​ Alt+D+E then Delimited next click Date and choose format DMY then finish

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

Thanks sir its working and I want this From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mandeep Baluja Sent: Wednesday, May 20, 2015 3:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help Required Want this ? Regards

$$Excel-Macros$$ Re: Help Required

Want this ? Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote: Dear Experts, Kindly find the sheet and do the needful formula

$$Excel-Macros$$ Re: Help required for MS- Access application.

Do you want to Create separate sheets on the basis of column.??? Regards, Mandeep baluja On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: Hi Experts, I want to split table from main table with their names available in column For example. I have a database in

$$Excel-Macros$$ Re: Help required for MS- Access application.

Thanks Mandeep for reply. Below is the column in which we required separate Tablefor each LOB. *LOB Name* Health Personal Accident Engineering Health Personal Accident Health Miscellaneous - Package Health Health Personal Accident Health Health Health Personal

$$Excel-Macros$$ Re: Help required for MS- Access application.

Use this code basically it use the Autofilter technique to create sheets and use of collection class to remove the duplicates. Sub Macro60() 'Step 1: Declare your Variables Dim MySheet As Worksheet Dim MyRange As Range Dim UList As Collection Dim UListValue As Variant Dim

$$Excel-Macros$$ Re: Help required for MS- Access application.

Thanks dude but I need code to make separate sheet for each LOB as these needs to assign work to each individual. On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: Hi Experts, I want to split table from main table with their names available in column For example.

$$Excel-Macros$$ Re: Help required for MS- Access application.

Why you're not using the pivot table feature to create this, Create pivot and use this column in row field to create separate sheets. only 6 are required, but if you still wish you can use the code for the same. Health Personal Accident Engineering Miscellaneous - Package Liability

$$Excel-Macros$$ Re: Help required for MS- Access application.

Brother the code which you have given it is for excel. I am talking about MS Access On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote: Hi Experts, I want to split table from main table with their names available in column For example. I have a database in the

Re: $$Excel-Macros$$ Re: Help required for conslidate

when you select your blank cells just see the buttons in home tab where insert,delete,format button is showing you need to press delete -delete cells - shift cells to left . On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote: Thanks Mandeep ji, but dear i didn't under

Re: $$Excel-Macros$$ Re: Help required for conslidate

Glad to help :) Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 https://www.facebook.com/groups/825221420889809/ On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote: Thanks alot Mandeep

Re: $$Excel-Macros$$ Re: Help required for conslidate

Thanks Mandeep ji, but dear i didn't under stand what your are talking about this line *go into home tab delete cells and shift cells left you will get your data* Pl help RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu Kashmir,

Re: $$Excel-Macros$$ Re: Help required for conslidate

Thanks alot Mandeep ji. its working. br// rakesh RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile +91 9906115140 rakesh.kumar.d.sha...@ericsson.com

$$Excel-Macros$$ Re: Help required for conslidate

Select b3:m5 press f5 - click special option-tick blank-go into home tab delete cells and shift cells left you will get your data. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Ok Sir, I am trying. Regards Ashu Kenith -- 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 thread

Re: $$Excel-Macros$$ Re: Help required for Match DATA

in this attachment did you enabled this library in refrences go to vba editior enalble these library and then go to sheet1 and click the button send mails . microsoft outlook 14.0 object library ole auotmation microsoft excel 14.0 object library visual basic for applications microsoft forms

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, All are enabled. PFA the attachment. Please provide Support. Regards Ashu Kenith -- 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

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Query is still pending from last 2 months. Last time you said that, you will send the answer shortly. Revert awaited from your side. Please help. Regards Ashu kenith. On 1/15/15, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, Please Help on the same issue. Can i

$$Excel-Macros$$ Re: Help required for Match DATA

PFA !!! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam Date

$$Excel-Macros$$ Re: Help required for Match DATA

remove option explicity statement which is in first line of your code, as this code working perfecctly on my pc , Please send me the line number of error. On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam

$$Excel-Macros$$ Re: Help required

Hello Correct me if mistaken. You want to sum time in column 1 with time in column 2 in column 3 in format like hh hrs mm minute. If yes in column 3 add simply column 1 and column 2 (you can round it). Change format of result by pressing ctrl+1 and typing in custom type: *hh hrs mm minute* .

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please help. kindly send the macro. Regards Ashu Kenith. On Thu, Jan 15, 2015 at 6:41 PM, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. Please help sir. Regards Ashu Kenith On Thu, Jan 15, 2015

Re: $$Excel-Macros$$ Re: Help required for Match DATA

https://m.facebook.com/VBAEXCELSQL?__tn__=C This is my page i have posted your macro on this blog top post is yours, Copy the same and run in your sheet. Sorry i forgot to send you the sheet.will send the same as i will be in office. Regards, Mandeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Thanks a lot for your help. I don't have an facebook account. So, request you to please share the macro when you have time. Thanks for your help and kind support. Regards Ashu Kenith On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja rockerna...@gmail.com wrote:

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. Please help sir. Regards Ashu Kenith On Thu, Jan 15, 2015 at 12:30 PM, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, Please help. Regards Ashu Kenith. On Tue, Jan 13, 2015 at 6:37 PM, Ashu k

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please help. Regards Ashu Kenith. On Tue, Jan 13, 2015 at 6:37 PM, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, Thanks a lot for your help. one more help required. If the Merchant ID is same then paste the data (Order No., Item ID, Item Name, RTO Date) on

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please Help. Regards Ashu Kenith. On Wed, Jan 7, 2015 at 4:18 PM, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, Solution was perfect. But i want Paste the data in Mail body. Please check below sample Email :- Dear Business Partner, This is to inform you

$$Excel-Macros$$ Re: Help required for Match DATA

Amazing Code Bro !! On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote: Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam Date and, I have data in Sheet 2 Name Class Roll No. Exam Date But some Names are not in Name Column and Some Class are not

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Anil Sir, Thanks for your reply. But, i dont want to send mail with attachment. I want send different mail to different customers according to the merchant ID. Subject and message body should be changed automatically with all the details (order no., rto date, item name, item id) when i

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, I don't want to send mail with attachment. I want send different mail to different customers according to the merchant ID. Subject and message body should be changed automatically with all the details (order no., rto date, item name, item id) when i punch the merchant id,order

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mr. Ashu, Pls find attached as per you requirement. P.S pls change the address of the attachment as you req. .Add (T:\Commercial\Common\Shailendra\Data Format(Now(), mm-dd-yy) .xls) Warm regards, Gawli Anil. On Wed, Jan 7, 2015 at 1:24 PM, Ashu k direct2as...@gmail.com wrote: Dear

$$Excel-Macros$$ Re: Help required for Match DATA

Done !! Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl -- 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$$ Re: Help required for Match DATA

Dear Mandeep Sir, Solution was perfect. But i want Paste the data in Mail body. Please check below sample Email :- Dear Business Partner, This is to inform you that as per our logistic partner report you have received RTO shipments with details as follow: *Order No* *Item ID* *Item

$$Excel-Macros$$ Re: Help required for Match DATA

check this sheet. Try to understand what I did For i = 2 To lr + 700 you can set 700 to any number. Datarange is not set in your data that's why i running the loop to lastrow+700 if your data will be greater just change 700 to 7 or to any number it will give correct result to you.

$$Excel-Macros$$ Re: Help required for Match DATA

Hey Ashu, Check this sheet .* Note :- be careful to check this macro can only give you error if the number are actually numbers not the Text values as your sheet contain 1 value which was text that is the only reason it gives error as paul has explained to you mostly people copy numbers

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Paul Sir, Thanks for your help and explaining me.. Dear Mandeep Sir, Thanks a lot for your help, Please check the attached sheet. Result was not showing in Last cell. Please help. Thanks Ashu Kenith. On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja rockerna...@gmail.com wrote: Hey

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, PLease help. I want send mail to the customers. Example is attached. Thanks Ashu Kenith -- 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

Re: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

: Tuesday, January 6, 2015 11:38 AM Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA Dear Mandeep Sir, Please help on this. The sheet is provided by you is providing NA#. Please Help. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k direct2as

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, Please help on this. The sheet is provided by you is providing NA#. Please Help. Thanks Ashu Kenith -- Forwarded message -- From: Ashu k direct2as...@gmail.com Date: Wed, Dec 31, 2014 at 11:52 AM Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

$$Excel-Macros$$ Re: Help Required on Dependent Data Validation

This solution will work for you !!! To create a dependent drop down list provide some unique values as all persons having the same values .This can be achieved without dependent drop down. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

...@gmail.com Date: Tue, Dec 23, 2014 at 11:06 AM Subject: Re: $$Excel-Macros$$ Re: Help required for Match DATA To: excel-macros excel-macros@googlegroups.com Dear Mandeep Sir, It gives NA# again. Kindly run macro and See the result in Cell C1 and C12. Sheet attached. Thanks Ashu Kenith On Tue

$$Excel-Macros$$ Re: Help required for Match DATA

Now this macro works for 3 lakh rows you can increase the range as per your convenience. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, It gives NA# again. Kindly run macro and See the result in Cell C1 and C12. Sheet attached. Thanks Ashu Kenith On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja rockerna...@gmail.com wrote: Now this macro works for 3 lakh rows you can increase the range as per your

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, It's not working. Thanks Ashu Kenith. On Thu, Dec 18, 2014 at 8:00 PM, Ashu k direct2as...@gmail.com wrote: Dear Mandeep Sir, The code which is provided by you is not working properly. It's giving NA# in sheet 2. Formula is working fine for me which is provided by

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Mandeep Sir, The code which is provided by you is not working properly. It's giving NA# in sheet 2. Formula is working fine for me which is provided by Ashish Sir Vaibhav Sir. Kindly check the output and Please Help me. Sheet attached. Thanks Ashu Kenith On Thu, Dec 18, 2014 at 12:42

$$Excel-Macros$$ Re: Help required for Match DATA

check this out. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote: Dear Seniors, I have data in sheet 1 Name Class Roll NO. Exam

Re: $$Excel-Macros$$ Re: Help required for Match DATA

Dear Sir, Thank you very much. Thanks Ashu Kenith On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja rockerna...@gmail.com wrote: check this out. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On

$$Excel-Macros$$ RE: help required urgently

Dear experts, We have given below date format how to convert right format of date like 13-Jan-2014 TT Modified Date Time 13/01/2014 15/01/2014 19:51 2-Nov-14 1-Jun-14 2-Nov-14 15/01/2014 19:57 1-Jun-14 13/01/2014 17:10 15/01/2014 19:47 18/01/2014 15:44 From:

Re: $$Excel-Macros$$ RE: help required urgently

Hi You can format cell as DD-Mmm- or you can use formula =text(ref,DD-Mmm-) where ref is your reference cell. Thanks On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan neerajchauhan...@gmail.comwrote: Dear experts, We have given below date format how to convert right format of

$$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File Get Max voucher Number

Hi, the dbf attachment is corrupted. Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon escreveu: Dear All, I have a DBF Table containing Vouchers Month wise like 70001 (Dated : 05-July-13) 70002 (Dated : 08-July-13) 80001 (Dated : 02-August-13) Now i want to

Re: $$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File Get Max voucher Number

No it's not, that file protected by simple method to prevent user opening it they change the file header structure Try attached DBF, i've repair the header by changing 1st byte on file with correct value. Pada 11/09/2013 21:19, Basole menulis: Hi, the dbf attachment is corrupted. Em

$$Excel-Macros$$ Re: Help Required : How i import Data in Excel from DBF File Get Max voucher Number

ok De Premor, tks. Em quarta-feira, 11 de setembro de 2013 05h48min30s UTC-3, rashid memon escreveu: Dear All, I have a DBF Table containing Vouchers Month wise like 70001 (Dated : 05-July-13) 70002 (Dated : 08-July-13) 80001 (Dated : 02-August-13) Now i want to get New

$$Excel-Macros$$ Re: Help Required

Hi All, I've found a more simpler way to get the time in hrs and minute.. And yes i've seen all ur tricks for this..i dnt know where my trick fails...but i am getting the desired output via my trick also.. so its a question just out of curiosity that my trick is wrong or not, and if it's

$$Excel-Macros$$ Re: HELP REQUIRED

Hi Jai, I m not able to understand ur requirments. Please provide us at least on example to what we needs to do. Regards Prince On Friday, January 11, 2013 10:57:48 AM UTC+5:30, Jai Bhati wrote: HI GUROPS MEMBER , PLEASE HELP REGARDING THIS SHEET . -- Join official Facebook page of

$$Excel-Macros$$ Re: Help Required

Hello Neeraj CTRL+1 on the value column -- Custom -- select type *0.00* cheers On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan wrote: Dear Experts, kindly find the attached sheet. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

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

Hi Cheer, Please use the same mail chane for solution instead of new mail. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, CoRe neculae.vale...@gmail.com wrote: Hello Neeraj CTRL+1 on the value column -- Custom -- select type *0.00* cheers On Friday, November 2, 2012 2:10:58 PM

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

Hi Cheer, Please use the same mail chain for solution instead of new mail. Aamir Shahzad On Fri, Nov 2, 2012 at 5:21 PM, CoRe neculae.vale...@gmail.com wrote: Hello Neeraj CTRL+1 on the value column -- Custom -- select type *0.00* cheers On Friday, November 2, 2012 2:10:58 PM UTC+2,

$$Excel-Macros$$ Re: Help Required

Hello, Maybe this UDF would be useful for you. Function RemoveSpChars(s As String) As String Dim re As Object 'List all allowed characters, but start with the negation ^ Const sPat As String = [^A-Z0-9 ] 'List all characters to be removed, - must ' be listed first or last 'Const sPat As String

$$Excel-Macros$$ Re: Help Required

Hi Sriram, Please use the below mentioned formula to remove special charactors. =SUBSTITUTE(F4,{#,$,%,,!,~,_,;,'},) With ctrl+shift+Enter Note F4 is containing your text. Regards Prince On Wednesday, October 10, 2012 4:02:24 PM UTC+5:30, sriram ji wrote: Dear Excel Guru, Any formula

$$Excel-Macros$$ Re: Help Required

Hi neeraj , you can use this =IF(HOUR(TIMEVALUE(RIGHT(A2,8)))12,Night,Day) On Thursday, 4 October 2012 14:40:45 UTC+5:30, neeraj chauhan wrote: Dear Experts Kindly see the attached sheet and urgently req. -- Join official facebook page of this forum @

$$Excel-Macros$$ Re: help required for creating a formula

Hello, PFA! On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: Dear All, I have a list of industry in one column and in corresponding column the rates as per industry are given. I want to create a formula whereby when i selected a specific industry from the

Re: $$Excel-Macros$$ Re: help required for creating a formula

Dear Ashish PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 3:27 PM, CoRe neculae.vale...@gmail.com wrote: Hello, PFA! On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: Dear All, I have a list of industry in one column

Re: $$Excel-Macros$$ Re: help required for creating a formula

Core. Please REPLY to messages instead of creating a new one. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: CoRe Sent: Wednesday, May 16, 2012 4:57 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: help required for creating a formula Hello

$$Excel-Macros$$ Re: HELP REQUIRED

Hi vijay, You can do that by using ASAP utilities. There are hosts of other features. below link is for you. http://www.asap-utilities.com/ hope this will meet your requirement. Regards Vishwanath On Oct 20, 8:49 pm, vijayajith VA vijayajith...@gmail.com wrote: HI, I have 10 to 15 tabs with

$$Excel-Macros$$ Re: help required on conditional formatting

Dear Prakash Thanks for your solution. but 1 thing is pending if u can solve (i want hide row number 15 if I select bank of baroda) Dear Rohan Thanks to you also, but your solution is giving me the box for only to the digit 7,8,and 9 but I want box on every number, the same is solved by prakash

$$Excel-Macros$$ Re: help required for large range of data filteration

hi experts thanks for ur valuable replays i need more ans if any macros are there can u help me i am trubling this large data Actualy my data having names and codes cobination On Dec 22, 8:28 pm, renuka chari jva.ch...@gmail.com wrote: hi good evening to all experts currentely i am

Re: $$Excel-Macros$$ Re: Help Required!

Hi, I have attached a spreadsheet which contains list of document numbers and their respective names. What I want is I need a word macro that will do the following. Note: The file name will always starts with the Doc Number (5 digits). Ex: 12345 (Refer Sample_Findlaw.xls for list of Doc Number)

Re: $$Excel-Macros$$ Re: Help Required!

Hi, This is what I actually looking for. It works great and solves my query. Thanks for your efforts and help. Regards, Sharma On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa robb@gmail.com wrote: the sub test is just one example of how to use the function into a routine. Sub test() Dim

Re: $$Excel-Macros$$ Re: Help Required!

Hi, I meant to say every time I need to change the S value as Input which is taking more time. I am unable to copy the result since it is showed via message box. I want to copy the result and updated in documents. It would be helpful if you could change the code as per the need.(Macro have to

Re: $$Excel-Macros$$ Re: Help Required!

the sub test is just one example of how to use the function into a routine. Sub test() Dim s As String s = AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR s = ProperCase_r(s) Debug.Print s End Sub r -- -- Some

Re: $$Excel-Macros$$ Re: Help Required!

Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The code gives the output through message box. Due to this I am unable to copy the value (i.e) Output. Also the code is only execute for the input AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR. What

Re: $$Excel-Macros$$ Re: Help Required!

I don't understand which linguage do you use? In visual basic as I have proposed is a function you can pass any text and use its result regards r 2010/10/28 amrahs k amrahs...@gmail.com Hi, This works great. Thanks for your efforts and help. Though I have a small need as well. The

$$Excel-Macros$$ Re: Help Required - Gantt Chart

Hi Maniyan, Please check the file. I think this might help you. Regards Rakesh On Jan 20, 10:18 am, Maniyan pmni...@gmail.com wrote: Hi am working scheduling problem in excel. i would like to know...is there any way i can get the chart for the datas in Gantt Chart format. It will be

$$Excel-Macros$$ Re: Help Required in Master file to PPT

Hi Team, Can you please help me below my request.Thanks in advance On Tue, Sep 22, 2009 at 4:11 PM, minimaster hartmut.gruenha...@bakerhughes.com wrote: How can I attach an excel workbook to this reply? I added some macro code to your workbook. But for some reason I can't find a way to

$$Excel-Macros$$ Re: Help Required in Master file to PPT

How can I attach an excel workbook to this reply? I added some macro code to your workbook. But for some reason I can't find a way to attach it here. --~--~-~--~~~---~--~~ -- Some

$$Excel-Macros$$ Re: Help required. from vertical to horizontal swapping

Hello try the following macro : Sub Copy() Dim Row1 As Long, Row2 As Long Row1 = 1 Row2 = 7 Do Set sh1 = Worksheets(Sheet1) Set sh2 = Worksheets(Sheet2) sh1.Range(C Row1).Resize(8).Copy sh2.Range(M Row2).PasteSpecial Paste:=xlPasteAll, Transpose:=True Row1 =

$$Excel-Macros$$ Re: Help Required

Hi Steven, Solved. Have a look at the attached file. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Mon, Jul 20, 2009 at 6:50 PM, Steven Dsouza steve.o...@gmail.com wrote: Hi, Iam a regular

$$Excel-Macros$$ Re: Help Required

Hello. Have a look at the attached file. Use the following formula in C2 and drag down : =SUMPRODUCT((Dump!$A$2:$A$23=A2)*(Dump!$B$2:$B$23=B2)*Dump!$C$2:$C$23) Regards. Daniel From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Steven Dsouza Sent: lundi

$$Excel-Macros$$ Re: Help Required

Hi You can use following formula in Excel 2007 SUMIFS(Dump!$C$2:$C$23,Dump!$A$2:$A$23,Analysis!A2,Dump!$B$2:$B$23,Analysis!B2) Regards Krupesh On Mon, Jul 20, 2009 at 8:20 AM, Steven Dsouza steve.o...@gmail.com wrote: Hi, Iam a regular user of this group, and some of the tips have

$$Excel-Macros$$ Re: Help Required

Hi, For that you need to define a key in the dump sheet in Column A - Merging data from cells in column B C and then use sumif formula in Analysis sheet, For your reference I have done and attached excel sheet. Hope this is what you required... On 7/20/09, Steven Dsouza

$$Excel-Macros$$ Re: Help Required

Thanks a ton :) On Mon, Jul 20, 2009 at 3:44 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Steven, Solved. Have a look at the attached file. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062

$$Excel-Macros$$ Re: help required

Dear Shivshankar, You can use the copy - paste special - transpose . The shortcut Key for the above is: Ctrl+C followed by ALT + e + s + e then hit return (for transpose) Or You can consider creating your own shortcut key (one time affair and will always help you) Create a macro that does

$$Excel-Macros$$ Re: help required

Hi Shivashankar.C.Katageri. Have a look at the attached. Select B1 then copy across. Regards - Dave. Date: Thu, 2 Jul 2009 13:04:10 +0530 Subject: $$Excel-Macros$$ help required From: shankarkatag...@gmail.com To: excel-macros@googlegroups.com Dear all, Any one can help w.r.t copy from

$$Excel-Macros$$ Re: help required

Hi Aindril De, Thanx,it works,saving my time and, I am new to Macro, But I could not do this, The shortcut Key for the above is: Ctrl+C followed by ALT + e + s + e then hit return (for transpose) Or You can consider creating your own shortcut key (one time affair and will always help you)

$$Excel-Macros$$ Re: help required

Hi Shivashankar, All you got to do is copy the cells A1 to A10 and then place your cursor in B1 Cell and right click your mouse and choose Paste Special...In the Paste Special Screen, Choose Values and also choose Transpose and Click on Ok...You'll get what you are looking for... Let us know, If

$$Excel-Macros$$ Re: Help required

Dear Sir/Madam, We are an active users of excel. We are using Excel 2007 in our office. I would like to know is to how to protect all the sheets in the workbook without using the macro. Regards Bhairav --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Help Required!

Dear Dilip, I believe that you might have answered my query already but somehow it was missed or deleted in my folder. Could you please share it again so that I can go through it again. Thanks for your efforts and suggestion towards this. Regards, Sharma On Wed, Jun 3, 2009 at 7:36 PM, Dilip

$$Excel-Macros$$ Re: Help Required

** *Check the attached file* On Thu, Jun 4, 2009 at 3:32 PM, Sachin Shukla sachina...@gmail.com wrote: Dear All, Please help me on attached sheet. Thanks Sachin Shukla --~--~-~--~~~---~--~~

  1   2   >