Re: $$Excel-Macros$$ Need Macro for Data Fetching from mail to Excel sheet

Team pls pls help... Regards, Vikas Khengre On Mon 2 Jul, 2018, 11:18 vikas khen, wrote: > Hi All, > > It would be very helpful if you could help me regarding on the below said > issue. > > Regards, > VK > > On 30-Jun-2018 1:22 PM, "vikas khen" wrote: > > Hi Experts, > > > Request you to kindl

Re: $$Excel-Macros$$ Need Macro for Data Fetching from mail to Excel sheet

Hi All, It would be very helpful if you could help me regarding on the below said issue. Regards, VK On 30-Jun-2018 1:22 PM, "vikas khen" wrote: Hi Experts, Request you to kindly help me with VBA macro which will fetch the data from *Outlook mail folder* and will arrange the same in required

Re: $$Excel-Macros$$ NEED MACRO FOR CITRIX

Any macro man in this group know how to write code to access the application inside citrix. On 12-Feb-2018 7:58 PM, "suresh k" wrote: > Hi All, > > Anyone knows how to write macro to activate applications inside citric. > > Let me know if any useful links on same. > > Regards > Suresh > > -- > A

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Gowrisankar, Thanks it's working Really appreciated your efforts on this Keep it up.. *Regards* *Vikkhe1* On Fri, Apr 29, 2016 at 2:49 AM, Gowrisankar Arthanari GSA < a.go...@gmail.com> wrote: > Hi Vikes, > ​please find the attachment of sheet with command button. > > it will

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Vikes, ​please find the attachment of sheet with command button. it will run for more dates and more persons also. u paste your details in input sheet and run the macro. it will create the report. Regards, A Gowrisankar. On Fri, Apr 29, 2016 at 2:29 PM, vikas khen wrote: > Hi Gowrisankar,

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Gowrisankar, Thanks for providing me the solution, However it will be very helpful if you provide me command button for generating the report. Also it generates report only unto 3/3/2016 but i have more dates. Your help on this will be very much appreciated On Fri, Apr 29, 2016 at 1:22 AM,

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

hi, PFA Regards, A Gowrisankar​ On Fri, Apr 29, 2016 at 10:20 AM, vikas khen wrote: > Hi Experts!!! > > Any Hope regarding on this?? > > Warm Regards, > Vikkhe1 > > On Thu, Apr 28, 2016 at 6:55 PM, vikas khen wrote: > >> Hi Team, >> >> >> >> Please find the attached sheet in which there are t

Re: $$Excel-Macros$$ Need Macro/Solution for the attached sheet

Hi Experts!!! Any Hope regarding on this?? Warm Regards, Vikkhe1 On Thu, Apr 28, 2016 at 6:55 PM, vikas khen wrote: > Hi Team, > > > > Please find the attached sheet in which there are two different sheets one > is INPUT and other one is required OUTPUT based on input sheet. > > > > Also I ne

Re: $$Excel-Macros$$ Need macro for Vlookup

Hi Pankaj, I just noticed, that in output "Start" and "End" time seems same. Regards, Prabhu.R Thanks & Regards, Prabhu R On 10 February 2016 at 01:26, Prabhu Pinky wrote: > Hi pankaj, > > Thanks a ton for the coding... > > It's working very fine as I expected.. Thanks again. > > Regards, >

Re: $$Excel-Macros$$ Need macro for Vlookup

Hi pankaj, Thanks a ton for the coding... It's working very fine as I expected.. Thanks again. Regards, Prabhu.R On Feb 10, 2016 12:03 AM, "Secret Shot" wrote: > Hay Prabhu, > > You can use this code to do your required task. . follow the steps > > Go to visual basic editor under Developer tab

Re: $$Excel-Macros$$ need macro to generate serial no

Thanks for reply sir, its done through macro & manually ( by dragging ) i waited 3 days no solution found just i did Sub SerialNo() With Range("A100:A" & Range("B" & Rows.Count).End(xlUp).Row) .Cells(1, 1).Value = 1000 .DataSeries Rowcol:=xlColumns, Type:=xlLinear, Step:=1, Tren

Re: $$Excel-Macros$$ need macro to generate serial no

Your query is not clear...please elaborate. On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote: > any macro solution ? > > > On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > >> Sir, >> >> need help on serial no generate (like attached file) >> >> using auto increment loop >> >> start from 120

