$$Excel-Macros$$ Macro to Analyze Key Statistics of Stocks

2022-04-09 Thread pdnts...@gmail.com
I am trying to create an Excel Macro to find the following values in a stock's key statistics and then add them up in the G column. I've tried creating the Macro but the debugger gave me an error: Run-time error '91': Object variable or With block variable not set How do I fix this? Also what

$$Excel-Macros$$ macro to create group and subtotals

2020-10-27 Thread CAN
I have a list of columns A to J. Column J has the names of the customer, and on column G there a dollar amount that relates to costumer on on column J Important note. the column J is sorted in alpha format I need a macro that groups the list on column J (( based on the name of the customer )

$$Excel-Macros$$ Macro to create a table for changeable data

2020-09-21 Thread Pravin Gunjal
Hi Guys, I have a macro in the attached file to create a table for the data (my data doesn't have fix rows and changes on daily basis), but after the table is created few or more rows have to be deleted based on the requirement. But as you could see that the table is still existing with blank r

Re: $$Excel-Macros$$ Macro for formatting 2 columns in all the worksheets in a folder

2020-08-01 Thread alberto calderon
Earn money online ✔ Get 0.10€ per click ✔ Get 0.01€ per referral's click ✔ Instant payouts ✔ No minimum cashout ✔ Always daily advertisements ✔ Upgrade and earn up to 500% more https://orbisbux.com/?ref=Vicenteb45 El sáb., 1 ago. 2020 3:50 a. m., rahimka...@gmail.com < rahimkarim1...@gmail.com> e

$$Excel-Macros$$ Macro for formatting 2 columns in all the worksheets in a folder

2020-08-01 Thread rahimka...@gmail.com
Hi Team, I have number of files (more than 16 files) located in a folder "d:\abc" and I want to apply format like "0' (13 "0") to "CNIC" column and "00'" (14 "0" ) to "account nos" column on each file. the order or location of these column are not fixed in excel sheet. s

$$Excel-Macros$$ macro file reg

2020-04-13 Thread jmothilal
Dear any one i am using spellrupee command in my excel file , whenever i open this file i import Rupees-words.bas each time. how to solve -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w

$$Excel-Macros$$ Macro to update the Logo in Header

2018-06-01 Thread SridharBL
Hi Experts, I have attached file which includes macro to update the company Logo. Macro runs fine. But, I want the macro to take the path(folder location/image location) of the Logo image from the path mentioned in the cell D5, which I am not able to do. Can you please help. -- Are you =

Re: $$Excel-Macros$$ Macro for Auto delete workbook

2018-02-18 Thread Prabhu Pinky
can u share sample worksheet Thanks & Regards, Prabhu R On 9 February 2018 at 11:17, Rajesh kumar wrote: > Need macro for auto delete workbook after given expiration date. > > -- > 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 F

$$Excel-Macros$$ Macro for Auto delete workbook

2018-02-08 Thread Rajesh kumar
Need macro for auto delete workbook after given date expired and also compatible office 2010 or later -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULE

$$Excel-Macros$$ Macro for Auto delete workbook

2018-02-08 Thread Rajesh kumar
Need macro for auto delete workbook after given expiration date. -- 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 tit

$$Excel-Macros$$ Macro to calculate in time and out time

2018-02-08 Thread Ashit Choudhary
Hi All, I have data in the Master Sheet for various Employees which consists of each of their logging (in and out time). Data in INPUT worksheet 1) I want first in and last out for a days – All the associates (in OUTPUT worksheet column D and column E) 2) I want the know how many hou

$$Excel-Macros$$ Macro to copy cells as per criteira to another workbook

2017-12-08 Thread prkhan56
Dear All I have two workbooks which I use for Data entry and for updating the Master Data Sheet Both the *workbooks are open* at the time of Data Entry. *Data Entry is done on the Active Sheet of File1* eg: File1.xlsx – *From file* File2.xlsx (Cells transferred to Sheetname ‘DATA’) – *To File*

