Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread respuzy
Hi VABZ not sure how I can use edate for this Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: VBA VABZ Sender: excel-macros@googlegroups.com Date: Sat, 22 Jun 2013 10:02:28 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: R

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread respuzy
I love your solution. Really cool formula. Bravo and thanks a lot. Its perfect. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: De Premor Sender: excel-macros@googlegroups.com Date: Sat, 22 Jun 2013 08:38:40 To: Reply-To: excel-macros@googlegroups.com Sub

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
Sounds good Vabz Half way there. What about the end time ? Where would that go ? On Friday, June 21, 2013 9:03:26 AM UTC-4, Vabz wrote: > > Hi > To run this macro, just make sure that you replace *Name_of_Macro* with > the name of the macro inside of your Excel workbook that you want to run.

Re: $$Excel-Macros$$ How to get the Month end date from a list of dates

2013-06-21 Thread VBA VABZ
try edate formula.. Thanks On Sat, Jun 22, 2013 at 1:13 AM, Hilary Lomotey wrote: > Hello Experts, > > In the attached sheet, i have a list of dates in col A and index number in > Col B. What i am trying to achieve is that in Sheet two, i have written a > formula to give me index number as at

$$Excel-Macros$$ Urgent Requirement

2013-06-21 Thread Gagan
Please respond to *ga...@hmgamerica.com* *Position: VMWare Admin* *​Location: ​* *Burbank, CA* *​ Duration: ​* *6+ month s​ * *​Description: ​* * * A highly motivated System Administrator with *8+ years of experience*should have the following skills:  Expert applied knowledge of Intel Opera

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread VBA VABZ
Hi To run this macro, just make sure that you replace *Name_of_Macro* with the name of the macro inside of your Excel workbook that you want to run. Also, replace *09:30:00* with the time that you want your macro to run. Private Sub Workbook_Open() 'Runs a macro at 9:30 AM Application.OnTime Time

$$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
I have various macros that perform different tasks daily. All of these have to be manually started and stopped at a certain time. That time is never the same as it has to be obviously initiated manually. I have read various examples on the web (for starting only), but have had no success so fa

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread Seba
Actually no, because I want the copied values in a list w/o blanks. regards seba Dne petek, 21. junij 2013 13:15:16 UTC+2 je oseba Vabz napisala: > > Superb!! > > I assume you need to increment target by 5 too, coz u r copying 5 rows. > > Thanks > > > On Fri, Jun 21, 2013 at 4:38 PM, Seba > > wr

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread VBA VABZ
Superb!! I assume you need to increment target by 5 too, coz u r copying 5 rows. Thanks On Fri, Jun 21, 2013 at 4:38 PM, Seba wrote: > Hi, > > thank you for your help. > > This is the final version of my code: > > Sub copy_transpose_chunks() > > Dim count, target, coordS, coordF As Integer >

Re: $$Excel-Macros$$ Need code for extracting report from CMS Avaya

2013-06-21 Thread VBA VABZ
hey FYI http://fracta.net/fracta/index.php/forum/2-excel-vba-forum/15-excel-vba-macro-to-automate-avaya-cms-supervisor-reports Thanks On Fri, Jun 21, 2013 at 4:13 PM, Arundatti M wrote: > Hi Team, > > I need help in extracting report from CMS Avaya CRM application to excel. > If there is any

Re: $$Excel-Macros$$ macro for parsing a column by 5 rows

2013-06-21 Thread Seba
Hi, thank you for your help. This is the final version of my code: Sub copy_transpose_chunks() Dim count, target, coordS, coordF As Integer coordS = 1 coordF = 5 target = 1 For count = 1 To 15 Range("A" & coordS, "A" & coordF).Select Selection.Copy Range("C" &

$$Excel-Macros$$ Need code for extracting report from CMS Avaya

2013-06-21 Thread Arundatti M
Hi Team, I need help in extracting report from CMS Avaya CRM application to excel. If there is any scripts, please help experts. Any script which links cms historical reports to excel? Regards, Arundatti -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

2013-06-21 Thread Prabhu Pinky
hi priti..this is really nice work...if you dont mind..can you gimme training in macro..pls..i can follow your classes as you teach me... On Jun 21, 2013 11:48 AM, "priti verma" wrote: > Yes you can do it with macro, > See pfa > > > > On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav > wrote: > >