Re: $$Excel-Macros$$ need macro to generate serial no

any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > Sir, > > need help on serial no generate (like attached file) > > using auto increment loop > > start from 1200 to > > better if possible 1 crore in 1 sheet > thanks, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:

Re: $$Excel-Macros$$ Need macro help

,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Prabhu Pinky > *To:* excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Need macro help

nt: Thursday, March 5, 2015 10:37 AM >Subject: Re: $$Excel-Macros$$ Need macro help > > > >Hi paul, thanks for your response. Since i have some basic knowledge in vba >macro..if you share any macro related to my query i can modify that and >develop for my requirement.. That

Re: $$Excel-Macros$$ Need macro help

Hi paul, thanks for your response. Since i have some basic knowledge in vba macro..if you share any macro related to my query i can modify that and develop for my requirement.. That will help for me.. On 05-Mar-2015 8:51 PM, "Paul Schreiner" wrote: > try searching in the user group. > There shoul

Re: $$Excel-Macros$$ Need macro help

try searching in the user group. There should be several projects similar to this recently. since your question wasn't specific, it sounds like you're able to modify the vba code yourself, so the previous examples should be sufficient to get you started. If you need additional help, please pr

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Jan 7, 2015 at 6:25 AM, Prabhu Pinky wrote: > Hi Vaibhav, > > Really awesome.. thank you so much. > > Regards > Prabhu > > > Thanks & Regards, > Prabhu R > > On 6 January 2015 at 21:37, Vaibhav Joshi wr

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

Hi Vaibhav, Really awesome.. thank you so much. Regards Prabhu Thanks & Regards, Prabhu R On 6 January 2015 at 21:37, Vaibhav Joshi wrote: > Hi > > Pl check my pervious email in this thread. > > Cheers!! > On Jan 6, 2015 9:10 PM, "Prabhu Pinky" wrote: > >> Anything but simple.. But import f

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

Hi Pl check my pervious email in this thread. Cheers!! On Jan 6, 2015 9:10 PM, "Prabhu Pinky" wrote: > Anything but simple.. But import from outlook thru excel would be so > fine... > On 06-Jan-2015 1:50 PM, "Vaibhav Joshi" wrote: > >> hi >> >> How do you want it? from outlook to excel export

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

Anything but simple.. But import from outlook thru excel would be so fine... On 06-Jan-2015 1:50 PM, "Vaibhav Joshi" wrote: > hi > > How do you want it? from outlook to excel export or import from outlook > thru excel? > > + > *I did not do this for you. God is here working through me for you

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

Hi Try this... Give ref to MS Outlook library before running... Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Jan 6, 2015 at 1:49 PM, Vaibhav Joshi wrote: > hi > > How do you want it? from outlook to excel export or import from outlook > thru exc

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

hi How do you want it? from outlook to excel export or import from outlook thru excel? + *I did not do this for you. God is here working through me for you.* On Tue, Jan 6, 2015 at 12:33 PM, Prabhu Pinky wrote: > Hi xperts, > Please help me with vba macro which extracts subject, mail date

Re: $$Excel-Macros$$ Need macro

Dear Vaibhav, Thanks for ur reply will revert for clarification. On Monday, September 15, 2014, Vaibhav Joshi wrote: > Hi > > Check this..Open workbook, Click button to run macro & open folder in > which you have files to import data & you are done.. > > PS: Keep all excel file in one folder &

Re: $$Excel-Macros$$ Need macro

Hi Check this..Open workbook, Click button to run macro & open folder in which you have files to import data & you are done.. PS: Keep all excel file in one folder & macro will port data one by one from all sheets & all workbook. Do let us know if any error.. Cheers!! + *I did not do t

Re: $$Excel-Macros$$ need macro add Rows

Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 2:42 PM, Ashish Bhalara wrote: > Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. > I also learn new things from your code. > Cheers :) > > Regards. > Ashish Bhalar

Re: $$Excel-Macros$$ need macro add Rows

Thank you very much Mr.Vaibhav, ones again u do a marvelous job for me. I also learn new things from your code. Cheers :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Mon, Sep 15, 2014 at 1:52 PM, V

Re: $$Excel-Macros$$ need macro add Rows

Check this, you will be prompted to add only no. of rows & new rows will be added at the end! Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Sep 15, 2014 at 12:45 PM, Ashish Bhalara wrote: > Thanks to reply Vaibhavji, > There are some error occur if

