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

On Tue 3 Jul, 2018, 08:51 ravikiran kandikonda, wrote: > Hi, Is it a freelance project? How much you want to pay? I can help you on > this. > > On Saturday, 30 June 2018 15:52:29 UTC+8, vikas khen wrote: >> >> Hi Experts, >> >> >> Request you to kindly help me with VBA macro which will fetch the

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

Hi Ravikiran, No, It's not a freelance project! I know making of Macro for such type sheet is time consuming and requited lots of effort and I respect of the same. But currently I am not in the position to spending the money on said matter. However I really thank you for paying attention to my

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

Hi, Is it a freelance project? How much you want to pay? I can help you on this. On Saturday, 30 June 2018 15:52:29 UTC+8, vikas khen wrote: > > Hi Experts, > > > Request you to kindly help me with VBA macro which will fetch the data > from *Outlook mail folder* and will arrange the same in requ

Re: $$Excel-Macros$$ Re: Need Macro

Hi David, For current data word current will be mentioned and for prior data word prior would be mentioned. Regards, Kaushik Savla On Mon, Apr 30, 2018, 15:54 who wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (david.lanm...@gmail.com

$$Excel-Macros$$ Re: Need Macro

Hello Again, I am not sure what "current" means and how to identify "current", part of #3? Can this be accomplished by sorting? Maybe this is a date? Thanks, David On Friday, April 27, 2018 at 12:46:20 AM UTC-7, KAUSHIK SAVLA wrote: > > Hi Team, > > Need your help in creating macro which would

Re: $$Excel-Macros$$ Re: Need Macro

Hi David, Please let me know what additional information is needed. Regards, Kaushik Savla On Sat, Apr 28, 2018, 07:42 who wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (david.lanm...@gmail.com) Add cleanup rule >

$$Excel-Macros$$ Re: Need Macro

On Friday, April 27, 2018 at 12:46:20 AM UTC-7, KAUSHIK SAVLA wrote: > > Hi Team, > > Need your help in creating macro which would do following:- > > 1. To delete whole data in Sheet C > 2. Copy whole data of Sheet B and paste it in Sheet C > 3. Go to the Sheet A. Filter for "Current" in Column B

$$Excel-Macros$$ Re: need macro for dyanmic sms through excel via bluetoooth

On Wednesday, December 29, 2010 at 8:01:07 PM UTC-6, Mohanraj shunmugam wrote: > dear friends, > >    i saw some web based sms companies have excel plugin it will sent dynamic > sms via web > > (dynamic sms :-excel sheet 1 column is mobile no 2 column is message it will > send each number each

$$Excel-Macros$$ Re: need macro for dyanmic sms through excel via bluetoooth

On Sunday, December 31, 2017 at 9:47:02 AM UTC-6, Mari Ayala wrote: > On Wednesday, December 29, 2010 at 8:01:07 PM UTC-6, Mohanraj shunmugam wrote: > > dear friends, > > > >    i saw some web based sms companies have excel plugin it will sent > > dynamic sms via web > > > > (dynamic sms :-excel

$$Excel-Macros$$ Re: need macro for dyanmic sms through excel via bluetoooth

On Wednesday, December 29, 2010 at 8:01:07 PM UTC-6, Mohanraj shunmugam wrote: > dear friends, > >    i saw some web based sms companies have excel plugin it will sent dynamic > sms via web > > (dynamic sms :-excel sheet 1 column is mobile no 2 column is message it will > send each number each

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

Dear Mandeep, This was wonderful file. I used it for one of my project. However required one improvement. Tried to see the code, but it is lock hence. need your guidance. - I need to select entire data in sheet. currently it is not taking data after black rows. - The color and formating becomes

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

Dear Check this file ;) Regards, Mandeep On Thursday, March 5, 2015 at 8:39:29 PM UTC+5:30, Prabhu Pinky wrote: > > Hi experts, > I have around 10-15 excel file in a folder and updated every week. > I need macro in master file which will open each file from folder and copy > in master file. >

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hi Mandeep, Can we have only one code which you provided earlier that will include filtering the required data(as per point 3.)and then paste the records in daily file & previous file. Thanks, Ujjwal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Use this code to apply filter do the changes as per your data. Sub Filter() Dim lastrow Range("m2:q65536").Select Selection.Clear lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row Range("A1:e" & lastrow).Select Sheets("Mainsheet").Range("A1:e" & lastrow).AdvancedFilter Action:=xlFilt

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Also can you provide me sloution for the 3. Point. -- 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 thre

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Also can you provide me sloution for the 3. Point. -- 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 thre

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

you can set your default path by copying it in code there is no need to change it again and again. add these lines of code in bottom Workbooks(file1 & ".xlsx").Close savechanges:=False Workbooks(file2 & ".xlsx").Close savechanges:=False Thanks *Mandeep Baluja* On Friday, November 14, 2014 11:3

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hello , Thanks for the code. Few changes needed : 1.Can we have a default path as the main folder “daily ATB”.(This will help to compare file saved in any sub folder of “Daily ATB”) 2.Post the data is copied and pasted in the comparison report daily file and previous file need to be auto close

Re: $$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hi Yudy, Share your data with example. Regards Ashish On Sun Nov 16 2014 at 3:37:04 PM wrote: > Hello , > > Can anyone please help me with a solution > > .Yudy > > On Friday, November 14, 2014 11:31:53 PM UTC+5:30, yudy...@gmail.com > wrote: >> >> Hello , >> >> I am in need of macro to co

$$Excel-Macros$$ Re: Need macro to copy date from excel file to another excel file

Hello , Can anyone please help me with a solution .Yudy On Friday, November 14, 2014 11:31:53 PM UTC+5:30, yudy...@gmail.com wrote: > > Hello , > > I am in need of macro to copy the required data from excel sheet for > comparison purpose. > > i have the detail requirement. > > Let me know

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

On Oct 11, 2014 6:51 AM, "Ahmed Siddique" wrote: > > Thanks Paul. > Actually I am learning on daily basis following your posts and implementing as much in my projects. I was not able to change the captions actually, so had to use two buttons. > But thanks a lot. > > On Oct 10, 2014 7:50 PM, "Paul

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

you can.” - John Wesley - > > From: Ahmed Siddique >To: excel-macros@googlegroups.com >Sent: Saturday, October 11, 2014 1:51 AM >Subject: Re: $$Excel-Macros$$ Re: Need Macro enabled Button to select

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

Thanks Paul. Actually I am learning on daily basis following your posts and implementing as much in my projects. I was not able to change the captions actually, so had to use two buttons. But thanks a lot. On Oct 10, 2014 7:50 PM, "Paul Schreiner" wrote: > What do you know of Excel and VBA? > > T

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

What do you know of Excel and VBA? This is a pretty simple exercise. Simply insert an ActiveX button. change the Properties so that the name is: Btn_Filter. Select "View Code" add this to the macro: Private Sub Btn_Filter_Click() If (Left(UCase(Btn_Filter.Caption), 4) <> "TYPE") Then

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

Change macro security mode to medium. Don't enable macro else file will get close automatically. On Jul 30, 2014 11:49 AM, "Rohit Jadhav" wrote: > Hi Vibhav, > The password "password" is not working. When I enter it first time, I get > a window asking for write password. Whether you enter "passwo

$$Excel-Macros$$ Re: need macro

Hi Vibhav, The password "password" is not working. When I enter it first time, I get a window asking for write password. Whether you enter "password" or click read only the file automatically closes. I have set macro security to "enable all macros" mode. Can you tell me what I'm doing wrong here

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

hi password is password, but before enabling macro delete all content of sheet 1 Cheers!! On Mon, Jul 28, 2014 at 1:41 PM, Rohit Jadhav wrote: > Hi Vaibhav > I want to see the code can you please provide the password for > the file. > > On Thursday, July 24, 2014 4:05:55 PM UTC+5:

$$Excel-Macros$$ Re: need macro

Hi Vaibhav I want to see the code can you please provide the password for the file. On Thursday, July 24, 2014 4:05:55 PM UTC+5:30, SUDHIR VERMA wrote: > > Dear Experts, > > I need macro, which can encrypt with password after defined no of days. > > Example- i make file today, after

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

Beta Sent: Friday, October 18, 2013 3:07 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Need macro for converting PDF in to given format Hi Bs, Thanks for the reply. I had check the Excel sheet on windows XP and it's working fine, But i have instilled Window

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

Hi Bs, Thanks for the reply. I had check the Excel sheet on windows XP and it's working fine, But i have instilled Windows 7 -64 Bit. In windows 7 64 bit it shows same error. Hence request you to kindly assist/ Guide me for howto opening the same on Windows 7 - 64 bit. Waiting for your reply. Re

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

Hi Bs, Fist upon thank you so much for giving me support it will be very helpful if you solve this. My Ms office version is - 2010. pls let me know if you required any other information Regards On Thu, Oct 17, 2013 at 4:49 PM, Basole wrote: > Dear Jocky, what is your version of MS Office? >

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

Dear Jocky, what is your version of MS Office? Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta escreveu: > > Hi Team, > > I need help on above attached sheets, In the excel sheet i should browse > the PDF file (which is attached in this mail ) and then the output data >

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

Hi Jocky, I'm checking out the reason of error. Anyway see your text file attached to test another worksheet. Basole. Em quarta-feira, 16 de outubro de 2013 11h40min34s UTC-3, jocky Beta escreveu: > > Hi Team, > > I need help on above attached sheets, In the excel sheet i should browse >

$$Excel-Macros$$ Re: Need macro export data into workbooks with grand Totals and specified format

Hi ravinder negi, Thanks for given this macro but it was not working in my end i was entered multiple times range criteria but i was not work it shows error debug message please help me out. thanking you. *(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´

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

-Macros$$ Re: Need macro to split the files > I have also created thousands of functions, and PivotTables Good :) > you're asking or you're selling web site? I'm am sharing ;) As Excel MVP, I have to share my knowledge for free on the web. So when a question is in relation wi

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

ok thx , I understand 2011/8/31 Frederic LE GUEN - MVP Excel > > > > I have also created thousands of functions, and PivotTables > Good :) > > you're asking or you're selling web site? > I'm am sharing ;) > As Excel MVP, I have to share my knowledge for free on the web. > So when a question is

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

> I have also created thousands of functions, and PivotTables Good :) > you're asking or you're selling web site? I'm am sharing ;) As Excel MVP, I have to share my knowledge for free on the web. So when a question is in relation with one of the page of my website, I post the related page. -- -

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

I have also created thousands of functions, and PivotTables you're asking or you're selling web site? 2011/8/30 Frederic LE GUEN - MVP Excel > Hi > I have written today a page about the way to create a worksheet > function of a criteria > http://www.excel-exercice.com/en/2074/creation-of-work

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

Hi I have written today a page about the way to create a worksheet function of a criteria http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria I'm sure that this tip will help you ;) On 30 août, 06:52, anu gomathi wrote: > Hi Experts, > > I am very new to this forum. > > Atta

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

Please attach file 2011/8/30 anu gomathi > Hi, > > Can u pls explain me the steps. Any way i need the summary in the detail > sheet. > > Regards > Anu > > On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel < > fleg...@gmail.com> wrote: > >> Why don't you use a pivot table with the

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

Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel < fleg...@gmail.com> wrote: > Why don't you use a pivot table with the table option to split your > document by Division and Regional lea

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

Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi wrote: > Hi Experts, > > I am very new to this forum. > > Attached the details report & the out put file. I need a macro to split the > workbook as per the

Fwd: $$Excel-Macros$$ RE: Need macro for attd workbook

-- Forwarded message -- From: vidyut more Date: Thu, Jul 22, 2010 at 6:45 PM Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook To: excel-macros@googlegroups.com Sir i stuck in your macro. 1 ) filter is not working 2) I have usecanother macro for that sheet then

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

