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

Thanksa ton Sourav. You kind help is highly appreciated. On Wed, Aug 3, 2016 at 7:46 PM, sourav devrani wrote: > please use this file. > i have change some little formula here you can use this file. > > Regards > Sourav Devrani > > On Wed, Aug 3, 2016 at 7:10 AM,

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

please use this file. i have change some little formula here you can use this file. Regards Sourav Devrani On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani wrote: > please see the attached file. > > On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman

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

please see the attached file. On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman wrote: > Is there any one who can solve this, please ? > > On Aug 2, 2016 23:38, "Jayanta Barman" wrote: > >> Hello Excel experts, >> >> I have a small problem in

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

Is there any one who can solve this, please ? On Aug 2, 2016 23:38, "Jayanta Barman" wrote: > Hello Excel experts, > > I have a small problem in excel. Please help me in resolving this. > > Problem: I have a set of products launched at different years with their >

$$Excel-Macros$$ Please help me

Hello Excel experts, I have a small problem in excel. Please help me in resolving this. Problem: I have a set of products launched at different years with their revenue figures. I want to create another table wherein all the product sales will be displayed from their first year. I have attached

$$Excel-Macros$$ please help

Dear Sir, Help Needed Regards, Kumar Bhanushali DISCLAIMER The information contained in this e-mail including attachment is meant only for the addressee and may contain confidential and privileged information. Any use, distribution, printing, retransmission, dissemination, copying or

Re: $$Excel-Macros$$ please help

hi, How i disable cut and paste in word 2007 file. On Mon, Jun 8, 2015 at 9:25 AM, Kumar Bhanushali kumar.bhanush...@pmcprojects.com wrote: *Dear Sir,* In attached file, Basic sheet is there. In that sheet I had created 4 buttons, Namely, For RA, For Adhoc, Above, Below. With which macro

Re: $$Excel-Macros$$ Please help in dividing equal numbers

as per your requirement On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote: how can you have bundle of 150, this should be bundle of 50 i think... On Fri, May 29, 2015 at 11:12 AM, Rashi Singh rashising...@gmail.com wrote: Yes Yes, Actually Say i have to give Rs. 2250 to

Re: $$Excel-Macros$$ Please help in dividing equal numbers

Ok I have only assume that there is 150, Ok no problem lest 50 Rs. Now my query is Distribute 100 and 50 to make total amount of Rs. 2250. Thanks for your revert. On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote: how can you have bundle of 150, this should be bundle of 50

Re: $$Excel-Macros$$ Please help in dividing equal numbers

Thank you so much, those result are as i expected. Thank you so much. I will study this formula, since i new to excel formulas. Regards, Rashi On Fri, May 29, 2015 at 11:31 AM, Titu Sharma niks...@gmail.com wrote: as per your requirement On Fri, May 29, 2015 at 11:25 AM, Titu Sharma

Re: $$Excel-Macros$$ Please help in dividing equal numbers

updated as per 50 On Fri, May 29, 2015 at 11:31 AM, Titu Sharma niks...@gmail.com wrote: as per your requirement On Fri, May 29, 2015 at 11:25 AM, Titu Sharma niks...@gmail.com wrote: how can you have bundle of 150, this should be bundle of 50 i think... On Fri, May 29, 2015 at 11:12 AM,

Re: $$Excel-Macros$$ Please help in dividing equal numbers

you are welcome On Fri, May 29, 2015 at 11:36 AM, Rashi Singh rashising...@gmail.com wrote: Thank you so much, those result are as i expected. Thank you so much. I will study this formula, since i new to excel formulas. Regards, Rashi On Fri, May 29, 2015 at 11:31 AM, Titu Sharma

Re: $$Excel-Macros$$ Please help in dividing equal numbers

What's your criteria for how many 100 or 150 you can use. On Fri, May 29, 2015 at 10:04 AM, Rashi Singh rashising...@gmail.com wrote: Dear all, Please help in enclosed problem solution. i have tried many and even googled, but i am unable to create formula. Have exlplained xl sheet, please

Re: $$Excel-Macros$$ Please help in dividing equal numbers

how can you have bundle of 150, this should be bundle of 50 i think... On Fri, May 29, 2015 at 11:12 AM, Rashi Singh rashising...@gmail.com wrote: Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume). Now How many

