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

Hi, can someone please advise how to parse a column in excel, so that every 5 rows would be a selection, which I can then copy and further manipulate? Thank you. Kind regards, Seba -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

Re: $$Excel-Macros$$ Useful VBA/Excel Manual deletion of row/data

Hi Manjunath, If I am not wrong...as per your requirement you just need header then why you need macro and all...just copy and paste *Thanks Regards,* *Santy* On Wed, Jun 19, 2013 at 12:54 PM, VBA VABZ v...@vabs.in wrote: what is criterion for deletion of row or every time u just want to

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

Hi, Use this code.. Sub Select_Row() Range(ActiveCell.Rows, ActiveCell.Offset(4, 0)).EntireRow.Select End Sub This will select 5 rows from active cell. Thanks On Wed, Jun 19, 2013 at 12:48 PM, Seba sebastjan.hri...@gmail.com wrote: Hi, can someone please advise how to parse a column in

RE: $$Excel-Macros$$ Useful VBA/Excel Manual deletion of row/data

Dear Experts, Thanks , it was a sample data which was provided me... Usually there will be more 500 to 1000 rows and every month I need to delete Is there any macros automatically data should get delete at end of the month From: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Useful VBA/Excel Manual deletion of row/data

Dear Experts, Thanks it's working fine. Is there any other option like beginning of the month/end of the month, when I open the excel it should get deleted automatically without im running manually Is it possible with the help of macro Thanks Manjunath From: excel-macros@googlegroups.com

$$Excel-Macros$$ Macro Require.

Dear All, find the excel sheeti need macro for the same Regards, Prafull -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

Re: $$Excel-Macros$$ Macro Require.

i've attached 2 method, 1st using UDF, 2nd using Excel Formula, try it Rgds, [dp] Pada 19/06/2013 18:34, Prafull Jadhav menulis: Dear All, find the excel sheeti need macro for the same Regards, Prafull -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Need a Fastest way

can anyone suggest a faster way to know which cells are highlighted in a Range ? suppose i have data of 1 lac cell and i have some cells highlighted , i want to know address of that cells. -- Regards Rajan verma +91 9158998701 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Need a Fastest way

Hi Highlighted means cells filled with specific color or selected cells. Thanks On Wed, Jun 19, 2013 at 5:58 PM, rajan verma rajanverma1...@gmail.comwrote: can anyone suggest a faster way to know which cells are highlighted in a Range ? suppose i have data of 1 lac cell and i have some

Re: $$Excel-Macros$$ Merging List

Hi, Thanks its working fine :) Regards, Chandra On Wed, Jun 19, 2013 at 6:08 PM, De Premor d...@premor.net wrote: Create a new Defined Name for in sheet List range A2:B6, then put that name to Listbox Property in ListFillRange, then change ColumnCount to 2 You can adjust gap between Name

$$Excel-Macros$$ Extract Unique Values with VBA

Hello Experts I have attached a file where i need to extract unique values based on a criteria with VBA. I have demonstrated it with excel formula. i need assistance with a vba solution. kindly assist with code. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Extract Unique Values with VBA

Excellent. Its perfect. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: VBA VABZ v...@vabs.in Date: Wed, 19 Jun 2013 23:42:22 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Cc: resp...@gmail.com Subject: Re: $$Excel-Macros$$ Extract Unique

$$Excel-Macros$$ Attrition Tracker

Hi Group, Please share attrition tracker which calculates the attrition % on monthly,quaterly,halfyearly and yearly level -- Regards Santosh santoshkumar.subu...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official

$$Excel-Macros$$ Re: Need a Fastest way

How you highlighted cells in a range? On Wednesday, 19 June 2013 17:58:39 UTC+5:30, Rajan_Verma wrote: can anyone suggest a faster way to know which cells are highlighted in a Range ? suppose i have data of 1 lac cell and i have some cells highlighted , i want to know address of that