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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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        

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

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

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

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

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

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

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

PFA. METABRAS Mihai Ghilea | Administrator retea T: +4(0) 268.407.410 | F: 0268.407.426 | M: 0728.994.113 A: Strada Grivitei A44, Cod postal RO500182 E: mihai.ghi...@metabras.ro W: 3W.METABRAS.RO http://www.metabras.c

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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) ! Join official Facebook

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

On Saturday, September 3, 2016 11:42 AM, GENIUS wrote: THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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

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

THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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

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

Hi, I believe your code is extracting the file name from the path which you are browsing. Your code had problem in substitute formula. Please check Function Extractfilename(url As Variant) As String For i = 1 To Len(url) If Mid(url, i, 1) = "\" Then x = x + 1 End If Next i 'n = Application.Worksh

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

For list of file name, use enclosed code. -- On Fri, Sep 2, 2016 at 10:33 PM, Izhar wrote: > > Please open the file and see the question > > -- > 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

Re: $$Excel-Macros$$ Macro error in opening file

I simplified the macros wrote two versions.One using Dir() and another with the FileSystem object. they both work just fine: Sub First_Macro()     Dim MyFile As String     Dim path As String         path = "D:\For Pankaj\Dump\"     MyFile = Dir(path & "*L1.xlsx")         Do While MyFile <> ""   

Re: $$Excel-Macros$$ Macro error in opening file

It is working perfectly fine at my end. On Thu, Apr 28, 2016 at 11:36 AM, Secret Shot wrote: > I tried that option... When I am using > > Workbooks.Open (path & MyFile) > > Then my loop is going in infinity and every time it is reopening the first > file only.. Which 04 L1. Xlsx > > Pls suggest

Re: $$Excel-Macros$$ Macro error in opening file

I tried that option... When I am using Workbooks.Open (path & MyFile) Then my loop is going in infinity and every time it is reopening the first file only.. Which 04 L1. Xlsx Pls suggest On Apr 28, 2016 11:02 AM, "Abhishek Jain" wrote: > In your first macro, instead of: > > Workbooks.Open (My

Re: $$Excel-Macros$$ Macro error in opening file

In your first macro, instead of: Workbooks.Open (MyFile) use: Workbooks.Open (path & MyFile) HTH On Thu, Apr 28, 2016 at 9:26 AM, Secret Shot wrote: > Hi all, > > Can anybody pls look into it. I am really hoping that I will get > resolution from this forum. > On Apr 28, 2016 1:35 AM, "Secre

Re: $$Excel-Macros$$ Macro error in opening file

Hi all, Can anybody pls look into it. I am really hoping that I will get resolution from this forum. On Apr 28, 2016 1:35 AM, "Secret Shot" wrote: > Dear Experts, > > I want to open all files in a folder with suffix of "L1", where i have > below files in a folder > > 04 L1.Xlsx > 04 L2.Xlsx > 05

Re: $$Excel-Macros$$ Macro send different files to different recipients

What do you mean by "it generates an error"?Turning off screen updating imply makes it so that the screen isn't flashing and updating whenever you switch between sheets or updates values.It doesn't do ANYTHING to handle errors. "Alerts" is what the messages are that are things like:prompts when r

Re: $$Excel-Macros$$ Macro send different files to different recipients

Hi, Any update on this? Do I need to run/duplicate this macro for each email? also strangely If I run the macro, I then start receiving duplicate emails in my email box, do I need to activate/deactivate something? Thank you very much in advance, jorge On 16 March 2016 at 13:01, Jorge Marques wro

Re: $$Excel-Macros$$ Macro send different files to different recipients

In VBA, you'll need to include the "Microsoft Outlook 14.0 Object Library "(under Tools->References) then, this VBA code should work:(use your own email addresses for "name@domain")---Option Explicit Sub Test_Mail()     Dim Stat, fso     Dim Mail_Addr_To, Mail_Addr_CC, Mai

Re: $$Excel-Macros$$ Macro send different files to different recipients

Hi Paul, i have the Microsoft Outlook 15.0 Object Library. The Macros runs fine if I remove the updates and display alerts, if not it generates error. 'Application.ScreenUpdating = False 'Application.DisplayAlerts = False This is great starting point, my challenge now besides the error is how d

Re: $$Excel-Macros$$ Macro send different files to different recipients

Hi Paul, Yes I use Outlook, Having Outlook opened for it to work is not an issue for me, it is always open from the moment computer is on until is shut down. Providing the function would be more than helpful :). Thank you very much! Best, Jorge On 15 March 2016 at 19:15, Paul Schreiner wrote:

Re: $$Excel-Macros$$ Macro send different files to different recipients