Re: $$Excel-Macros$$ Please help in dividing equal numbers

please explain your query On Fri, May 29, 2015 at 10:04 AM, Rashi Singh rashising...@gmail.com wrote: Dear all, Please help in enclosed problem solution. i have tried many and even googled, but i am unable to create formula. Have exlplained xl sheet, please find. Regards, Rashi --

Re: $$Excel-Macros$$ Please help in dividing equal numbers

Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume). Now How many Rs 100 have to take out from my drawer and Rs. 150 from my drawer. to equivalent Rs. 2250. Hope i could able to explain my query ! Thanks in advance

$$Excel-Macros$$ Please help in dividing equal numbers

Dear all, Please help in enclosed problem solution. i have tried many and even googled, but i am unable to create formula. Have exlplained xl sheet, please find. Regards, Rashi -- 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

Re: $$Excel-Macros$$ Please help with Activex cannot insert object. error

, April 23, 2015 3:58 AM Subject: $$Excel-Macros$$ Please help with Activex cannot insert object. error Hi I have been experiencing this error recently in Excel 2007. Whenever try to add any ACTIVEX buttons to my worksheet I get an error cannot insert object. The screenshot is attached here. I

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

Dat's Cool Vaibhav. Thanks. On Wed, Mar 11, 2015 at 11:32 PM, Michael Vinoth michaelvino...@gmail.com wrote: Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9,

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

