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

2014-08-11 Thread venkateswara reddy
THANK YOU so much for your time & efforts. Regards venkat On Thursday, August 7, 2014 6:29:25 PM UTC+5:30, Vabz wrote: > > hi > > check this., as soon as any data is changed you will get notification to > update it.. > > Cheers!! > > On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy > wrote:

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

2014-08-07 Thread Vaibhav Joshi
hi check this., as soon as any data is changed you will get notification to update it.. Cheers!! On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy < venkateswara.red...@gmail.com> wrote: > thank you so much for this. I'm grateful again for your time and > considerable expertise. > > This is pe

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

2014-08-04 Thread venkateswara reddy
thank you so much for this. I'm grateful again for your time and considerable expertise. This is perfectly right answer , which i am looking for automation from many days. finally u did it. Please it should match as per the many number of order numbers like VLOOKUP function. please send me fi

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

2014-08-01 Thread Vaibhav Joshi
PFA, we can modify to suits you once you revert on my query. Cheers!! On Thu, Jul 31, 2014 at 12:05 PM, Vaibhav Joshi wrote: > Thanks for file.. > > Query! > > say Group1 status for order 1 is ABC, so on next day whether there will be > any change in status or not? > > If it changes then do yo

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

2014-07-31 Thread venkateswara reddy
Hi Vabz, Thanks for the Query, Every day I will replace manually all order numbers & status with new data in all the groups. What I want is for the required order numbers only ,want to see coresponding status from all the gorups status in the master sheet daily. I think aswered you query! P

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

2014-07-30 Thread Vaibhav Joshi
Thanks for file.. Query! say Group1 status for order 1 is ABC, so on next day whether there will be any change in status or not? If it changes then do you want to replace existing status in Master file or add new record? Cheers!! On Wed, Jul 30, 2014 at 11:14 AM, venkateswara reddy < venkates

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

2014-07-29 Thread venkateswara reddy
Hi Vabz, Please find the attached file. thanks in advance if you find solution.. I am wasting everyday so much time for doing vlookups everyday. looking for simple automation Thnaks On Tuesday, July 29, 2014 1:45:48 PM UTC+5:30, Vabz wrote: > > Hi share sample file with data format.. > >

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

2014-07-29 Thread Vaibhav Joshi
Hi share sample file with data format.. Cheers!! On Mon, Jul 28, 2014 at 9:42 AM, venkateswara reddy < venkateswara.red...@gmail.com> wrote: > Hi Dear's, > > Please hlep me with Macros, > > I have problem with multiple sheets need to update corresponding status as > per the order number in mast

Re: $$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-10 Thread ashish koul
http://akoul.blogspot.com/search/label/Sending%20a%20Range%20as%20attachment%20in%20mail%20though%20Excel%20VBA try this if it helps On Mon, May 9, 2011 at 9:20 AM, sreekanth m wrote: > Dear All, > > I am attaching an Excel with some hypothetical data. > > Please help me to : > >- Take

RE: $$Excel-Macros$$ $$Excel Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-19 Thread Daniel
Hello, Use the following macro : Sub test1() [K21].FormatConditions(1).Delete With [K21:V130] .FormatConditions.Add xlCellValue, xlGreater, "=SI(K$20=""c"";$F21;$G21)" .FormatConditions(1).Font.ColorIndex = 2 .FormatConditions(1).Interior.ColorIndex = 1 .FormatConditio

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

2010-04-16 Thread Sundarvelan N
Hi Friends, Thanks, Thanks, Thanks, Thanks, Thanks, Thankyou very much one more request How to remove the page breaks both in portrait and landscape On Fri, Apr 16, 2010 at 12:59 PM, Kumar wrote: > Hi Sundarvelan, > > See if the below code helpful for your task: > > '

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

2010-04-16 Thread Kumar
Hi Sundarvelan, See if the below code helpful for your task: '=== ActiveSheet.PageSetup.RightHeader = "" ActiveSheet.PageSetup.CenterHeader = "" If WeekdayName(Weekday(Date)) = "Monday" Then ActiveSheet.PageSetup.LeftHeader = FormatDateTime(

RE: $$Excel-Macros$$ Excel-Macros : Help

2010-04-16 Thread Dave Bonallack
Hi, If I understand you correctly, the following line of code does what you ask, to the active cell. If Weekday(Date) = 2 Then ActiveCell = Date - 3 Else: ActiveCell = Date - 1 Regards - Dave. Date: Fri, 16 Apr 2010 10:36:13 +0530 Subject: $$Excel-Macros$$ Excel-Macros : Help Fro