$$Excel-Macros$$ Macro to export Table Titles/Headers AND the contents of each table from Word to Excel

2017-11-28 Thread John C
I am looking for a Macro to export the contents of every table in a Word document(s) and move this content to Excel. Along with pulling the contents of the tables however, I would like the titles of each of these tables to be exported as well. The Word document(s) are formatted in a table of

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-27 Thread Kishore P V K
That's cool. Thanks for the update. Regards Kishore On Thu, Jul 27, 2017 at 12:11 PM, Shrinivas Shevde wrote: > Dear Sir > Thanks for reply > Problem got resolved. > > Regards > Shrini > > On Wed, Jul 26, 2017 at 6:58 PM, Kishore P V K > wrote: > >> Hello Shrini >> >> Can you please explain

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-27 Thread 'Keisha Fry' via MS EXCEL AND VBA MACROS
On Thu, 7/27/17, Shrinivas Shevde wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, July 27, 2017, 9:41 AM Dear SirThanks for replyProblem got resolved. RegardsShrini On Wed, Jul 26

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread Shrinivas Shevde
Dear Sir Thanks for reply Problem got resolved. Regards Shrini On Wed, Jul 26, 2017 at 6:58 PM, Kishore P V K wrote: > Hello Shrini > > Can you please explain more clearly about your required scenario? I'm > trying to understand but did not get completely. > > Thanks > Kishore > > On Mon, Jul

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread Kishore P V K
Hello Shrini Can you please explain more clearly about your required scenario? I'm trying to understand but did not get completely. Thanks Kishore On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde wrote: > Dear All > > I have a work book which contain many daywise sheet in which I maintain >

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS
On Wed, 7/26/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Wed, 7/26/17, 'Margareta Tolliver' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS
On Wed, 7/26/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-26 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Wed, 7/26/17, Shrinivas Shevde wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 7:26 AM  Can Anyone please help me? On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas

Re: $$Excel-Macros$$ Macro for Copy Paste

2017-07-25 Thread Shrinivas Shevde
Can Anyone please help me? On Mon, Jul 24, 2017 at 2:36 PM, Shrinivas Shevde wrote: > Dear All > > I have a work book which contain many daywise sheet in which I maintain > machinewise data. > I have 20 machines all machines are not running daily so if machine is not > running I hide that rows

Re: $$Excel-Macros$$ Macro Error in line. .

2017-07-24 Thread 'Storey Thomas' via MS EXCEL AND VBA MACROS
On Mon, 7/24/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Macro Error in line. . To: "excel-macros@googlegroups.com" Date: Monday, July 24, 2017, 5:48 PM I took a quick look, but since I don't have any .CDS files,

Re: $$Excel-Macros$$ Macro Error in line. .

2017-07-24 Thread Paul Schreiner
I took a quick look, but since I don't have any .CDS files, it didn't work properly. But a couple of observations:#1) I'd add Option Explicit to the start of the module, to ensure all variables are declared.#2) It's curious that your  editors aren't showing a compile error on "Dim Dirpath as Str

$$Excel-Macros$$ Macro Error in line. .

2017-07-24 Thread Secret Shot
Hi Experts, I have created a macro to automate my work. Its working fine on my laptop, but if i am using same file for same folder in my dasktop, its skip a action. its not giving any error but also not doing what it soupose to do. Below is the line of code which is not getting excuted, means th

$$Excel-Macros$$ Macro for Copy Paste

2017-07-24 Thread Shrinivas Shevde
Dear All I have a work book which contain many daywise sheet in which I maintain machinewise data. I have 20 machines all machines are not running daily so if machine is not running I hide that rows and machine running will be visible. There is down time for a machine having many reasons which are

$$Excel-Macros$$ Macro to delete all flie in a folder using Excel list