Very Nice... Mr.Vabz On Wednesday, March 11, 2015 at 6:33:10 PM UTC+5:30, Vabz wrote: Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9, you will get result in curly bracket, after = sign enter CONCATENATE( press enter to get result

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

Suppose you have value in cell A1 then type follo. formula in A2 dont press enter press F9, you will get result in curly bracket, after = sign enter CONCATENATE( press enter to get result

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

,To all the people you can,As long as ever you can.” - John Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 11:55 AM *Subject:* Re: $$Excel-Macros$$ Please help me Urgent

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

- From: Gaurav Devrani gauravdev1...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, February 26, 2015 10:12 AM Subject: $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper

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

Wesley* - *From:* Gaurav Devrani gauravdev1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, February 26, 2015 10:12 AM *Subject:* $$Excel-Macros$$ Please help me Urgent Hi Guys, I have a query . In this sentence.. This iS a tEst

$$Excel-Macros$$ Please help me Urgent

Hi Guys, I have a query . In this sentence.. This iS a tEst . All Upper case alphabets should be lower case and All Lowercase alphabets should be in Upper case. Please help me . I want that to be done in excel formulas.(If thats possible). Thanks Regards Gaurav Devrani -- Are you

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

, 2015 11:55 AM Subject: Re: $$Excel-Macros$$ Please help me Urgent Thanks Paul for your quick reply. Yes I was also trying to create a macro but Just wanted to confirm before, if that's possible in excel functions. No worries. I really appreciate your quick response once again. Thank you

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

Hi ivavok , Please find the attached file as per your requirement... On Fri, Oct 24, 2014 at 5:31 PM, ivavok ivana.vokrouhlik...@gmail.com wrote: Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way

Re: $$Excel-Macros$$ Please help on VBA- adjustments of a table with data

Hi pramodb35, Thank you very much for your help! It is almost perfect;) Please have a look at the file attached. I have tried it for more rows for each type and it does not work correctly in that case:( The type is then not correctly copied in each row of column type. I cannot figure out what

$$Excel-Macros$$ Please help on VBA- adjustments of a table with data

Hello, I would be grateful for help. I have had some break using VBA and I now need to get the table attached adjusted in a certain way to be able to work with it later on: 1/ keep the first row with headings 2/ insert a new column after the first column and name it: Type 3/ always take the

Re: $$Excel-Macros$$ please help for consolidate in excel

Dear Ganesh Ravinder, I am also have this issue. I saw your attachments, i don't know how to use this... Kindly give a brief explanation. On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N ganeshg...@gmail.com wrote: Hi Yadav, you can also use this. Just put the data files in separate folder

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that place. please suggest. On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: Hi You can do so by

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Hi I am not sure of this. Thx On Wed, Apr 30, 2014 at 3:34 PM, renuka chari jva.ch...@gmail.com wrote: Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear sir, i dont want to use pivot. i need only formula for offset or index is it possible... On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote: Hi You can do using Pivot Table, see attached file. 1. In the Pivot Table, click the drop down arrow in the RowLabels field

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Its not possible to do without any help column. Another way out is shown in attached file. Ref col E F. Thx On Tue, Apr 29, 2014 at 2:34 PM, renuka chari jva.ch...@gmail.com wrote: Dear sir, i dont want to use pivot. i need only formula for offset or index is it possible... On Tuesday,

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear sir, thank you so much.your given a great help.. On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote: Hi PFA alternate method using formula help sheet. Thanks On Tue, Apr 29, 2014 at 8:57 PM, renuka chari jva@gmail.comjavascript: wrote: Dear sir,

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear Sir, countif function creating more violation for huge data range. is there any possible to overcome or use any other function. please guide me... thanks... On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote: Dear sir, thank you so much.your

$$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Dear experts, please help me Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

Hi You can do using Pivot Table, see attached file. 1. In the Pivot Table, click the drop down arrow in the RowLabels field heading. 2. In the pop-up menu, click Value Filters, then click Top 10 change it to 5. You can sort on Descending on Output by going thru More Sort option

Re: $$Excel-Macros$$ please help for consolidate in excel

Hi Yadav, you can also use this. Just put the data files in separate folder and put the path in cell J2. Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi v...@vabs.in wrote: Hi, You can try this excellent codes share by Ashish earlier this month: Sub merge()

Re: $$Excel-Macros$$ please help for consolidate in excel

Please see below link for your query.. u just need to select folder where u have saved the files. please dont save example file in data files folder http://excelvbasupport.com/forum/showthread.php?tid=17 On Sat, Apr 26, 2014 at 11:18 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Yadav, you

$$Excel-Macros$$ please help for consolidate in excel

Hi All, I have some data for date wise but I want all excel file in one sheet through macro. Example. Regards, Jitendra//9650449202 -- 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$$ please help for consolidate in excel

Hi, You can try this excellent codes share by Ashish earlier this month: Sub merge() Dim fld As Object, fil As Object, fso As Object, fldpath With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .Show End With On Error Resume Next

Re: $$Excel-Macros$$ Please Help

/ H:MM) with CSE *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar *Sent:* Thursday, January 30, 2014 11:37 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Please Help Dear all, find the maximum Enroll

RE: $$Excel-Macros$$ Please Help

=TEXT(MAX((H2=$B$2:$B$1944)*$D$2:$D$1944),MM/DD/ H:MM) with CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh kumar Sent: Thursday, January 30, 2014 11:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear

Re: $$Excel-Macros$$ Please Help

:* Thursday, January 30, 2014 11:37 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Please Help Dear all, find the maximum Enroll date of particular location, Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Are you =EXP(E:RT

$$Excel-Macros$$ Please Help

Hi, I need to open a new notepad(Not saves so far, blank file) using vba code. And need to write text into it and save after that. Could any one help me on this.. As I have searched a lot for the codes, but what the codes I got are not completely helpful. Thanks, Sreekanth -- Are you

Re: $$Excel-Macros$$ Please help on FileName = Dir()

- From: maksood alam 786maks...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, December 4, 2013 2:05 PM Subject: $$Excel-Macros$$ Please help on FileName = Dir() Hi Guys, Can anyone please explaint what  FileName = Dir() is doing in below code. Public Sub RecursiveDir(ByVal

Re: $$Excel-Macros$$ Please help on FileName = Dir()

you can,At all the times you can,To all the people you can,As long as ever you can.” - John Wesley* - *From:* maksood alam 786maks...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wednesday, December 4, 2013 2:05 PM *Subject:* $$Excel-Macros

$$Excel-Macros$$ Please help on FileName = Dir()

Hi Guys, Can anyone please explaint what *FileName = Dir() *is doing in below code. Public Sub RecursiveDir(ByVal CurrDir As String, Optional ByVal Level As Long) Dim Dirs() As String Dim NumDirs As Long Dim FileName As String Dim PathAndName As String Dim i As Long Dim Filesize As Double '

$$Excel-Macros$$ Please help us with this Excel collaboration survey and win $50 Amazon gift card

Hey Microsoft Excel users! We are interested in how you use Excel in your professional life. Take this survey for a chance to win one of five $50 Amazon gift cards! Survey Link:

$$Excel-Macros$$ Please help

Hi All, I have attached a file in this email. This is record of incidents that's updated on daily basis. and i required the last date incidents count. I have done pivot automatic and getting the problem to select the last date automatic. Please me to select the date automatic. -- ***Thanks

Re: $$Excel-Macros$$ Please help

Hi, Please find attached solution Hope its fulfill ur requirement *Thanks Regards,* *Santy* On Sat, Jul 20, 2013 at 7:38 PM, Sanjay Kumar Maurya mail2sanja...@gmail.com wrote: Hi All, I have attached a file in this email. This is record of incidents that's updated on daily basis.

Re: $$Excel-Macros$$ Please help Excel Gurus

ratio just change the calculation in formula. Thanks Ravinder --- On *Tue, 6/4/13, Bé Trần Văn betnmtdongna...@gmail.com* wrote: From: Bé Trần Văn betnmtdongna...@gmail.com Subject: Re: $$Excel-Macros$$ Please help Excel Gurus To: excel-macros@googlegroups.com Date: Tuesday, June 4, 2013

$$Excel-Macros$$ Please help me adding variables to my macro

I am attaching a macro that I recorded. But I need the variables to be updated Basically this macro is going thru several tabs and update the pivot tables by simply changing the dates. So everytime I run the macro, I want dates in these pivot tables to be updated to today. Please look at

Re: $$Excel-Macros$$ Please help Excel Gurus

Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y py.har...@gmail.com wrote: Hi Every One, Please find the attached file, Kindly help me with

Re: $$Excel-Macros$$ Please help Excel Gurus

Formula Cell G5 =$F5/($E$5-$D$5) Fill down and fill right 2013/6/4 P.VIJAYKUMAR vijay.4...@gmail.com Respected Harish, On what ratio do you want to distribute the amount based on the date.what are the specific criteria for distributing. Regards, VIJAYKUMAR On Tue, Jun 4, 2013 at

Re: $$Excel-Macros$$ Please help Excel Gurus

Dear Vijay , I want to distribute it on per day basis. Regards Harish With Regards *HARISH P Y* *P** **THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it is really necessary. Thanks for your support to protect our environment for the future generation* *1 ream of paper =

$$Excel-Macros$$ Please help Excel Gurus

Hi Every One, Please find the attached file, Kindly help me with the required formula In the file there is a table, with start date end date amount and corresponding months in rows i want a formula to distribute the amount month wise by referring to start date and end date Kindly help me

$$Excel-Macros$$ please help to read the figures in words

Dear Friends Will any body help me to read the figures in words I want the read the figures given UNDER RATE IN FIG - RESULT IN FIGURES IN WORDS Thanks in advance -- GRKNAIDU -- 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

Re: $$Excel-Macros$$ please help me GRK

Dear GRKNAIDU, Please use this formula in the Bonus Qty column and copy down: =IF(MOD(J4,100)=0,(J4/100)*20,ROUNDDOWN(J4/100,0)*20) Regards, Aindril On Sat, Mar 2, 2013 at 5:33 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote: Dear all Will you please help to get the formula for an

$$Excel-Macros$$ Please Help

Dear Help Please help for below attached file. -- *Regards* -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

Re: $$Excel-Macros$$ Please Help

Hi Karthik, Please check if this your requirement, Regards, Jaysheel On Wed, Jan 9, 2013 at 8:07 PM, karthik N n.karthi...@gmail.com wrote: Dear Help Please help for below attached file. -- *Regards* -- Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Please Help

Hi Jayseel, Thank you for your replay, But i needed the In between Two difference date Hour min Thanks Karthik.N On Wed, Jan 9, 2013 at 8:17 PM, Jaysheel Bhasme jaysheel...@gmail.comwrote: Hi Karthik, Please check if this your requirement, Regards, Jaysheel On Wed, Jan 9, 2013 at

Re: $$Excel-Macros$$ Please Help

Your question is not that clear can you show an example about your requirement. if your looking for the difference then why don't you use Next activity - Last activity On Wed, Jan 9, 2013 at 8:23 PM, karthik N n.karthi...@gmail.com wrote: Hi Jayseel, Thank you for your replay, But i

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Glad it worked for you. On Tuesday, November 20, 2012 1:29:45 PM UTC-5, Mangesh wrote: Thank you so much Natron. You have made my work very easy. Thanks again. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate

Fwd: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Hi Friends, Please help me by providing the solution. Thanks in advance. -- Forwarded message -- From: Mangesh Vimay mangesh.da...@gmail.com Date: Tue, Nov 20, 2012 at 12:24 AM Subject: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

See attached, with the code I used below...there are many other ways to do this. 'This is hooked to your Export Specific Data Button on your form Private Sub cmdExport_Click() Dim intStart As Integer, intEnd As Integer On Error GoTo whoops intStart = Me.txtStart intEnd = Me.txtEnd

Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Thank you so much Natron. You have made my work very easy. Thanks again. On Tue, Nov 20, 2012 at 6:35 PM, Natron protoc...@gmail.com wrote: See attached, with the code I used below...there are many other ways to do this. 'This is hooked to your Export Specific Data Button on your form

$$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.

Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- Join

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's. Yes, but in the combobox Save as type: I don't have PDF format. Best regards, *Constantin ZAMFIR* Service engineer, Euritmic Grup SRL http

$$Excel-Macros$$ Please help me to set default folder for print PDF's.

I have a macro in an Excel document that print 5 sheets in different folders with different names. Always have to navigate to the desired folder and write the desired name, which slows my work, since I'm doing this for 30-50 times per day. I want to automate this in my macro, but I do not know

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help me to set default folder for print PDF's. I have a macro in an Excel document that print 5 sheets in different folders with different names. Always have to navigate to the desired folder and write the desired name

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

-- *From: * Constantin Zamfir costel...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Fri, 19 Oct 2012 10:35:38 -0700 (PDT) *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Please help me to set default

Re: $$Excel-Macros$$ Please HELP

No idea abt this Vist below links . See if they are useful http://www.sqaforums.com/showflat.php?Number=431568 http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/ActiveX-component-can-t-create-object-TDApiOle80-TDConnection/td-p/4742677#.UHRUTZjMhc0 On Tue, Oct 9, 2012 at 10:13 PM,

Re: $$Excel-Macros$$ Please Help to Find out the solution

...@gmail.com *From:* Wassi Agnihotri wassi4frie...@gmail.com *Sent:* Saturday, September 15, 2012 4:24 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Please Help to Find out the solution Hello Friends, I am new using vba excel. Please help me to find that how we can select after

Re: $$Excel-Macros$$ Please Help

$3))*((cold=$M$4)+(cold=$N$4)+(cold=$O$4))*cole) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Karan Singh Sent: Friday, September 07, 2012 12:12 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help Hi Jeet, I think you're