Re: $$Excel-Macros$$ need macro add Rows

Hi Chek this, corrected bug & added auto complete method.. Cheees!! + *I did not do this for you. God is here working through me for you.* On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara wrote: > Dear experts, > > I have column with heading of SR and fillup with 1 to 10. > I need a macro

Re: $$Excel-Macros$$ need macro add Rows

try enclosed . Enjoy Team XLS On Sat, Sep 13, 2014 at 4:13 PM, Ashish Bhalara wrote: > Dear experts, > > I have column with heading of SR and fillup with 1 to 10. > I need a macro to insert blank row under 10 with continue series > 11,12,13... > When run macro, message

Re: $$Excel-Macros$$ Need macro to covert pdf to excel

Hi Ujjwal. Please find the below links for your requirement. http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html P On Tue, Sep 2, 2014 at 10:58 PM, Ujjwal Desai wrote: > Hello guys, > > Still awaiting for your response. > > Ujjwal > > -- > Are you =EXP(E:R

Re: $$Excel-Macros$$ need macro

password is password On Mon, Jul 28, 2014 at 6:41 PM, SUDHIR VERMA wrote: > what is password for attached file > > > On 24 July 2014 20:21, Vaibhav Joshi wrote: > >> Hi >> >> Check this file. >> >> In sheet 1 Cell A1 put begining date, in cell B1 put date put formula >> =A1+10 so that on the t

Re: $$Excel-Macros$$ need macro

what is password for attached file On 24 July 2014 20:21, Vaibhav Joshi wrote: > Hi > > Check this file. > > In sheet 1 Cell A1 put begining date, in cell B1 put date put formula > =A1+10 so that on the tenth date after date mentioned in cell A1 macro will > work. > > You need to hide row 1 & a

Re: $$Excel-Macros$$ need macro

Hi Check this file. In sheet 1 Cell A1 put begining date, in cell B1 put date put formula =A1+10 so that on the tenth date after date mentioned in cell A1 macro will work. You need to hide row 1 & also hide sheet1 & set property very hidden. after that lock macro. When file is opened macro will

Re: $$Excel-Macros$$ Need macro for repetative formatting

il 01, 2014 7:18 PM > *To:* excel-...@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Need macro for repetative formatting > > > > Hello All, > > Pl advice on mail below. Am I asking something very difficult ? If anybody > can help that can save my lots of time. > Pl do t

RE: $$Excel-Macros$$ Need macro for repetative formatting

Provid any data and your 10 steps which u want to do after download data from software From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Tuesday, April 01, 2014 7:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog > On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: >> >> Hello Vicky, >> >> I'm not at all coping data from any whe

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello All, Pl help & try to solve my problem. Regards, Suyog On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: > > Hello Vicky, > > I'm not at all coping data from any where otherwise I would have used the > "paste special". I'm pulling data from software & which some times

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Thanx for your kind suggestion, i am trying to learn the VBA On Tue, Mar 25, 2014 at 2:17 PM, Divaker Pandey wrote: > need to use both procedure for your requirement, you were using only one. > > and please try to learn vba wtih programming skill. > > it will help you understand other's progra

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello Vicky, I'm not at all coping data from any where otherwise I would have used the "paste special". I'm pulling data from software & which some times finish within 10 rows & 10 columns & sometimes it's cross 30 columns & 100 plus rows. If somehow I want to tell excel that follow my 10 step

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Hi, Could u see the error.. Regards On Sun, Mar 23, 2014 at 6:29 PM, Deepak Rawat wrote: > i tried the code but giving ubound error, sample is attached, > kindly check > > > On Sun, Mar 23, 2014 at 6:19 PM, Deepak Rawat wrote: > >> Hi, >> i tried but not working but showing #Value! Error >> >

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hi Suyog, My understanding is you would like to have same format for all data so my logic is rather formating each line of data I have saved your format in "Format" tab in attached sheet and then that format will be applied to your copied data in Original Sheet. Same as we do in Excel using *Pas

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Hi, i tried but not working but showing #Value! Error Pls look into... Regards, Deepak On Thu, Mar 20, 2014 at 5:33 PM, Divaker Pandey wrote: > use below code > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempstrArr() As String > > Dim i As Integer > For Ea

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

use below code Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempstrArr() As String Dim i As Integer For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271") tempstrArr = Split(cl.Value, ",") tempstrArr = removeDuplicate(tempstrArr) For i = 0 To UBound(tempst

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Hi Dipanke, One more query i have, please do me favor I have lots of cells which contains duplicate comma desperated values like given below Audi, BMW, Audi BMW, BMW, Toyota Honda, Toyota, BMW, Honda After cleaning it should be look like below: Audi, BMW BMW, Toyota BMW, Honda, Toyota could

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Thanx a lot Divaker!! its working the way i need Regards, Deepak Rawat On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote: > use this macro > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempStrArr() As String > Dim i As Integer > For Each cl In ThisWorkboo

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

use this macro Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempStrArr() As String Dim i As Integer For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271") tempStrArr = Split(cl.Value, ",") For i = 0 To UBound(tempStrArr) For j = i + 1 To UBound(tempStrA

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

yes but its very time consuming to do mannually sort... On Thu, Mar 20, 2014 at 2:26 PM, VJ IR wrote: > Have u tried using text to columns?? > > Its a simple way to do so. > > Regards, > Vijay Iyer > On 20 Mar 2014 14:23, "Deepak Rawat" wrote: > >> Dear All, >> >> I have attached a sheet with

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

Have u tried using text to columns?? Its a simple way to do so. Regards, Vijay Iyer On 20 Mar 2014 14:23, "Deepak Rawat" wrote: > Dear All, > > I have attached a sheet with rawa data & final data. > > I need a macro to sort coma separated data in each cell, like example is > given below: > > N

Re: $$Excel-Macros$$ Need macro for converting PDF in to given format

Hi Ashish, Thanks for the prompt reply but i can not use the same due to policy, request you to kindly give me the alternate option. Regards On Wed, Oct 16, 2013 at 8:34 PM, ashish koul wrote: > try *able2extract *professional version > > > On Wed, Oct 16, 2013 at 8:10 PM, Jocky Beta wrote:

Re: $$Excel-Macros$$ Need macro for converting PDF in to given format

try *able2extract *professional version On Wed, Oct 16, 2013 at 8:10 PM, Jocky Beta wrote: > Hi Team, > > I need help on above attached sheets, In the excel sheet i should browse > the PDF file (which is attached in this mail ) and then the output data > should be come in given format. > > Look

Re: $$Excel-Macros$$ Need macro or Formula

Thanks DP Sir, the code is now working perfectly. Regards, Mukesh Kumar On Wed, Jul 17, 2013 at 6:40 AM, De Premor wrote: > ignore my last email, i've made some change in variable declaration > PFA > > > On 17/07/2013 7:32, De Premor wrote: > > Hi, Mukesh Try to change this code: > > *For

Re: $$Excel-Macros$$ Need macro or Formula

Hi, Mukesh Try to change this code: *For Each Rng In Data** **If RangeCriteria.Cells(Rng.Row, 1) = Criteria Then Buf.Add Rng.Value, Rng.Value** **Next** * to *For Each Rng In Data** **i = i + 1** **If RangeCriteria.Cells(i, 1) = Criteria Then Buf.Add Rng.Va

Re: $$Excel-Macros$$ Need macro or Formula

Ups sorry, my mistake i've attached new file for revision Rgds, [dp] On 16/07/2013 15:27, Mukesh Kumar wrote: Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is coming twice in result. Can it also come single time. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 1:48 P

Re: $$Excel-Macros$$ Need macro or Formula

Thanks a lot Sir, but duplicate entries are also coming twice eg Alwar is coming twice in result. Can it also come single time. Regards, Mukesh Kumar On Tue, Jul 16, 2013 at 1:48 PM, De Premor wrote: > Solution Attached > > > On 16/07/2013 14:10, Mukesh Kumar wrote: > >> Hi Experts, >> >> I n

Re: $$Excel-Macros$$ Need macro or Formula

Solution Attached On 16/07/2013 14:10, Mukesh Kumar wrote: Hi Experts, I need macro /formula for query given in attached file. The result should come based on values given in column A. Regards, Mukesh Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(

Re: $$Excel-Macros$$ Need Macro to Create individual Mfr Files

Dear Rahim Pl specify your problem little bit more. Warm Regards, Gawli Anil On Mon, Mar 11, 2013 at 11:29 PM, Rahim Sharieff wrote: > Hi, > > Please find the attached workbook. > > 1. There are two tabs "Test 1" and "Test 2" > 2. The Header row is in row 5 and the data starts from row 6 onwa

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

Since you already have it filtered why have separate sheets. Simply add rows at top and use a subtotal(109. Or a separate sheet with sumifs for each city Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Deepak Rawat Sent: Thursday, July 05, 2012 8:26 AM To: ex

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

Hi Its counts are not coming correct Pls check on this. On Thu, Jul 5, 2012 at 7:16 PM, Deepak Rawat wrote: > Its working well > > Thanx!! > > > On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI > wrote: > >> Dear Deepak, >> >> Please use below code... >> >> Sub N_spilit_Worksheet() >> Dim i As

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

Its working well Thanx!! On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI wrote: > Dear Deepak, > > Please use below code... > > Sub N_spilit_Worksheet() > Dim i As Long > Dim k As Long > Dim j As Long > Dim rng As Range > Dim sh As Worksheet > On Error Resume Next > Set sh = ThisWorkbook.Workshee

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi All, I wish to seek your assistance in getting the output as mentioned in the attached excel cell: for Eg: If the Frequency is "High" and the Probability is also "High" I need to get an output of "1" like wise if Frequency is High and Probability is "Medium", I should get an output of "2". T

RE: $$Excel-Macros$$ need Macro

Me.Names("rngLastRecord").Delete ExitEarly: If Err.Number <> 0 Then MsgBox "No Record was edited last time", vbInformation Err.Clear End If End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@g

Re: $$Excel-Macros$$ need Macro

Hi Chetan, You can create a log tab in your workbook and place the code in "This workbook" section of that excel on Close event to update that log with username and time. Regards Shekhar Sharma On Mon, May 7, 2012 at 1:25 AM, B.N.Chethan Kumar wrote: > Dear Excel Gurus, > > I need BIG help fro

Re: $$Excel-Macros$$ Need macro website

Dear Karthik, Please download ebook from below mentioned website..and follow excel macro group on regular basis. http://search.4shared.com/q/CCAD/1/excel%20vba?suggested -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sat, May 5, 2012 at 5:11 PM,

Re: $$Excel-Macros$$ Need macro website

very nice thanks From: Maries To: excel-macros@googlegroups.com Sent: Saturday, May 5, 2012 5:45 PM Subject: Re: $$Excel-Macros$$ Need macro website Hi,  Check below link, http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm Regards, MARIES

RE: $$Excel-Macros$$ Need macro website

Behalf Of ?» lal?? ?sa?? Sent: 06 May 2012 21:10 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need macro website Dear karthik you can also learn VBA by your self and for this you just need to record macro for anything you do. Regards, Lalit Mohan <ht

Re: $$Excel-Macros$$ Need macro website

Dear karthik you can also learn VBA by your self and for this you just need to record macro for anything you do. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Sun, May 6, 2012 at 7:07 PM, Prajakt Pande wrote: >

Re: $$Excel-Macros$$ Need macro website

Dear, Instated of learn from web site, just try your self with small small tools it will help you lot, i learn like this only this is my personal experience. all the best. Thanks & Regards, Prajakt Pande +971551388482 ** On Sun, May 6, 2012 at 5:09 PM, Bé Trần Văn wrote: > ** > > 2012/5/5 Ma

Re: $$Excel-Macros$$ Need macro website

** 2012/5/5 Maries > Hi, > > Check below link, > > http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm > > > Regards, > > MARIES. > > > On Sat, May 5, 2012 at 4:41 AM, karthik N wrote: > >> Hi Friends, >> >> >> How learn the macro's in step by step,kindly provide the any macro >>

Re: $$Excel-Macros$$ Need macro website

Hi, Check below link, http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm Regards, MARIES. On Sat, May 5, 2012 at 4:41 AM, karthik N wrote: > Hi Friends, > > > How learn the macro's in step by step,kindly provide the any macro > tutorial website > > > Pls Help > > Regards > kar

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi Larit, I tried the macro on a 2500 lines report, it took long time to proceed and reported error, stopped at: ThisWorkbook.Worksheets("Item Master").Range("A1").End(xlDown).Offset(1).Resize(UBound(varShee1Data) + 1) = Application.Transpose(varShee1Data) Can you please help? Thanks, T

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

It works, thanks a lot!!! On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: > > > Hi > > PFA > > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation* > > > > > On Fri, May 4, 2012 at 12:52 AM, Tony Wu wrote

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 12:52 AM, Tony Wu wrote: > Hello, > > I have 2 sheets in one file, one sheet "A" has less part numbers than the > other sheet "B", would

RE: $$Excel-Macros$$ Need macro of formula and update in other sheet

Hi Ashish, See if this example workbook from Debra Dalgleish and Dave Peterson helps you out: http://contextures.com/exceldataentryupdateform.html Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Friday, March 16, 2012 6:07 A

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

$uperb sam... Really ur great. Thank you and regards Yogananda Muthaiah On 1/14/12, Sam Mathai Chacko wrote: > Set objExcel = CreateObject("Excel.Application") > Set objWorkbook = > objExcel.Workbooks.Open("C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls") > for each wks in objworkbook.wo

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\Users\Sam\Desktop\DelAllRowsExcelA1.xls") for each wks in objworkbook.worksheets wks.Range("A2", wks.UsedRange.SpecialCells(11)(2)).EntireRow.Delete next objWorkbook.Save '"C:\User

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

Hi sam As you provided in excel vba .. I would need the same to run through vb script. keep 1 xl in desktop with records which we need *.vbs to run delete rows from range A2 to till end in xl On 1/14/12, Sam Mathai Chacko wrote: > Try in vb script? I have no idea what you are trying to convey. >

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

Try in vb script? I have no idea what you are trying to convey. On Sat, Jan 14, 2012 at 6:30 PM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Thank you sam > Can you please try in vb script on same > > On 1/14/12, Sam Mathai Chacko wrote: > > Sub DelRows() > > > > Dim wks

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

Thank you sam Can you please try in vb script on same On 1/14/12, Sam Mathai Chacko wrote: > Sub DelRows() > > Dim wks As Worksheet > > For Each wks In ThisWorkbook.Worksheets > With wks > .Range("A2", > .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Del

Re: $$Excel-Macros$$ Need Macro in VBA excel or vbs

Sub DelRows() Dim wks As Worksheet For Each wks In ThisWorkbook.Worksheets With wks .Range("A2", .UsedRange.SpecialCells(xlCellTypeLastCell)(2)).EntireRow.Delete End With Next wks End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 8:07 AM, yogan

Re: $$Excel-Macros$$ Need macro to split the files

Hi Ashish, I want to apply the filter on both regional lead & divisional lead. Example: Wolfgang will be in both regional lead & divisional lead. It has to lookout both & bring the result. Regards Anu On Wed, Aug 31, 2011 at 7:50 PM, ashish koul wrote: > Hi Anu > > could you tell me do u want

Re: $$Excel-Macros$$ Need macro to split the files

Hi Anu could you tell me do u want to apply filter on regional lead or divisional lead. On Wed, Aug 31, 2011 at 2:29 PM, anu gomathi wrote: > Hi Ashish, > > This is absolutely fantastic. Need your help to change the below things > > 1. Regional lead data is not populated in the Summary & de

Re: $$Excel-Macros$$ Need macro to split the files

Hi Ashish, This is absolutely fantastic. Need your help to change the below things 1. Regional lead data is not populated in the Summary & details sheet. 2. Could you pls remove the Q1 FY12 data from the from the detail sheet. Q1 Fy12 data is already available in the Summary sheet. Thanks a l

Re: $$Excel-Macros$$ Need Macro help to copy paste the each column data in one column

attach the sample file On Mon, May 9, 2011 at 7:21 PM, vinu wrote: > Hello team, > > Could you please help me for the below scenario: > > Need a code to copy paste column data under one column and keep the > same description. > > A B C > >bangmysore > > jan 645

Re: $$Excel-Macros$$ Need macro help to copy paste each column data under one column

change sheet3 name as out and tun the macro Sub swa() Dim i, SW, swa As Long SW = Sheets("input").Range("A65356").End(xlUp).Row For i = 2 To Sheets("input").Range("b6").End(xlToRight).Column Sheets("input").Activate Sheets("input").Range("a8:a" & SW).Copy swa = Sheets("out").Range("b65356"

Re: $$Excel-Macros$$ Need macro code help regaring the pop up .

add application.displayalert = false at the beginning of code application.displayalert = true before end sub statement On Wed, Apr 20, 2011 at 4:02 PM, Bhushan Sabbani wrote: > Dear All, > > I have record a macro there i have delete the sheet. > The code are as below > > Sheets("MNS Summary")

Re: $$Excel-Macros$$ Need macro for attd workbook

Hello Vidyut, Please find the attached file for your reference. Regards, Beer. On Thu, Jul 22, 2010 at 12:09 PM, vidyut more wrote: > Hi respected members. > > i want ur help in macro. i v attd sample workbook, in that i want > macro that can protect rows which is not empty and unprotect empt

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

_________ From: Erick C To: MS EXCEL AND VBA MACROS Sent: Tue, May 25, 2010 12:42:24 PM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Paul - I changed the part of the code that you suggested, and it is working fine. Again, I am still quite a novice with

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

Dear All, I want to Print Page Number "N of M" in Footer by Group-wise (i.e. ID Wise) through Access Database Report Design. Kindly give some guideline or VB Code to do the same. Rgds, Manas. -- -- Some important lin

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

hrough to see what it is doing. > > You should find the problem then. > > sorry for the confusion (and sarcasm) ;) > > Paul > > > From: Erick C > To: MS EXCEL AND VBA MACROS > Sent: Mon, May 24, 2010 3:41:51 PM > Subject: Re: $$E

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

_________ From: Erick C To: MS EXCEL AND VBA MACROS Sent: Mon, May 24, 2010 3:41:51 PM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Hi Paul - I tried the code you provided without making any modifications and I had a few issues. Just for a bit of background: 

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

A MACROS > Sent: Fri, May 21, 2010 11:55:43 AM > Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste > > Hi Paul - > Thanks for the reply.  Let me attempt to answer your questions and > hopefully clarify a bit. > 1. I am using Excel 2003 > > 2. All

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

XCEL AND VBA MACROS Sent: Fri, May 21, 2010 11:55:43 AM Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste Hi Paul - Thanks for the reply.  Let me attempt to answer your questions and hopefully clarify a bit. 1. I am using Excel 2003 2. All of the steps prior to the code I

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

Hi Paul - Thanks for the reply. Let me attempt to answer your questions and hopefully clarify a bit. 1. I am using Excel 2003 2. All of the steps prior to the code I already had were serving only one purpose. I want to write the text file using only rows where the date in column T equals the date

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

I have a few questions. What version of Excel are you using? You said in step 6, you "cut" the records that AG is null did you really man "cut", as in: removed from sheet1? also, you're writing a file with : a.WriteLine s1 & s2 & s3 & s4 & s5 & s6 but the values have no spaces or delimiters bet

Re: $$Excel-Macros$$ Need macro

Thanks for quick reply. but can u give me in Excel 2003. On Wed, May 19, 2010 at 2:45 PM, Deepak Pal Singh wrote: > Hi Vidyut, > > This is an example workbook for you, click on button click here, and the > macro will check to first 10 rows if it's found any empty cell in column a > then the entir

Re: $$Excel-Macros$$ Need macro

Hi Vidyut, This is an example workbook for you, click on button click here, and the macro will check to first 10 rows if it's found any empty cell in column a then the entire row mey be edited else will be restricted. Thanks Deepak Kumar On Wed, May 19, 2010 at 12:53 PM, vidyut more wrote: >

Re: $$Excel-Macros$$ Need macro

Dear Members, I need Excel Template with Macro for Petty Cash Reimbursement Log (Voucher & Printing & etc) Please any one know, kindly let me know. Thanks in advance Regards Madhavan On Tue, May 18, 2010 at 9:23 AM, vidyut more wrote: > Hi Dear Member > i want macro code for in excel sheet in

Re: $$Excel-Macros$$ Need macro to create a command button and also write the script of it

t; created in this way, I think it is always the active sheet. > So instead of: > > > Sheets("Sample (2)").Select > Sheets("Sample (2)").Name = TextBox1 > > You should only need: > ActiveSheet.Name = TextBox1 > > Regards - Dave. > > > > Dat

RE: $$Excel-Macros$$ Need macro to create a command button and also write the script of it

ple (2)").Name = TextBox1 You should only need: ActiveSheet.Name = TextBox1 Regards - Dave. > Date: Sun, 21 Mar 2010 00:05:16 -0700 > Subject: Re: $$Excel-Macros$$ Need macro to create a command button and also > write the script of it > From: harpreetguj...@gmail.co

  1   2   >