Re: $$Excel-Macros$$ Excel Macro Help

2017-12-19 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: excel-macros@googlegroups.com Date: Tuesday, December 19, 201

Re: $$Excel-Macros$$ Excel Macro Help

2017-12-18 Thread 'Julienne Schindler' via MS EXCEL AND VBA MACROS
On Mon, 12/18/17, V wrote: Subject: Re: $$Excel-Macros$$ Excel Macro Help To: "MS EXCEL AND VBA MACROS" Date: Monday, December 18, 2017, 7:56 PM Hi, do you know how can I get using validations in Google Drive that change the colo

Re: $$Excel-Macros$$ Excel Macro Help

2017-12-18 Thread V
Hi, do you know how can I get using validations in Google Drive that change the color by codes. El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5), GENIUS escribió: > > look at the attachment, I can do only this. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-11 Thread GENIUS
look at the attachment, I can do only this. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! 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$$ Excel Macro Help

2017-10-09 Thread Ram Prakash Palaniswamy
Dear Paul, Thank you for your help. I have attached both files in the mail. In the master file I’ve highlighted some columns, if I update any value in the master file automatically it’s need to update in the another attached excel.. Thank you in advance. On Mon, 09 Oct 2017 at 14:41, Paul Schre

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-09 Thread Paul Schreiner
sure.fairly easily done.Please provide sample files.  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 Wesley --

Re: $$Excel-Macros$$ excel macro help on regular basis required- on weekly payment/hourly basis

2013-08-04 Thread Sam Mathai Chacko
As you can imagine, it's not easy to set up such a relationship that pays on a weekly basis. Instead of paying weekly, why don't you hire a developer on project basis only as and when you need it? You could use http://www.excelfox.com/forum/f21/ to post queries that you are willing to pay for. On

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

2012-12-17 Thread ashish koul
can you share the sample file On Mon, Dec 17, 2012 at 9:57 PM, sw1085 wrote: > Hi all, > > I've been searching for hours looking for a generic macro to help with the > following problem. > > If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then > copy that cell plus the previ

RE: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Dave Bonallack
Hi, VBA code for yesterday's date is: A = Date - 1 The variable 'A' will contain yesterday's date. Regards - Dave Date: Tue, 25 May 2010 12:08:06 +0530 Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day From: nsund...@gmail.com To: excel-macros@googlegroups.com Hi Friends, Pleas

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Rakhee Koshy
Hi, I want to learn macros step by step. Please guide me. Regards Rakhee -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Putta Madaiah
use the following formula to get only the date. =TODAY()-1 Regards, Putta Madaiah On Tue, May 25, 2010 at 1:15 PM, Swapnil Palande wrote: > Hi Sundarvelan, > > There is no need to write vba code for this. > > Use following function: > =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

2010-05-25 Thread Swapnil Palande
Hi Sundarvelan, There is no need to write vba code for this. Use following function: =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11 =DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date ex: 5/24/2010 Regards, Swapnil. On Tue, May 25, 2010 at 12:08 PM, Su

Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-05 Thread Sundarvelan N
Hi friends, Please help. How to automatically set the range to clear the pagebreaks in different data. Thanks, Sundarvelan On Wed, May 5, 2010 at 5:42 AM, siti Vi wrote: > try: > > Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone > > > -- > On May 4, 6:09 pm, Sunda

Re: $$Excel-Macros$$ Excel Macro help : How to remove Page Break

2010-05-04 Thread siti Vi
try: Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone -- On May 4, 6:09 pm, Sundarvelan N wrote: > Hi Friends, > Please help me to solve the final step of my project. > I need to remove the page break lines to the end of the column upto which > the data is available. > Thanks

Re: $$Excel-Macros$$ Excel-Macro : Help

2010-04-26 Thread OSA
Hello Sundarvelan, I suggest you try first the subtotal function of excel. On the menu click on data then sub total, follow as prompted. It should give you what you need. On Sun, Apr 25, 2010 at 7:49 PM, Sundarvelan N wrote: > Hi Friends, > > I need a macro to sort the below excel by client a

Re: $$Excel-Macros$$ Excel-Macro : Help

2010-04-25 Thread siti Vi
Subtotal ?? Sub SortAndSubTotalOnColumn4() Cells(1).CurrentRegion.Select Selection.Sort _ Key1:=Range("A2"), Order1:=xlAscending, _ Key2:=Range("B2"), Order2:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom, _ DataOpt