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

$$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

$$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

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 rohan.j...@gmail.com wrote: Hi,

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

Dear All, I am presently updating a month PL column using links to a trial balance every month. So for the month of Jan, I will paste the trial balance and Jan PL 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

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 chandrashekarb@gmail.com To: excel-macros@googlegroups.com Sent: Thu, 23

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 dcolarde...@free.fr wrote: Hi, Have a look at the attached file. Deafault is current date and time. But, if you change the date with the

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 rajeshkainikk...@gmail.comwrote: 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

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 koul.ash...@gmail.com wrote: check the attachment On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts Wish you happy new year I have worksheet

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

Hi Send attachment Sent on my BlackBerry® from Vodafone -Original Message- From: Umar Abeer umarab...@googlemail.com Sender: excel-macros@googlegroups.com Date: Sun, 26 Dec 2010 10:56:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

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

17 ways to Optimize VBA Code for FASTER Macroshttp://www.excelitems.com/2010/12/optimize-vba-code-for-faster-macros.html Here is a summary of the article: 1. Analyze the Logic 2. Turn off ScreenUpdating 3. Turn off 'Automatic Calculations'