$$Excel-Macros$$ Re: Help - Recorded Formula Not Ending Up In Cell Correctly

2018-03-31 Thread Johnny
I included a small file, with sample data in it, and the macro I'm working on. -- 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, accu

Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

2017-12-19 Thread who
Sub CopyPastVal() Cells.Copy Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False End Sub Thanks, David On Sunday, December 17, 2017 at 12:12:31 AM UTC-8, Ravi K wrote: > > Thanks David. > Will try to incorporate this into the macro. > > Cheer

$$Excel-Macros$$ Re: Help with replacing formula with value over large range

2017-12-18 Thread Ravi K
Sub chkdt() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim rw, cl, i, q As Double 'rw - no of used rows, cl - no of used column, i - lookup for row,q - lookup for column Dim dif, t, dt As Long t = 4 dt = 5 rw = ThisWorkbook.Sheets("MINUTES").Range("A" & Rows.

Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

2017-12-17 Thread Ravi Krishna
Thanks David. Will try to incorporate this into the macro. Cheers Ravi On 17 Dec 2017 7:20 am, "who" wrote: > Might try this too. Thanks, David > > Sub CopyPasteAll() > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteValues > ActiveSheet.Paste > Applicat

$$Excel-Macros$$ Re: Help with replacing formula with value over large range

2017-12-16 Thread who
Might try this too. Thanks, David Sub CopyPasteAll() Cells.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues ActiveSheet.Paste Application.CutCopyMode = False ActiveCell.Select End Sub On Friday, December 15, 2017 at 10:14:17 PM UTC-8, Ravi K wrote: > > Hi

Re: $$Excel-Macros$$ RE: Help Req.

2017-09-18 Thread Prabhu Pinky
Please clarify below: 1. You wants to show all indus id with last two entry Or 2. You want to see last two entry of any one indus id you choose (by drop down option...) Regards, Prabhu.R On 18-Sep-2017 7:16 PM, "Neeraj Gmail" wrote: Dear experts, Kindly find the sheet I want to put last two

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

2017-07-15 Thread Zafar Iqbal
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 True > mohan Mohan

$$Excel-Macros$$ Re: Help on sumif function

2017-01-02 Thread maryjhon830
http://tutorialway.com/use-sumif-function-in-excel/ useful website -- 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

Re: $$Excel-Macros$$ Re: Help on Index and Match

2016-12-16 Thread Jayanta Barman
Find the attachment. On Fri, Dec 16, 2016 at 6:01 PM, Rajesh Janardanan wrote: > An urgent requirement ... your help would be much appreciated . > > On Fri, Dec 16, 2016 at 1:10 PM, Rajesh Janardanan > wrote: > >> Folks, >> >> Can you please help me in using index and match in the attached shee

$$Excel-Macros$$ Re: Help on Index and Match

2016-12-16 Thread Rajesh Janardanan
An urgent requirement ... your help would be much appreciated . On Fri, Dec 16, 2016 at 1:10 PM, Rajesh Janardanan wrote: > Folks, > > Can you please help me in using index and match in the attached sheet to > use to calculate distance between the cities ? > > regards > raj > -- Are you =EXP(E

$$Excel-Macros$$ Re: Help on Vlookup

2016-07-22 Thread deepu . dubey91
Replace =vl+VLOOKUP(E2,B2:C339,2,FALSE) first of all on this point, vlookup will not work, use instead Index and match* =INDEX(B1:B339,MATCH(E2,C1:C339,0))* *Regards* *Deepu* On Friday, 17 June 2016 12:52:48 UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel she

$$Excel-Macros$$ Re: Help on Vlookup

2016-07-19 Thread सचिन शर्मा
Hi PFA, Regards, Sachin On Friday, June 17, 2016 at 12:52:48 PM UTC+5:30, vikas khen wrote: > > Hi all, > > > > Need your help on attached excel sheet as my vlookup formula is not > reflecting the value. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

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

2016-02-24 Thread abhishek bhalla
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 takale"amartak...@gmail.com Sent:Thu, 25 Feb 2016 10:20:12 +0530 To: excel-macros@googlegroups.com Subje

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

2016-01-14 Thread Mandeep Baluja
> > 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

2016-01-14 Thread Neeraj Chauhan
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

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

2016-01-14 Thread Mandeep Baluja
] *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

