$$Excel-Macros$$ 17 ways to Optimize VBA Code for FASTER Macros

17 ways to Optimize VBA Code for FASTER Macros Here is a summary of the article: 1. Analyze the Logic 2. Turn off ScreenUpdating 3. Turn off 'Automatic Calculations'

Re: $$Excel-Macros$$ Re: Automation of copy paste exercise

Hi Send attachment Sent on my BlackBerry® from Vodafone -Original Message- From: Umar Abeer Sender: excel-macros@googlegroups.com Date: Sun, 26 Dec 2010 10:56:20 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Automation of copy paste exercise Dear All, I a

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi Ashish Thank u very much, for ur fast & perfect answer Regards Rajesh Kainikkara On 12/26/10, ashish koul wrote: > check the attachment > On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R > wrote: > >> Hi experts >> >> Wish you happy new year >> >> I have worksheet like this >> Column A - Date >>

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R wrote: > Hi experts > > Wish you happy new year > > I have worksheet like this > Column A - Date > Column B - Amt > Column C - Name of Month > Column D - For highest value of each month > Column E - For lowest value of each month > P

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

Hi Daniel I really appreciate your cooperation for this problem. Special thanx to you Regards, Deepak Rawat On Fri, Dec 24, 2010 at 7:07 PM, Daniel wrote: > Hi, > > Have a look at the attached file. Deafault is current date and time. But, > if you change the date with the calendar control, yo

Re: $$Excel-Macros$$ Re: Lock the Object

simply select E12:J22 cells lock them then protect sheet using password so nobody can unprotect it. see the attached file n let me know if it works for u. From: Chandra Shekar To: excel-macros@googlegroups.com Sent: Thu, 23 December, 2010 3:48:40 PM Subject:

Re: $$Excel-Macros$$ excel-macros : Get Agents Name under Team Leader

Hi Rohan, Thanks for your reply, but i dont want to edit my original excel file. I need to get the agents name under corresponding TL names like wise TL names under manager name. Thanks, Sundarvelan 9600160150 On Fri, Dec 24, 2010 at 3:43 PM, Rohan Young wrote: > Hi, > > Please find the solved

$$Excel-Macros$$ Re: Automation of copy paste exercise

Dear All, I am presently updating a month P&L column using links to a trial balance every month. So for the month of Jan, I will paste the trial balance and Jan P&L will populate itself. For the month of Feb, I will copy the links in the Jan column in the next column and will change Jan column to

$$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Hi experts Wish you happy new year I have worksheet like this Column A - Date Column B - Amt Column C - Name of Month Column D - For highest value of each month Column E - For lowest value of each month Pls check the attached file & tell me what is the formula for finding the highest & lowest val

$$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

Hi, I'm trying to select one range at a time for each individual column within a single worksheet. I have range data in approximately 150 columns on the worksheet that I would like to sort individually (ascending order), then cut, and finally paste into the last row of Column A. For example, if

RE: $$Excel-Macros$$ Regarding Code

Hi, Use a unused column to put your items (here, I use column G) : Selection.AutoFilter Set rg = [G1].Resize(Application.CountA([G:G])) arr = Application.Transpose(rg) ActiveSheet.Range("$A$1:$E$500").AutoFilter Field:=2, Criteria1:=arr, Operator:=xlFilterValues Rows("2:2").Select Range(S