unprotect the sheet. The sheet will reprotect after any change. > As for multiple selections, why do you need it? > Regards - Dave. > > -- > Date: Thu, 22 Jul 2010 20:09:26 +0530 > > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook > F

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

+0530 Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook From: sudhir.p...@gmail.com To: excel-macros@googlegroups.com CC: davebonall...@hotmail.com in addition of this macro,there is one more thing , if i want to edit one of my cell, and want to allow multiple secletion, then how it

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

gt; > > > On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack > wrote: > >> You're welcome. >> Dave. >> >> > From: vidyutm...@gmail.com >> > Date: Thu, 22 Jul 2010 17:42:58 +0530 >> > Subject: Re: $$Excel-Macros$$ RE: Need macro for a

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

Dear Dave Bonallack sir thanks for sharing this important macro On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack wrote: > You're welcome. > Dave. > > > From: vidyutm...@gmail.com > > Date: Thu, 22 Jul 2010 17:42:58 +0530 > > Subject: Re: $$Excel-Macros$$

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

Sir i stuck in your macro. 1 ) filter is not working 2) I have usecanother macro for that sheet then where should i put ur macro. my macro as follows 'Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range Dim pcNum As Long Dim party As String Dim prod As String Dim ws As Worksheet

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

You're welcome.Dave. > From: vidyutm...@gmail.com > Date: Thu, 22 Jul 2010 17:42:58 +0530 > Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook > To: excel-macros@googlegroups.com > > Thank you so much sir "Dave Bonallack". Its what i was looking for.

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

Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks again On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack wrote: > Hi, > Have a look at the attached. > The macro prevents the selection of multiple cells. > If the selected cell contains data, it will be locked. > If the sele

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