2016-01-14 Thread Neeraj Chauhan
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

$$Excel-Macros$$ Re: Help Required

2016-01-14 Thread Mandeep Baluja
> > 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

$$Excel-Macros$$ Re: help on find the list matches to the cell part value

2015-12-23 Thread Pawan Yadav
You can use this formula also: *=IF(ISERROR(MATCH(MID(E2,FIND("/",E2)+1,LEN(E2))+0,$A:$A,0)),"No","Yes")* Regards, Pawan On Tuesday, 22 December 2015 17:08:03 UTC+5:30, Ganesh N wrote: > > Dear team, > > I want to find the any of the given list of value matches (part) in the > particular cell u

$$Excel-Macros$$ Re: help to concatenate function.

2015-12-02 Thread Mandeep Baluja
> > Check this attachment !! regards, Mandeep > -- 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 t

$$Excel-Macros$$ Re: help required

2015-11-22 Thread GENIUS
> 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

Re: $$Excel-Macros$$ Re: Help with Custom Vlookup

2015-11-03 Thread Abhishek Jain
Thanks Mandeep ji, I do know that cell has a limit of characters, but my each returning value has only 3 characters and max possible matches are 10 per lookup value, so the maximum characters per cell would be 30. I guess that's not the issue there. Nevertheless, I would look into the alternate y

$$Excel-Macros$$ Re: Help with Custom Vlookup

2015-11-03 Thread Mandeep Baluja
> > Boss, First thing you should know is the Cell limit is limited,So in case > Your the length of Concatenated lookup values characters is greater than > cell limit it will turned out be #VALUE Error or The best one "MICROSOFT > EXCEL IS NOT RESPONDING" :) You can use a different approach/Ma

$$Excel-Macros$$ Re: HELP REQUIRED

2015-10-26 Thread GENIUS
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

2015-08-04 Thread Gaurav Devrani
[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, >

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

2015-08-04 Thread Neeraj Chauhan
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 then

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

2015-08-04 Thread Anand Tiwari
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 wrote: > Dear experts I want to change the date format > > > > Date > > I want this format > > 31/7/2015 > > 31-Jul-15 >

$$Excel-Macros$$ RE: Help required

2015-08-04 Thread Neeraj Chauhan
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 RULES

$$Excel-Macros$$ Re: Help needed on average formula

2015-07-01 Thread Mandeep Baluja
That formula is doing the same as required !! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Wednesday, July 1, 2015 at 9:22:39 AM UTC+5:30, Kumar Bhanushali wrote: > > > *Dear Mandeep,* > > Ple

$$Excel-Macros$$ Re: Help for error :Excel help viewer has encountered a problem & cannot continue.

2015-06-11 Thread Michael Vinoth
Hi Rohit, Check this :- http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae Regards, MV On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote: > Hi > I'm not able to access any hel

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

2015-05-20 Thread Neeraj
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

2015-05-20 Thread Mandeep Baluja
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 for

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

2015-05-18 Thread Nasir Saikh
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 d

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

2015-05-18 Thread Mandeep Baluja
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.

2015-05-18 Thread Nasir Saikh
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 exampl

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

2015-05-18 Thread Mandeep Baluja
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 Miscel

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

2015-05-18 Thread Nasir Saikh
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 Acciden

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

2015-05-18 Thread Mandeep Baluja
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 data

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

2015-05-06 Thread Mandeep Baluja
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 Mandee

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

2015-05-05 Thread Rakesh
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 www.ericsson.

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

2015-05-05 Thread Mandeep Baluja
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 und

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

2015-05-05 Thread Rakesh
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, IND

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

2015-05-05 Thread Mandeep Baluja
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 https://www.facebook

Re: $$Excel-Macros$$ Re: Help needed

2015-04-15 Thread Prashant Pednekar
Dear Kumar, Deciding min Max level based on 3 month data is bit unscientific,you need to have at least 6 months data. Based on data provided by you, I have answered your queries. As mentioned by you GEOFORCE is external warehouse. It is not clear if the stock at other location is replenished from

$$Excel-Macros$$ Re: Help needed

2015-04-15 Thread kumar
Hi, Any one looked at it? On Wednesday, April 15, 2015 at 3:13:43 PM UTC+1, kumar wrote: > > Hi, > > Just want to solve the questions with analysis. > please find the enclosed attachment and answer the question. I also trying > to solve. But needed Gurus help. > > Thanks > -- Are you =EXP(E:RT

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

2015-03-17 Thread Ashu k
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 title

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

2015-03-17 Thread Ashu k
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 RULE

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

2015-03-16 Thread Mandeep baluja
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 2.

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

2015-03-16 Thread Mandeep baluja
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. Exa

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

2015-03-16 Thread Mandeep baluja
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 D

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

2015-03-16 Thread Ashu k
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 wrote: Dear Mandeep Sir, Please Help on the same issue. Can i explain again my query. P

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Ashu k
Dear Mandeep Sir, I am big fan of yours..! 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 ti

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i have started learning Excel techniques and admire your logics of Macros. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Mon

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will So

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hey Will Check this attachment..in any of given columns it will check occurrence of 10 , 13 & 17 in any order... Hope you like it,.,. Cheers!! On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote: > Gosh l like this method thanks a lot. This is the best l have seen most > appreciated > > On Mon,

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Gosh l like this method thanks a lot. This is the best l have seen most appreciated On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15

$$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) com

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, "Will Sob" wrote: > Thanks for responding yes in a single row. H l would like to know > about both methods of you can most appreciated > Tell me two things > > is the triplet combination your searching in single

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Thanks for responding yes in a single row. H l would like to know about both methods of you can most appreciated Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
thanks for your reply: l have loads of values, l am trying to build a template where when l place numbers it should tell me how many triplet combination exist within a range 10, 13, 17 1,19, 22 7, 21,22 On Mon, Mar 16, 2015 at 4:25 AM, Mandeep Baluja wrote: > send me the values which you are t

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Mandeep Baluja
send me the values which you are trying to get On Monday, March 16, 2015 at 3:24:40 AM UTC+5:30, Will Sob wrote: > > thanks but it is not working when l use other values > > On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja > wrote: > >> Check this attachment achieved with a macro. Change your num

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja wrote: > Check this attachment achieved with a macro. Change your numbers > combination as per your requirement. > > Regards, > MandeepBaluja > Learningzmypassion. > https://www.facebook.com/VBA

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Mandeep baluja
Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Sunday, 15 March 2015 23:04:26 UTC+5:30, Will So

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-15 Thread Will Sob
l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan wrote: > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) combination has appeared wit