Re: $$Excel-Macros$$ Please Help

dguille...@gmail.com From: jeet singh Sent: Wednesday, September 05, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear All, plz find the attachment and help Regards Jeet -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Please Help

Software dguille...@gmail.com From: jeet singh Sent: Wednesday, September 05, 2012 11:58 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please Help Dear All, plz find the attachment and help RegardsJeet -- Join official facebook page of this forum @ https

Re: $$Excel-Macros$$ Please Help

well said. Hopefully these messages will do some good?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Thursday, September 06, 2012 7:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help Don, I did (look

RE: $$Excel-Macros$$ Please Help

Same as don Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 06 September 2012 6:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Please Help I did NOT look

Re: $$Excel-Macros$$ Please Help

[mailto: excel-macros@googlegroups.com] *On Behalf Of *dguillett1 *Sent:* 06 September 2012 6:08 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Please Help ** ** I did NOT look at your attachment because you did not provide a meaningful subject line in your post

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote: Dear Preavesh, 04 solutions of you. for any query please see attachment. =LOOKUP(H3,$C$3:$D$9) =VLOOKUP(H3:H6,$C$3:$D$9,2,0)

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Your most welcome. Regards, Kuldeep Singh On Fri, Aug 31, 2012 at 11:39 PM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote:

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi amresh, Thanks! for help me On 8/30/12, Amresh Maurya amreshkushw...@gmail.com wrote: Hi Pravesh, Find the attached solved file. =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Reagrds Amresh On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote:

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Subject: Re: $$Excel-Macros$$ please help me to solve this question it's very urgent Hi team, Thanks so much for help me and give best to best Suggestions Thanks Pravesh Kumar On 8/30/12, Kuldeep Singh naukrikuld...@gmail.com wrote: Dear Preavesh, 04 solutions of you. for any query please

Re: $$Excel-Macros$$ please help with array formula

Hi Noorin what is logic of last number 4 in formula if I change it nothing change in output ={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4)} I used excel 2003 so I changed formula like this Pl tell me logic of number 4 in last On Tue, Aug 28, 2012 at 10:16 PM, maksood

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