2017-07-20 Thread Secret Shot
Hi Experts, I am having a problem with one of my macro. In my daily job, I have to do below mention task. . I will have one Excel file, in which i will have sheet1, and on sheet1 i will ahve a list of files. on the basis i will have to move certen file from one location to subfolder in same loc

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread 'Margareta Tolliver' via MS EXCEL AND VBA MACROS
On Fri, 7/7/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Friday, July 7, 2017, 2:18 PM Hi Swapnil, Just to let you know all your comments should b

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-07 Thread Puttu *
Hi Swapnil, Just to let you know all your comments should be based on the error code. Error Code column 1 2 3 all these three has different error description. Thanks Putta On Thu, Jul 6, 2017 at 7:14 PM, Puttu * wrote: > Hi Swapnil, > > Thanks you so much appreciate your time and help on get

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Thu, 7/6/17, 'Martinez David' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Thursday, July 6, 2017

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread 'Martinez David' via MS EXCEL AND VBA MACROS
On Thu, 7/6/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Thursday, July 6, 2017, 4:44 PM Hi Swapnil, Thanks you so much appreciate your time a

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-06 Thread Puttu *
Hi Swapnil, Thanks you so much appreciate your time and help on getting this macro. I think got almost what required, there is only small changes, which need to be done. Sorry its my mistake not giving right information on that. The reason I am looking a macro is I can't educate others who are ve

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS
On Wed, 7/5/17, 'Martinez David' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Wednesday, July 5, 2017

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread 'Martinez David' via MS EXCEL AND VBA MACROS
On Wed, 7/5/17, 'Yu Spain' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Wednesday, July 5, 201

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-05 Thread Swapnil Palande
Hi, Why are you not using conditional formatting. If your main purpose is to display user duplicates and empty cells, conditional formatting is best solution. Have applied both solutions (conditional formatting as well as macro) in attached excel. Regards, Swapnil. On Wed, Jul 5, 2017 at 12:24

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread 'Yu Spain' via MS EXCEL AND VBA MACROS
On Tue, 7/4/17, Puttu * wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" Date: Tuesday, July 4, 2017, 10:03 AM Thanks Sir, Formula match exactly my requirement, however I

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread Puttu *
anyhelp please On Tue, Jul 4, 2017 at 12:33 PM, Puttu * wrote: > Thanks Sir, Formula match exactly my requirement, however I have more than > 50 columns, quite difficult to input formula for every column. Thus the > reason I am looking for macro. > > Please help > > On Tue, Jul 4, 2017 at 11:21

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-04 Thread Puttu *
Thanks Sir, Formula match exactly my requirement, however I have more than 50 columns, quite difficult to input formula for every column. Thus the reason I am looking for macro. Please help On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > Hi, > > No need o

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Swapnil Palande
Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: > Experts, Any help on this will be much appreciated > > On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: > >> Hi Experts >> >> Pl

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Puttu *
Experts, Any help on this will be much appreciated On Mon, Jul 3, 2017 at 10:33 PM, Puttu * wrote: > Hi Experts > > Please help on this. > > Thanks > Putta > > On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: > >> Hi Experts, >> >> I am not a vba expert and need your help me on the attached requi

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Puttu *
Hi Experts Please help on this. Thanks Putta On Mon, Jul 3, 2017 at 9:42 PM, Puttu * wrote: > Hi Experts, > > I am not a vba expert and need your help me on the attached requirement. > > I have list of columns and from that I need to know based on the Model No. > column filter if the other col

$$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

2017-07-03 Thread Puttu *
Hi Experts, I am not a vba expert and need your help me on the attached requirement. I have list of columns and from that I need to know based on the Model No. column filter if the other columns have any duplicate values, if yes then it should display comments column as *Column Name + duplicate v

$$Excel-Macros$$ Macro to Import Tables from all Word documents in a folder to Sheet1 - Code to be amended

2017-06-09 Thread prkhan56
Hello All, I am using Office 2010 and have found this code which works perfect But I need the following amendments to the code 1) The code should *read all the files in the Folder* - now it runs on a single word document 2) It should paste the *All Word table Data under the last available Row on