First of all, Excel doesn't have email capability.What it DOES do, however, is allow you to use your existing email software. At least somewhat. What email do you use?I use Outlook.With that, I can write a function that takes the email address and filename as input and creates/sends the appropria

Re: $$Excel-Macros$$ Macro Require

please support me. On Mon, Feb 29, 2016 at 6:19 PM, jayendra gaurav wrote: > Dear All, > > > I have 1150 separate files of part list Variant wise. and other hand I > have part list can you please suggest way that how can I search part usage > quantity of each part no as per variant wise. > > *Ex

Re: $$Excel-Macros$$ macro for custom views

Oh that's really 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

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Hi, Thanks so much for the code but for me even though I select the folder (which currently contains two filled in Word forms), it only transfers the headings and "Please enter text" for each field even though text has been filled in. Could this be because I used plain text content controls?

Re: $$Excel-Macros$$ Macro to Import Word Tables to Excel from a folder

Hi, I know I'm a bit late to this so might not get answer but your code is exactly what I need to do but I get a runtime error on the line Dim appWord As Word.Application with the error "User-defined type not defined", do you have any idea why? Thanks so much for the code. On Wednesday, Octobe

Re: $$Excel-Macros$$ macro for custom views

Do you mean: Application.Dialogs(xlDialogCustomViews).Show ? 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 you can, As long as ever you can.” - John We

Re: $$Excel-Macros$$ Macro Popup Window with Combo Box based on Cell values that might change

Thank you Paul, I was able to get everything to work now. Much appreciated. Results are now chosen via a listbox, and the selection(s) from this listbox decide which rows of data to keep from the master list. Thanks again! On Friday, December 11, 2015 at 8:29:01 AM UTC-5, Paul Schreiner wro

Re: $$Excel-Macros$$ Macro Popup Window with Combo Box based on Cell values that might change

There's several ways of doing this.Here are some: 1) copy the unique info to your second sheet and name the range.   Then, use this named range in the "RowSource" attribute for your combobox in the userform.2) "initialize" event macro for the userform,    Read through the data and load unique va

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Good Morning Mandeep , I need put Week OFF basis of Given chart (Day wise WO count).(Excel attached for your reference ) Lets example we have 20 agents in team and we need to give Weekly off to everyone basis of decided Day wise count and WO should not be repeated within Week. Please refer th

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Hi, Give us a clear explanation to what to achieve by giving some output !! Regards, Mandeep baluja -- 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 RU

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Thanks a lot Mandeep for quick help . If don't mind can you pls do one more help. I have a sheet where i have given shift wise weekly off i want to assign WO in another sheet by Formula in day wise. Excel sheet attached for your easy reference. On Wed, Dec 9, 2015 at 6:20 PM, Mandeep Bal

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Check this out and let me know !!! Two formulas to be used !! Regards, Mandeep baluja -- 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

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Check this out !!! Regards, Mandeep baluja On Wednesday, December 9, 2015 at 5:22:27 PM UTC+5:30, Sadiq wrote: > > I did not required the count of name . > > I need that names in cells of given count. > > e.g - > > Name- Sadiq > Count 20 > > I need this name in 20 times in "a" cell. > > > On

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

I did not required the count of name . I need that names in cells of given count. e.g - Name- Sadiq Count 20 I need this name in 20 times in "a" cell. On Wed, Dec 9, 2015 at 3:45 PM, Mandeep Baluja wrote: > > Check this out !! > Mandeep baluja > > > > On Wednesday, December 9, 2015 at 3:

Re: $$Excel-Macros$$ Macro (Excel) Need data via Formula

Check this out !! Mandeep baluja On Wednesday, December 9, 2015 at 3:31:45 PM UTC+5:30, Sadiq wrote: > > Hello Team , > > > > I have a excel sheet where have Team Name in “A” column and in “B” column > we have count. I need Team name details in another sheet with count of Team > Name v

Re: $$Excel-Macros$$ Macro to populate a column with data from another column

after applying formula u can copy as paste values and then select blank and delete them On Wed, Nov 11, 2015 at 10:42 AM, Andre Polivarov wrote: > Hi Ashish > > Thank you for you prompt response. > > One thing: I need to have an empty field in a "Parent Category" column if > a "Category Name" =

Re: $$Excel-Macros$$ Macro to populate a column with data from another column

Hi Ashish Thank you for you prompt response. One thing: I need to have an empty field in a "Parent Category" column if a "Category Name" = "parent category y" Group ID Client ID Category ID Category Name Parent Category ID 0 3001 101 parent category 1 (should be empty) 0 3001 102 sub c

Re: $$Excel-Macros$$ Macro to populate a column with data from another column

see if it helps On Wed, Nov 11, 2015 at 3:52 AM, Andre Polivarov wrote: > Hello, > > I need to come up with a Macro to populate 50 rows in column (E) > Parent Category ID . > > I have a table with the following columns: (A) Group ID, (B) Client ID, > (C) Category ID, (D) Category Name, (E) P