KUMAR Sent: Wednesday, August 29, 2012 11:30 PM To: excel-macros ; excelvbaclinic Subject: $$Excel-Macros$$ please help me to solve this question it's very urgent Hi Team, please help me to solve this question it's very urgent waiting your response -- Thanks Regards Pravesh Kumar

Re: $$Excel-Macros$$ please help with array formula

Dear Amar, We are using No. 4 for row no., If you go through attachment, table start from row no. 5, row no.4 is heading so, we deduct above all row Number including header. so we are using 4 because we are deduction 4 row no. Hope my explanation will help you. On Thu, Aug 30, 2012 at 5:16

$$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Team, please help me to solve this question it's very urgent waiting your response -- Thanks Regards Pravesh Kumar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Mr. Pravesh See the attached file and kindly refer the forum rules, the subject line must be clear regarding your query Ashish On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi Team, please help me to solve this question it's very urgent waiting your

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, =VLOOKUP($H3,$C$3:$D$9,2,0) I think this formula would solve your question. On Thu, Aug 30, 2012 at 10:00 AM, PRAVESH KUMAR praveshkash...@gmail.comwrote: Hi Team, please help me to solve this question it's very urgent waiting your response -- Thanks

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Hi Pravesh, Find the attached solved file. =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Reagrds Amresh On Thu, Aug 30, 2012 at 10:14 AM, Priyanka Vaish vaishpriyanka2...@gmail.com wrote: Hi Pravesh, =VLOOKUP($H3,$C$3:$D$9,2,0) I think this formula would solve your

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Preavesh, 04 solutions of you. for any query please see attachment. =LOOKUP(H3,$C$3:$D$9) =VLOOKUP(H3:H6,$C$3:$D$9,2,0) =VLOOKUP(H3,$C$3:$D$9,2,0) =IF(MATCH(G3,$B$3:$B$9,0),VLOOKUP(H3,$C$3:$D$9,2,0)) Regards, Kuldeep Singh On Thu, Aug 30, 2012 at 10:23 AM, Amresh Maurya