$$Excel-Macros$$ Re: Help with combination formula

2015-03-14 Thread sahemur khan
On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > Hi,  > Please I need help with the attached file. I want a formula that calculates > how many times (10, 13, 17) combination has appeared within the range D5:I32 > > > > > > > > > > > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i

$$Excel-Macros$$ Re: Help: Chart/graph required for multiple rows/columns

2015-03-10 Thread Maciej Piotrowicz
Hi If it's still valid please answer. I suppose in sample sheet WW is the base. You want to create sheets named as in column B with charts (only?) corresponding to data next to name in B? I can't see macro in sample so I can't solve problem with graph name changing. Waiting for response then

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread michael vinoth
Dear Friend Dhaval, Thanks for your comments. As per the given requirement i thought this would be the suitable coding. May be I am not understand you exact requirement properly. If possible could you please let me know you requirement clearly once again so that I can try to help you to solve the

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread Vaibhav Joshi
Try this... Press Alt + F8 & Run macro, on prompt enter date for which you are updating data..macro will copy data from daily data sheet to main sheet... Cheers!! On Mon, Mar 2, 2015 at 3:53 PM, Dhaval Shah wrote: > ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? > > Warm Regards, > > Dhaval Sh

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread Dhaval Shah
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah wrote: > THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I > UPDATE ITS PASTE WRONGLY > > Warm Regards, >

Re: $$Excel-Macros$$ Re: Help Needed

2015-03-02 Thread Dhaval Shah
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I UPDATE ITS PASTE WRONGLY Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth wrote: > Hi Dhaval Shah, > > Please find the attached macro file. > > Re

$$Excel-Macros$$ Re: Help Needed

2015-03-01 Thread michael vinoth
Hi Dhaval Shah, Please find the attached macro file. Regards, MV On Saturday, February 28, 2015 at 2:41:50 PM UTC+5:30, Dhaval Shah wrote: > > Dear Friends > > Pls find attached file of my work > > In sheet two sheets one is main sheet & another is daily data > > in main sheet yellow mark is

