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

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

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>

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

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

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

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

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

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

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

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

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 <shrinivas...@gmail.com> 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 re

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

2017-07-27 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 >

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 11

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 11

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, July 26, 2017, 10

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 <shrinivas...@gmail.com> 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

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 >

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 <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ Macro Error in line. . To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Monday, July 24, 2017, 5:48 PM

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

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

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

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

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 * <puttu...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Friday, July 7, 2017, 2:18 PM

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Thursday, July 6, 2017, 11

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 * <puttu...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Thursday, July 6, 2017, 4:44 PM

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Wednesday, July 5, 2017, 11

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: excel-macros@googlegroups.com Date: Wednesday, July 5, 2017, 2

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 * <puttu...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Date: Tuesday, July 4, 2017, 10:03 AM

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,

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

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 *

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

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

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

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

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

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017,

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 8

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 6

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017

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 <excel-macros@googlegroups.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Monday, January 23, 20

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 <izharra...@gmail.com> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com> Cc: schreiner_p...@att.net Da

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 <schreiner_p...@att.net> wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Monday, Jan

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 @

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

2017-01-06 Thread Shrinivas Shevde
what the files look like and what > you want the summary sheet to look like? > > > *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 a

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 6

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 5

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 4

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 2

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 12

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 6

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 2

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

2017-01-05 Thread Paul Schreiner
e places you can, At all the times 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 <shrinivas...@gmail.com> wrote: Dear FriendsWaiting for reply -- Forw

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12

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 <shrinivas...@gmail.com> 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

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

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* <shrinivas...@gmail.com> > Date: Tue,

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 <excel-macros@googlegroups.com> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Wednesday, January 4, 2017, 4

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

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 <schreiner_p...@att.net> wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> Date: Wednesday, January 4, 2017

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

2017-01-04 Thread Paul Schreiner
r reply -- Forwarded message -- From: Shrinivas Shevde <shrinivas...@gmail.com> 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 f

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

2017-01-03 Thread Shrinivas Shevde
Dear Friends Waiting for reply -- Forwarded message -- From: Shrinivas Shevde <shrinivas...@gmail.com> 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

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

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

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

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

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

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

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

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,

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

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

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

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

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

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

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.

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

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 >

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

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

2016-09-03 Thread Learner Excel
You need to add "Microsoft Outlook 14.0 Object Library" in references -- On Sat, Sep 3, 2016 at 10:10 PM, Izhar wrote: > > Please see the question 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) !

  1   2   3   4   5   6   7   8   9   10   >