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

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

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 format in excel. Example, I am Sending below mail to every new joiner for getting the desk allocation details from him (Mail 1). When the person r

$$Excel-Macros$$ Need macro program for copying data

Dear all, Please find attached copy of sample excel file, for sample demo, Actually i have data in different cells, i want it to incorporate in one cell with different heading, example I have data 1 to data 12, i want data 1 to data 6 in one cell with different headings. -- Are you =EXP(E:RT) o

$$Excel-Macros$$ Need Macro

Please help on this one. -- 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 titles, like Please He

$$Excel-Macros$$ Need Macro

Hi Team, Need your help in creating macro which would do following:- 1. To delete whole data in Sheet C 2. Copy whole data of Sheet B and paste it in Sheet C 3. Go to the Sheet A. Filter for "Current" in Column B 4. Copy the visible data of Step 3 and paste it in Sheet B 5. Now in Column C need f

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

$$Excel-Macros$$ NEED MACRO FOR CITRIX

Hi All, Anyone knows how to write macro to activate applications inside citric. Let me know if any useful links on same. Regards Suresh -- 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.f

$$Excel-Macros$$ Need Macro Help Please! Updating invoice tabs

Hello! I am completely clueless about Marcros, but I would like to create one to help me deal with a very redundant task! I have three excel sheets with invoices : per Month, Year and Total I usually enter the Monthly values, and then I have to copy them all again to year and total is there 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

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

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 need specific word from Input sheet (ENTRY or EXIT) and reflect the same in to status row i.e. on E Column respectively. Your help o

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

imes you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Prabhu Pinky > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, March 5, 2015 10:08 AM > *Subject:* $$Excel-Macros$$ Need macro help > > Hi experts, > I have

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

ohn Wesley - > > From: Prabhu Pinky >To: excel-macros@googlegroups.com >Sent: Thursday, March 5, 2015 10:08 AM >Subject: $$Excel-Macros$$ Need macro help > > > >Hi experts, >I have around 10-15 excel file in

$$Excel-Macros$$ Need macro help

Hi experts, I have around 10-15 excel file in a folder and updated every week. I need macro in master file which will open each file from folder and copy in master file. Please help me on 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) ! Jo

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

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

Hi xperts, Please help me with vba macro which extracts subject, mail date and mail body from outlook to excel. Its very urgent please help. Prabhu. -- 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 @ h

$$Excel-Macros$$ Need macro to copy data from excel file to another excel file

Hello, Awaiting for your reply. ...yudy -- 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 titles

$$Excel-Macros$$ Need Macro enabled Button to select Filter Values

Dear Excel Gurus, I need one help in the attached Excel. I need a Macro Button to be placed on the sheet, on clicking the same it should select the option out of two. Example: When I click on the Button first time, it select Type 1 from the first Column, and change the Button Text to Type 2. Sim

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

$$Excel-Macros$$ Need macro

Dear All,I need your valuable help which will be reduce my time to compile data without any errorRequirementMonth on month I received huge data base from my Head office to compile and send the same to Respective managerAll Sheets data forma

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

$$Excel-Macros$$ need macro add Rows

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 box will ask to input number i.e. 5 (How many rows to insert) and after entering, the same entered number of rows added under

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

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

Hello guys, Still awaiting for your response. Ujjwal -- 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. P

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

Hello, Need your help to convert pdf file to excel without changing the format of pdf. Also the pdf file converted to excel result should be into different sheets(As per attached invoice forming one workbook). i have attached two sample files. Awaiting for your positive solution. Thanks, Uj

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

$$Excel-Macros$$ need macro

Dear Experts, I need macro, which can encrypt with password after defined no of days. Example- i make file today, after 20 days it will password protect automatically. So someone couldn't open in my absence. Thanking You Regard Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

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

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

Hello All, Greetings for the day. Pl refer attached excel, I'm using one database software & when I pull out different reports from that I need to do 10 steps for each report every time. I've tried to record macro also but I don't know how to find out "last cell which contains text" sometimes

$$Excel-Macros$$ Need Macro ---- urgent

hi experts, Pls find the attached file. if any cell has refers WTD then it should calculate WTD status. or if any cell has refers MTD then it should calculate sum of WTD and its status. pls help. note : month on month date and WTD/MTD cell will vary. Thanks & Regards, Prabhu R -- Are you

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

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

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: NDTV, BBC, Aaj Tak, Facebook we need to change it as below *Aaj Tak, BBC, Facebook, NDTV* i have lots of data to sort, but not getting any solut

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

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

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. Looking forward your co-operation Regards -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wann

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(

$$Excel-Macros$$ Need macro or Formula

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(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ h

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

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

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 onwards. 3. We have similar data in two tabs. 4. I need a Macro that will create separate workbooks based on individual Mfr in column "C". 5. But I need

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

: excel-macros Subject: $$Excel-Macros$$ Need Macro to make multiple sheets Hi, I want a macro for attached sheet what i need exactly I have a consolidated data of muliple city. I want to make diiferent sheets citywise and shteet name should be of city. Regards, Deepak Rawat -- FORUM RULES (986

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

$$Excel-Macros$$ Need macro website

Hi Friends, How learn the macro's in step by step,kindly provide the any macro tutorial website Pls Help Regards karthik.N -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pro

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

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

Hello, I have 2 sheets in one file, one sheet "A" has less part numbers than the other sheet "B", would like to have a macro to verify the part number in "A" vs. "B", anything missing in "B" will be added to the bottom of sheet "A". My logical is trying to use "iserror(vlookup(...),0) to see i

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

AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need macro of formula and update in other sheet Dear expert, I need a macro of vlookup formula written in attached sheet of "Vendor Master" which display only those concern data match with cell value of F1 and after

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

  1   2   >