$$Excel-Macros$$ Re: Help required

2015-02-24 Thread Maciej Piotrowicz
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 with excel data fill formula

2015-02-11 Thread Paul Schreiner
you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Enock Wangila >To: excel-macros@googlegroups.com >Sent: Wednesday, February 11, 2015 10:13 AM >Subject: Re: $$Excel-Mac

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Enock Wangila
gt;> From: Enock Wangila >>To: excel-macros@googlegroups.com >>Sent: Wednesday, February 11, 2015 9:15 AM >>Subject: $$Excel-Macros$$ Re: Help with excel data fill formula >> >> >> >> >> >>Hi, >> >> >>Thank you Paul for the respons

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
__ > From: Enock Wangila >To: excel-macros@googlegroups.com >Sent: Wednesday, February 11, 2015 9:15 AM >Subject: $$Excel-Macros$$ Re: Help with excel data fill formula > > > > > >Hi, > > >Thank you Paul for the response. It is what I

$$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Enock Wangila
Hi, Thank you Paul for the response. It is what I was looking out for. Just one more question, could the formula fill up the cells without having to drag it? If one exists, will much appreciate. Cheers. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO

Re: $$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Paul Schreiner
times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Enock Wangila >To: excel-macros@googlegroups.com >Sent: Wednesday, February 11, 2015 5:54 AM >Subject: $$Excel-Macros$$ Re: Help with excel data fill formula > > > > > >Here is an il

$$Excel-Macros$$ Re: Help with excel data fill formula

2015-02-11 Thread Enock Wangila
> Here is an illustration of what I am requesting for. I hope it helps make > the case clearer. > Cheers -- 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 FOR

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

2015-01-16 Thread Ashu k
Dear Mandeep Sir, Please help. kindly send the macro. Regards Ashu Kenith. On Thu, Jan 15, 2015 at 6:41 PM, Ashu k 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 at 12:30 PM, A

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

2015-01-15 Thread Ashu k
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 wrote: > https://m.facebook.com/VBAEXCELSQL

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

2015-01-15 Thread Mandeep Baluja
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)) in

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

2015-01-15 Thread Ashu k
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 wrote: > Dear Mandeep Sir, > > Please help. > > Regards > Ashu Kenith. > > > On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote: > >> Dear M

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

2015-01-14 Thread Ashu k
Dear Mandeep Sir, Please help. Regards Ashu Kenith. On Tue, Jan 13, 2015 at 6:37 PM, Ashu k 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 mail body which w

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

2015-01-13 Thread Ashu k
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 mail body which was belongs to Same Merchant ID. Example : - Merchant ID is 12345 and 10 orders is placed by this merchant, then pas

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

2015-01-13 Thread Mandeep Baluja
> > Try this Ashu k , This must meet your requirements. Thanks to RonDBurn Blog. 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?

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

2015-01-13 Thread Ashu k
Dear Mandeep Sir, Please Help. Regards Ashu Kenith. On Wed, Jan 7, 2015 at 4:18 PM, Ashu k 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 that as p

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

2015-01-08 Thread Ashu k
Dear Mandeep Sir, Please Help!! Thanks Ashu Kenith. On Wed, Jan 7, 2015 at 4:18 PM, Ashu k 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 that

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

2015-01-07 Thread Ashu k
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 Name

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

2015-01-07 Thread Mandeep Baluja
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

2015-01-07 Thread Ashu k
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 n

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

2015-01-07 Thread Ashu k
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 punch

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

2015-01-07 Thread Mandeep Baluja
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

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

2015-01-07 Thread Anil Gawli
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 wrote: > Dear Mandeep Sir, > >

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

2015-01-06 Thread Ashu k
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 FORUM

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

2015-01-06 Thread Mandeep Baluja
> > 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

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

2015-01-06 Thread Ashu k
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 wrote: > Hey Ashu, > > > Check this sh

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

2015-01-06 Thread Mandeep Baluja
> > 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 f

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

2015-01-06 Thread Paul Schreiner
--------- From: Ashu k >To: Mandeep Baluja ; excel-macros > >Sent: 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

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

2015-01-06 Thread Ashu k
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 Date: Wed, Dec 31, 2014 at 11:52 AM Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA To: Mandeep Baluja

  1   2   3   4   5   6   7   >