Hi, Have a look at the attached. The macro prevents the selection of multiple cells. If the selected cell contains data, it will be locked. If the selected cell is blank, it will be unlocked. Once a blank cell is edited, it will be locked automatically. The protection is not password protect

$$Excel-Macros$$ Re: need macro for a simple vlookup and pivot

Hello Hemanth, Recorded macro many fix certain things so i do not want to do that, I want the engine to be volatile.. For example, For example if any new name gets included and where i have to exclude those or in other case name Z is not available in next report for which it thorough error. He

$$Excel-Macros$$ Re: need macro for a simple vlookup and pivot

Hi I did not understand what you want to accomplish with a VBA code. But can i pls know why you hate recorded macros? Hemant Hegde 2009/11/2 vinod rao > HI Team, > > Need a VBA code for doing pivot - below condition is needed > > > > > 1 > Z F C > I am eliminating these from pivot ta

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

*hi dear please send attachement * On 10/31/09, karthikeyan wrote: > > > hi, > I put a validation in one excel worksheet .This worksheet doesn't > allow paste values from any worksheet/workbook. > tks > karthik > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: need macro for date selection urgent!

I have sent you a file with the macro.Check that out.. Not able to attached the file here... sorry!!! On Jun 21, 8:07 pm, kunal wrote: > Hi, > > I am trying to build a xl sheet for automation of the work that we do. I am > stuck in a point were i find difficult to move ahead. > > my problem is