Re: $$Excel-Macros$$ please help me to solve this question it's very urgent

Dear Pravesh, Enclosed herewith your query solu Regards, Gawli Anil On Thu, Aug 30, 2012 at 10:26 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Dear Preavesh, 04 solutions of you. for any query please see attachment. =LOOKUP(H3,$C$3:$D$9) =VLOOKUP(H3:H6,$C$3:$D$9,2,0)

$$Excel-Macros$$ please help with array formula

Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd sheet i want a formula if i enter 20 its should show me the name of all the candidate who has 40 marks in 1st sheet. can it done with array forumla. please help. *Name* *Marks CT-1*

Re: $$Excel-Macros$$ please help with array formula

can you send us the attachment On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote: Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd sheet i want a formula if i enter 20 its should show me the name of all the

Re: $$Excel-Macros$$ please help with array formula

cannot send any attchment due to system restrictions. On Tue, Aug 28, 2012 at 8:20 PM, ashish koul koul.ash...@gmail.com wrote: can you send us the attachment On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.comwrote: Hi experts, I have data in once sheet in two colums like

Re: $$Excel-Macros$$ please help with array formula

Dear Maksood, Please try it.. =IFERROR(INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4),--) On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote: Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd

Re: $$Excel-Macros$$ please help with array formula

See attachment for more clarity On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.com wrote: Hi experts, I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum B). In 2nd sheet i want a formula if i enter 20 its should show me the name of all the

Re: $$Excel-Macros$$ please help with array formula

Thanks Noorain bhai.. its solved my qurey.. On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: See attachment for more clarity On Tue, Aug 28, 2012 at 8:08 PM, maksood alam 786maks...@gmail.comwrote: Hi experts, I have data in once sheet in two colums like

  1   2   3   >