$$Excel-Macros$$ Macro to select drop downs on Website, return value and cycle to next item

2017-04-07 Thread Benjamin Stoter
Hi I hope you are all well. I am relatively new to Macros and VBA. I have a sheet where I am wanting to search for Book values for cars on the website below: http://carbookvalue.co.za The site requires you to first select the car make from a dropdown, thereafter the model and thereafter the

$$Excel-Macros$$ Macro based Web navigation

2017-03-22 Thread Secret Shot
Dear Expert, I am trying to write Macro which navigate google chrome window (Entier open and if already open than jump to mention window) and select particulate link and click there (It can be either text based or courser location based click) after performing clicks it should download data from

$$Excel-Macros$$ Macro to Automate a school timetable workbook

2017-03-10 Thread Dollar Chande
Hi All, I am a novice at macro (very little knowledge) and would seek your kind assistance on my attached sheet. I am a MS Office 2013 user and attached sheet refers to automating a daily time table scheduling crisis I have to go through for school. I have tried my best to input all info i kno

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-24 Thread keisha.fry via MS EXCEL AND VBA MACROS
On Tue, 1/24/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 11:29 AM

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-24 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Tue, 1/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 8:37 AM

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 1/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 6:22 AM

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread silvers.r via MS EXCEL AND VBA MACROS
On Tue, 1/24/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 1:27 AM

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread libertystringer via MS EXCEL AND VBA MACROS
On Mon, 1/23/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Monday, January 23, 2017, 10:58 PM

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Mon, 1/23/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Monday, January 23, 2017, 5:13 PM That's great, Thank yo

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread GENIUS
That's great, Thank you very much for your help -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread mintaspriggs via MS EXCEL AND VBA MACROS
On Mon, 1/23/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "excel-macros@googlegroups.com" Date: Monday, January 23, 2017, 2:42 PM Are you wanting the end result such tha

Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-23 Thread Paul Schreiner
Are you wanting the end result such that cell A19 contains "Bill" (the value of A2)A20 = JoeA21 = DaveA22 = Fredand so on, then repeating this series for 15 sets? For THAT, you could use something like:Option ExplicitSub Dup_Sets()     Dim nRow, nRows, dRow, SetCnt, SetNo     SetCnt = 15        

$$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES

2017-01-20 Thread Izhar
[image: Inline image 1] I need code for the above name SCENARIO if I want to copy the above names below the range for about 15 times -- 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.faceboo

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-06 Thread Shrinivas Shevde
k? > The values in cells E3,F5,E8,E9 from the file in folder AA should > appear... where? > The values in cells E3,F5,E8,E9 from the file in folder BB should > appear... where? on the same sheet? > > Can you send me a couple of samples of what the files look like and what >

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread silvers.r via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 6:30 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread ashleypartridge via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, mahergeorge503 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 5:36 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread mahergeorge503 via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 4:10 AM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread keisha.fry via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 3:01 AM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 2:27 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Fri, 1/6/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 12:49 AM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10:25 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 6:55 PM On Thu

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread spainy via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 2:13 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread Paul Schreiner
es you can, To all the people you can, As long as ever you can.” - John Wesley ---------- --- On Wednesday, January 4, 2017 1:16 AM, Shrinivas Shevde wrote: Dear FriendsWaiting for reply -- Forwarded message -- From: Shrinivas Shevde Date: Tue, Jan 3, 2017

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:53 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread ileanakeating via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:02 PM On

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread silvers.r via MS EXCEL AND VBA MACROS
On Thu, 1/5/17, Shrinivas Shevde wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 11:32 AM Dear Paul Thanks for replyPlease find detila you asked forThere will

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread GENIUS
Hi Pual would be please see my question as well. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-05 Thread Shrinivas Shevde
> > On Wednesday, January 4, 2017 1:16 AM, Shrinivas Shevde < > shrinivas...@gmail.com> wrote: > > > Dear Friends > Waiting for reply > > -- Forwarded message -- > From: *Shrinivas Shevde* > Date: Tue, Jan 3, 2017 at 4:55 PM > Subject: $$Excel-Macros$$ M

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread mahergeorge503 via MS EXCEL AND VBA MACROS
On Wed, 1/4/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 4:58 PM

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread GENIUS
Hi Experts, I have mentioned question in my workbook, thanks -- 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 titl

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread julienneschindler via MS EXCEL AND VBA MACROS
On Wed, 1/4/17, Paul Schreiner wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: "excel-macros@googlegroups.com" Date: Wednesday, January 4, 2017, 4:22 PM This can be easily done.I recently created a "C

Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-04 Thread Paul Schreiner
e -- From: Shrinivas Shevde Date: Tue, Jan 3, 2017 at 4:55 PM Subject: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Dear AllI want a macro for following can Anyone help me. I have a folder ,which contain many folder,In each folder there are excel  file(File having

Fwd: $$Excel-Macros$$ Macro for Copy Paste

2017-01-03 Thread Shrinivas Shevde
Dear Friends Waiting for reply -- Forwarded message -- From: Shrinivas Shevde Date: Tue, Jan 3, 2017 at 4:55 PM Subject: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Dear All I want a macro for following can Anyone help me. I have a folder ,which

$$Excel-Macros$$ Macro for Copy Paste

2017-01-03 Thread Shrinivas Shevde
Dear All I want a macro for following can Anyone help me. I have a folder ,which contain many folder,In each folder there are excel file(File having single sheet) .I want to copy E3,F5,E8,E9 from each file and paste in one excel sheet. For eg Suppose main folder name is "complete" In this folder t

Re: $$Excel-Macros$$ macro to be edit

2016-11-24 Thread GENIUS
Sir, Thanks you very much for your help. Would you please suggest the best way for learning Macro and the videos, I have watched so many videos on macros but those videos are not so advanced. Thanks once again. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

Re: $$Excel-Macros$$ macro to be edit

2016-11-23 Thread Paul Schreiner
You're not defining a delimiter.Are you using a comma (,) as the delimiter? then you need Comma:=true, Paul- “Do all the good you can, 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 yo

Re: $$Excel-Macros$$ macro to be edit

2016-11-23 Thread GENIUS
you may see the attachment, I have made some changes in it, and then running the same but still not working. Would you please change it and then send it to me the changed copy, please don't mention in the email because I'm not so expert in macro NOTE: I'm using excel 2013 -- Are you =EXP(E:R

Re: $$Excel-Macros$$ macro to be edit

2016-11-22 Thread Paul Schreiner
It looks like it's a problem with your FieldInfo:= value. You have:FieldInfo:=Array(1, 1) when I recorded a macro, it used: FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), when I modified it to fit in your macro, it worked. although, I suspect you should change your logic.Sta

$$Excel-Macros$$ macro to be edit

2016-11-21 Thread Izhar
HELLO I'm interested to make column B as TEXT TO COLUMN thru the attach macro, I'm running the macro but nothing happend, would you please edit this macro so that the above target is achieved. Please take the whole column in the macro dont choose the range Thanks in advance -- Are you =EXP(E:RT)

$$Excel-Macros$$ Macro to Insert Blank Row

2016-11-01 Thread Kaustubh K
https://www.youtube.com/watch?v=2qKYLcCsU0M -- 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 titl

$$Excel-Macros$$ Macro to Insert Column between two columns

2016-11-01 Thread Kaustubh K
https://www.youtube.com/watch?v=AoOQizod2t0 -- 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 titl

Re: $$Excel-Macros$$ MACRO NOT WORKNIG

2016-10-14 Thread GENIUS
Thank you very much Mr. Mihai Ghilea -- 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, lik

RE: $$Excel-Macros$$ MACRO NOT WORKNIG

2016-10-13 Thread Mihai Ghilea
AS.RO http://www.metabras.com/sigle/21-ani-otel-banner.png P Think green!. Do you really need to print this email? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Izhar Sent: 14 octombrie 2016 06:46 To: excel-macros@googlegroups.com Subject: $$Excel-Ma

$$Excel-Macros$$ MACRO NOT WORKNIG

2016-10-13 Thread Izhar
can anyone please check what's wrong with the macro in the attachment -- 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 threa

Re: $$Excel-Macros$$ Macro run very slow

2016-09-20 Thread Learner Excel
please share your code. -- On Tue, Sep 20, 2016 at 1:33 PM, chandrashekarb.xls < chandrashekarb@gmail.com> wrote: > > Hi Team, > Am trying to format few rows using vba code but it taking lot of time > still have kept screenupdating & enableevent to false. > > Regards, > Chandru > > > Sent fr

$$Excel-Macros$$ Macro run very slow

2016-09-20 Thread chandrashekarb.xls
Hi Team,Am trying to format few rows using vba code but it taking lot of time still have kept screenupdating & enableevent to false. Regards,Chandru Sent from my Samsung Galaxy smartphone. -- 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$$ Macro to extract datas from PDF form to Excel sheet

2016-09-14 Thread Learner Excel
Hey, If you are good in VBA coding then you can search "pdf to excel convert vba" and take reference. Please see below the some useful urls- https://www.linkedin.com/groups/1871310/1871310-74131482 http://quickvba.blogspot.in/2010/12/import-pdf-in-excel.html http://www.vbaexpress.com/kb/getarti

$$Excel-Macros$$ Macro to extract datas from PDF form to Excel sheet

2016-09-14 Thread kvv9090
Hi, I have more than 350 PDF forms, all are identical format. I need to extract all field datas from PDF forms to Excel sheet in row wise. ie, file name with field data in row. Please guide to extract the datas from multiple PDF form to Excel. Thanks KVV -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

Re: $$Excel-Macros$$ Macro not working

2016-09-09 Thread GENIUS
Thanks brother that's great -- 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

Re: $$Excel-Macros$$ Macro not working

2016-09-09 Thread Learner Excel
Try enclosed one -- On Fri, Sep 9, 2016 at 9:37 AM, GENIUS wrote: > working perfectly, thank you very much for your help > > one more question, if I have figures in column A as shown in the sheet > and I want to take the 17% in column B of the amount of column A as shown > in the attachment t

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread GENIUS
working perfectly, thank you very much for your help one more question, if I have figures in column A as shown in the sheet and I want to take the 17% in column B of the amount of column A as shown in the attachment then how do I automate this task whenever i put a figure in column A and run

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread Learner Excel
Opps you have register incorrect data type against variable j, data type should be string [image: Inline image 1] -- On Thu, Sep 8, 2016 at 10:01 PM, GENIUS wrote: > > Sir >>> >> Thanks for your follow up, I enable which you have mentioned in the last >> mail but there is another message pleas

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread Learner Excel
Attachment missing -- On Thu, Sep 8, 2016 at 9:59 PM, GENIUS wrote: > Sir >> > Thanks for your follow up, I enable which you have mentioned in the last > mail but there is another message please see the attachment > > right now I have three version of excel i.e. 2007,2010 & 2013, I opened > th

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread GENIUS
> > Sir > Thanks for your follow up, I enable which you have mentioned in the last mail but there is another message please see the attachment right now I have three version of excel i.e. 2007,2010 & 2013, I opened the file in excel 2010 and I also have Microsoft outlook 2010 -- Are you =EXP(

Re: $$Excel-Macros$$ Macro not working

2016-09-06 Thread Learner Excel
Brother, you have to add Outlook reference as well [image: Inline image 1] -- On Tue, Sep 6, 2016 at 9:18 AM, GENIUS wrote: > Sir > > I'm waiting for your reply very anxiously > > -- > 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 offici

Re: $$Excel-Macros$$ Macro not working

2016-09-05 Thread GENIUS
Sir I'm waiting for your reply very anxiously -- 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 t

  1   2   3   4   5   6   7   8   9   10   >