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

$$Excel-Macros$$ Excel Macros Help

2014-07-27 Thread venkateswara reddy
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 master sheet. Worksheet 1 "Master" is a list of orfer numbers that gets updated several times daily (some order numbers are deleted and others are added

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

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

2011-05-09 Thread sreekanth m
Dear All, I am attaching an Excel with some hypothetical data. Please help me to : - Take out the data by filtering the Managers name and paste it in a New Work Book. - Sent it to the respective managers E-Mail ID. - All the above actions should get done in a button Click. Awaiting

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

2011-02-19 Thread Daniel
ons(1).Interior.ColorIndex = 1 .FormatConditions(1).StopIfTrue = True End With End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nuria Gimenez Envoyé : mercredi 16 février 2011 10:46 À : excel-macros@googlegroups.com Objet : $$Excel-Mac

$$Excel-Macros$$ $excel-macros$ help

2010-07-21 Thread preeti vora
Hi team i have one excel file there is 10 to 15 sheet different but i want to marge in one sheet is that possible to do??? -- Regards, Preeti Vora. -- -- Some important links for excel users: 1. Follow us on TWIT

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

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

2010-04-15 Thread Sundarvelan N
Hi Friends, Please complete this coding. Condition is if the current day is Monday then i need to have Privious Friday Date in the header else just previous day date. Please help me to complete my project Range("A1:IV65536").Select With ActiveSheet.PageSetup End With ActiveShe