Re: $$Excel-Macros$$ MACRO VBA

Can you provide a sample file showing what you'd like?Are you looking for  Conditional Formatting for the column? Are you looking for a macro to highlight the date?or even a Change_Event macro to format the column?Paul- “Do all the good you can, By all the

Re: $$Excel-Macros$$ macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

Hello Paul What can I say? Its perfect - exactly what I needed - THANK YOU SO MUCH ps it may seem easy for you! Thanks again for your help, I'm so grateful. Best regards Nyree On 03-Sep-15 2:34 PM, Paul Schreiner wrote: That's simple enough to do. (I know, if it's so simply, why isn't it obvio

Re: $$Excel-Macros$$ macro to loop through data sheet , fetch 8 rows at a time and put in new sheet

That's simple enough to do.(I know, if it's so simply, why isn't it obvious?) to do JUST what you want in your example, you could use:Sub Make_Sheets()     Dim rSource, rDest     rDest = 5     Sheets("Sheet1").Range("B3").Value = Sheets("data").Range("F2").Value     For rSource = 2 To 9     rDe

Re: $$Excel-Macros$$ Macro to strip LinkedIn Company Page Followers.

could you please share the sample file and output u like to see On Wed, Aug 26, 2015 at 3:46 PM, MMartin wrote: > Hi, > > I am trying to use this macro to strip and sort my company page > followers. I am not technical but found this and have tried to get it to > work for me. > > It appears to s

Re: $$Excel-Macros$$ Macro from non specific cell

What you're asking for can be accomplished without a macro.In Cell A2, you'd have your starting date (or the date for the first record).Then in Cell A3, put: =IF(B3="","",IF(B3=0,A2+1,A2))and drag it down the column. Basically, this makes use of the fact that Excel stores dates as numbers.The num

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Superr...wow... Thanks a million Also thanks to De Premor for his help too. God Bless you all On Mon, Aug 3, 2015 at 9:19 PM, Mandeep Baluja wrote: > check once again :) Regards Mandeep > > Private Sub Worksheet_Change(ByVal Target As Range) > On Error Resume Next >' MsgBox Targe

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

check once again :) Regards Mandeep Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ' MsgBox Target.Value2 If Target.Column = 1 Then Target.Offset(0, 1).Select ActiveSheet.Pictures.Insert("C:\Users\Mandeep.baluja\Desktop\a\" & Target.Value2 & ".j

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Thanks Mandeep...for the code. One small issue I want the respective picture to be deleted Now if I delete any value in Col A then it deletes all the pictures. Can you please rectify. If the value in Col A is deleted then only the respective pictures in Col B should be deleted .. and not all the pi

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

check this out !! Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ' MsgBox Target.Value2 If Target.Column = 1 Then Target.Offset(0, 1).Select ActiveSheet.Pictures.Insert("C:\Users\Mandeep.baluja\Desktop\a\" & Target.Value2 & ".jpg").Select

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

No...sorry...I have checked everything. It only takes the file 1.jpg...and not any other files. The files are there in the folder and they are in jpg format. That is the reason I sent the sample pics folder for testing on your end May be you can give me a code which should run looking at values in

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Hi, Still curious with your problem, there is few more thing we need to check. 1. Make sure picture that you want to load is exist in the referenced folder on the code 2. Make sure it image with JPG format, not PNG, GIF, BMP or other image format, just JPG (the extention is .jpg) Thanks, wait

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Are you sure ? i've been test and try the code, and it work for any other picture. Did you know how that code work ? let me explain a little /*) //the code is in blue, and green is my comment / *'This code will only executed before you double clicking on any cells / ranges on sheet* *Private Su

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Thanks for the quick response. It works only for 1.jpg and not for any other pictures. Kindly look into the code thanks once again. On Sat, Aug 1, 2015 at 12:00 AM, De Premor wrote: > Here is the code, you can make changes or experiment with it > > Private Sub Worksheet_BeforeDoubleClick(ByV

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

Here is the code, you can make changes or experiment with it Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) On Error Resume Next If Target.Column = 1 Then Target.Offset(0, 1).Select ActiveSheet.Pictures.Insert("C:\Product\Pictures\" &

Re: $$Excel-Macros$$ Macro for Column to Rows

Thanks! Paul, its all done... On Fri, Jul 24, 2015 at 5:21 PM, Paul Schreiner wrote: > Based on your sample file, I put together two macros: > RowsToColumns > ColumnsToRows > > you need to select an input sheet and run the appropriate macro. > > I'm sure this doesn't do ALL you need, but it shou

  1   2   3   4   5   6   7   8   9   10   >