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

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 > ActiveSheet.Paste > Applicat

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 sheet I want to put last two

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 using index and match in the attached shee

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

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

Multiply date with 1 On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote: > > Dear sir, > > > > Thanks sir !! > > Kindly share the formula. > > > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *Mandeep Baluja > *Sent:* Thursda

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 close

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 y

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

[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

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

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 >

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

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 Mandee

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

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 und

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

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 from

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 title

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 RULE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 wrote: > ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ?? > > Warm Regards, > > Dhaval Sh

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

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

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

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

I have no VBA coding experience. Could you refer me to a resource that I can use to write the command or a better alternative. On 2/11/15, Paul Schreiner wrote: > Sorry, EXCEL functions cannot act on other cells. > > If you wanted to write a VBA macro, then this could be done. > You could even

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

Sorry, EXCEL functions cannot act on other cells. If you wanted to write a VBA macro, then this could be done. You could even make it an "event" macro on "Worksheet one" such that when the values in the two cells change, "worksheet two" automatically updates. Paul -

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

Hmm.. your question and expectations are unclear. a "formula" technically is an equation that may or may not contain functions. =TODAY() + 3 is a formula that uses the TODAY() function to calculate the date 3 days from the current date. >From your question, you want to insert a specified val

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

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

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

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

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

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

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

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

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

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 n

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 punch

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 wrote: > Dear Mandeep Sir, > >

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 FORUM

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 wrote: > Hey Ashu, > > > Check this sh

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 wrote: > Now this macro works for 3 lakh rows you can increase the range as per > your convenience. > > Regards, >

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 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 Ashish Sir & Vaibhav

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 P

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 wrote: > > check this out. > > Regards, > Mandeep Baluja > LearningZmyPassion > https://www.linkedin.com/profile/view?id=312532939 > https://www.facebook.com/VBAEXCELSQL?ref=hl > > On Wednesday,

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 wrote: > Dear experts, > > > > We have given below date format how to convert right format of date like > 13-Jan-2014

Re: $$Excel-Macros$$ Re: help!!! creation code from data in cells

can u share excel file On Thu, Jan 9, 2014 at 5:07 PM, pmyk wrote: > In an excel file, > Change Sheet1 Name as Report and type these: > Sr. Center Name Course Date of Enrol Code > 1 Alma Computer Training Institute Suraj basic computer Course 31/12/13 > 2 Center3 Name1 Course 5 1/1/2014 > 3 Cen

Re: $$Excel-Macros$$ Re: Help in creating macro to identify number of people birthday on particular day in a month

can you share a sample file On Fri, Dec 13, 2013 at 1:36 PM, Reyn wrote: > well, just need to wait for someone to get this.. ((= >> > -- > 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.

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 quart

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

=MID(A1,(FIND(5,A1)),6) Regards, Vijay On Fri, Apr 12, 2013 at 12:00 PM, Prince wrote: > =IF(LEFT(A1,1)="B",LEFT(A1,6),"") > > On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote: >> >> Hi Team, >> >> I need a formula to find anything starting from 5 in a cell and to take 6 >> digit

Re: $$Excel-Macros$$ Re: Help with INSTR

Hi Matt, When you press Ctr+R (on active VBA Editor) you can see vba projects window on left side of all of the active workbooks. You can see the available sheet name there. Regards, Anoop Sr. Developer On Fri, Dec 21, 2012 at 12:25 AM, Matt wrote: > Hi Anoop, > > That worked perfectly! My on

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 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, neeraj chauhan

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 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, neeraj chauha

RE: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

groups.com] On Behalf Of Aamir Shahzad Sent: Wednesday, October 24, 2012 11:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup I have registered thanks as well On Thu, Oct 25, 2012 at 11:06 AM, ashish damor wrote: Dear Aamir,

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

I have registered thanks as well On Thu, Oct 25, 2012 at 11:06 AM, ashish damor wrote: > Dear Aamir, > > The registration is free and it does not take even 5 minutes to register. > > On Thu, Oct 25, 2012 at 10:52 AM, Aamir Shahzad > wrote: > > Dear Rajan, > > > > If you have file plz share with

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Dear Aamir, The registration is free and it does not take even 5 minutes to register. On Thu, Oct 25, 2012 at 10:52 AM, Aamir Shahzad wrote: > Dear Rajan, > > If you have file plz share with us, your required link want to register > first. > > > > On Thu, Oct 25, 2012 at 8:23 AM, Rajan_Verma >

Re: $$Excel-Macros$$ Re: Help need to get multiple values by vlookup

Dear Rajan, If you have file plz share with us, your required link want to register first. On Thu, Oct 25, 2012 at 8:23 AM, Rajan_Verma wrote: > Hi > > Download the file from here > > http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/ > > Thanks > Rajan. > > On Wednesday, 24 Oc

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

Really great that solve my purpose Very very thanks. On Sat, Oct 6, 2012 at 4:08 PM, Ms-Exl-Learner . wrote: > Hi Shrinivas, > > Below is the revised code. > > '* > > Option Explicit > Sub PreserveData() > Dim bWs As Worksheet, sName

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

Hi Shrinivas, A sample workbook with the parameters and the expected output will be helpful for giving exact solution. <><><><><><><> *Ms-Exl-Learner* <><><><><><><> On 06-10-2012 9:01 AM, Shrinivas Shevde wrote: Dear Excel Learner First of all sorry for delay. Thanks for the reply and thi

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

Dear Excel Learner First of all sorry for delay. Thanks for the reply and this is exactly I want. Can u help me little more In a master sheet there is sample Name I want to put 2 or 3 (may be more)more parameter like ,Date, Created by ,Cost etc.and all this should get transfer to respective sheet.

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

Please find attached sheet Thanks in advance On Wed, Oct 3, 2012 at 6:00 PM, Don Guillett wrote: > Provide a file with this to dguillett1 @gmail.com > > > On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote: >> >> Dear All >> Can Any one help me to write a macro for following things. >>

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

Dear Don, Thanks for reply. Please find details what I want. 1.I have many raw material.Consider I have 50 raw material 2.I want to make a sample with this raw material.While making sample I will use some of the material out of 50 .% of the material wull vary . 3.To do this what I noted down all t

Re: $$Excel-Macros$$ Re: help with creating macro to format list

Sub tests() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Sheets("New").UsedRange.Borders.LineStyle = Excel.XlLineStyle.xlLineStyleNone Dim i As Long For i = 2 To Sheets("New").Range("a65356").End(xlUp).Row If Sheets("New")

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

Sorry for delay Thanks Dear... On Sat, Jun 30, 2012 at 12:51 AM, Prince Dubey wrote: > Hi manoj, > > Please Use this I hope this will work for you.. > > > SELECT distinct [Store ID] > FROM [Acer All Data]; > > union > > > SELECT distinct [Store ID] > FROM [Mar'12]; > union > SELECT distinct

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

where is the option of Tab_Data... On Fri, Jun 29, 2012 at 3:37 PM, Lalit_Mohan wrote: > HI Manoj, > > You can try this query in database may be it helps you > > select id from Tab_Data GROUP BY id > > (where id is the field name and Tab_Data is table name. you can add more > columns to it just

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

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 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 and in cor

Re: $$Excel-Macros$$ Re: Help me to generate Report

Hi Ankit, Please attach file for the reference. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 4:10 PM, CoRe wrote: > More infos , less gibberish please. > > On Friday, May 4, 2012 11:30:18 A

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

My latest adobe update seems to have an option, under tools, to convert to word or excel Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Monday, April 23, 2012 8:52 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Help

RE: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

No From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shekhar Sharma Sent: Apr/Mon/2012 05:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA Hi Thanks for the link

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

Hi Thanks for the link, however is it possible to do this job via VBA? Regards Shekhar Sharma On Fri, Apr 20, 2012 at 8:33 PM, ChilExcel wrote: > Please see > http://www.minipdf.com/ > > I tried it and it works fine ...jpg at xls > > Chilexcel > 2012/4/20 Shekhar Sharma > >> Hey Kris, >> >>

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

Please see http://www.minipdf.com/ I tried it and it works fine ...jpg at xls Chilexcel 2012/4/20 Shekhar Sharma > Hey Kris, > > Thanks for the quick response, however I am looking for the code for not > just adding the image in excel. > I want to use the the data available in that picture to

Re: $$Excel-Macros$$ Re: Help needed- Converting JPG format file to Excel file via VBA

Hey Kris, Thanks for the quick response, however I am looking for the code for not just adding the image in excel. I want to use the the data available in that picture to further make the changes in excel. Example: I had the data set available in excel like, result out of 100: Student Name

RE: $$Excel-Macros$$ Re: Help to find position of a particular number in a given data set

Hi Atul, Not as tidy as Haseeb's response, But here is one solution: In C2: =IF(ROW(C$2)=ROW(),LARGE($B$2:$B$11,1),LARGE($B$2:$B$11,ROWS($B$2:$B$11)-COU NTIF($B$2:$B$11,"<"&INDEX(C$2:C$11,ROW()-2))+1)) In D2: =MATCH($B2,$C$2:$C$11,-1) Highlight and copy down. Your ranking is in column

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

Please excuse my delayed reply. I just tried running the code that you provided in the attachment above. The code seems to be absolutely fine. The only thing, that may have caused trouble, if you did not enter the dates in the correct format. Please ensure that you enter the date in the same format

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

Dear Rohan very very thanks please let me know where I did mistake Regards Shrinivas On Mon, Jan 16, 2012 at 9:55 PM, Sam Mathai Chacko wrote: > Here's how you do it. > > Regards, > Sam Mathai Chacko > > On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde < > shrinivas...@gmail.com> wrote: > >> D

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

Here's how you do it. Regards, Sam Mathai Chacko On Mon, Jan 16, 2012 at 12:26 PM, Shrinivas Shevde wrote: > Dear Rohan > I was trying to do it for me but I could not I am attaching the work sheet > Please do it and please let me know what is the problem Why I could not do > it? > If I am doing

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

Dear Rohan I was trying to do it for me but I could not I am attaching the work sheet Please do it and please let me know what is the problem Why I could not do it? If I am doing it I can see only heading Please help Thanks in advanced Regards Shrinivas On Tue, Dec 20, 2011 at 7:11 PM, Shrinivas S

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

Very very thanks for help On Mon, Dec 19, 2011 at 1:10 PM, Rohan wrote: > If you can replicate this for your own sheetwell and good. Else > send the worksheet over the group as an attachemnt and I will work > that out. !! Thank you ! > > > Sub Test() > Dim SDate As DateDim EDate As D

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

If you can replicate this for your own sheetwell and good. Else send the worksheet over the group as an attachemnt and I will work that out. !! Thank you ! Sub Test()     Dim SDate As Date    Dim EDate As Date        LR = Range("A1").End(xlDown).Row    SDate = InputBox("Put the date from when

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

attach or send me your file with a better explanation and examples. Don Guillett SalesAid Software dguille...@gmail.com From: Shrinivas Shevde Sent: Friday, December 16, 2011 10:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Help On Print Dear Rohan Thanks for the

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

Dear Rohan Thanks for the help. But To filter I need to be present in front of the computer and I right now I want to take out the print for more than 2 years (nearly 600+ print) So I want some kind of macro or something like where I can give "from date" to "to date" and I can do some other work

Re: $$Excel-Macros$$ Re: Help on Indirect Formula

Dear Haseeb, Superb !!! Its working perfectly :-) Can you please exlain me on what is 9e+300 used for ??? cheers JP. On Sat, Nov 12, 2011 at 12:47 AM, Haseeb Avarakkan wrote: > Hello JP, Please do not post multiple thread for the same query. > > In Summary B4, copy down & across. > > =LOOKUP

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

There you go =SUM(INDIRECT("'2011 Actual'!$C$3:"&ADDRESS(3,MATCH("*"&TEXT('Monthly IS'!$J$3,"MM/YY")&"*",'2011 Actual'!$A$1:$N$1,0 On Aug 26, 2:28 am, Steve Weaver wrote: > Thank you Sam for this suggestion. However, the formula doesn't provide > the results that I am looking for. > > The fo

  1   2   >