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

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,

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

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. > >

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

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" &

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

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 >

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

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.

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

$$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 on sumif function

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

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

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

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

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

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

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

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

$$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 on find the list matches to the cell part value

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

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

> > 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

$$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

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

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

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

> > 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

$$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

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

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,* Please

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

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 help

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 needed

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

$$Excel-Macros$$ Re: Help needed

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) or

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 with combination formula

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

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

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

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 mandeepbal...@gmail.com wrote: Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday,

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

Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja mandeepbal...@gmail.com 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

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

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 will00...@gmail.com wrote: Gosh l like this method thanks a lot. This is the best l have seen most

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

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

$$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

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

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

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

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

Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, Will Sob will00...@gmail.com 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

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

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)

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

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

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

l'm sorry please see attachment On Sun, Mar 15, 2015 at 2:45 AM, sahemur khan sahe...@gmail.com 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

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

thanks but it is not working when l use other values On Sun, Mar 15, 2015 at 7:11 PM, Mandeep baluja mandeepbal...@gmail.com wrote: Check this attachment achieved with a macro. Change your numbers combination as per your requirement. Regards, MandeepBaluja Learningzmypassion.

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

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 mandee...@gmail.com javascript: wrote: Check this attachment achieved with

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

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 rockerna...@gmail.com wrote: send me the

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

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)) in Excel? And

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

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

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

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 todhavals...@gmail.com wrote: ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? Warm

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

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

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

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 todhavals...@gmail.com* On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com wrote: Hi Dhaval Shah,

$$Excel-Macros$$ Re: Help Needed

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 the

$$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 with excel data fill formula

Wangila ekwang...@gmail.com 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 was looking out for. Just one more question, could the formula fill up

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

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

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

the people you can, As long as ever you can.” - John Wesley - From: Enock Wangila ekwang...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, February 11, 2015 10:13 AM Subject: Re: $$Excel-Macros$$ Re: Help

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

Subject: $$Excel-Macros$$ Re: Help with excel data fill formula 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

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

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 FORUM

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

Wangila ekwang...@gmail.com 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 illustration of what I am requesting for. I hope it helps make the case clearer. Cheers -- Are you =EXP

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

  1   2   3   4   5   >