Re: $$Excel-Macros$$ Fine tuning a code to insert rows

change this see if that helps ActiveCell.Resize(numrows-1).Insert On Wed, Feb 23, 2011 at 9:06 AM, petee wrote: > I have a spreadsheet where I need to copy a row and have EXCEL > automatically copy new rows based on a number inputted by the user > (less 1). > > I've used a code which was previo

Re: $$Excel-Macros$$ Macro Help - Please!

HI Kamal, Please see the attachment if it helps, Regards ROHAN On Tue, Feb 22, 2011 at 6:33 PM, NOORAIN ANSARI wrote: > Dear Kamal, > > Please see attached sheet..if it help.. > > On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote: > >> Hello Excel Gurus, >> >> Need small favour from experts

$$Excel-Macros$$ Fine tuning a code to insert rows

I have a spreadsheet where I need to copy a row and have EXCEL automatically copy new rows based on a number inputted by the user (less 1). I've used a code which was previously posted that creates a box asking how many rows I need. This works fine but the problem is that people often input one ro

Re: $$Excel-Macros$$ Wedding Planner

Dear Ayush, Its A good surprise early in the morning. A Nice Way to Monitor the expenses. I guess it will be useful in my wedding planning. Regards, Aakash. --- On Wed, 2/23/11, Ayush wrote: From: Ayush Subject: $$Excel-Macros$$ Wedding Planner To: excel-macros@googlegroups.com Date: Wedn

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

1) Excel Simplified On 23 February 2011 11:47, Harmeet Singh wrote: > *EXCEL in EXCEL* > > > > > Warm Regards, > > Harmeet Singh > IT Analyst > McKinsey & Company > http://www.facebook.com/Harmeeet > > > > On Wed, Feb 23, 2011 at 4:59 AM, Ayush Jain wrote: > >> Dear members, >> >> I am too ex

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

> 2. > > On Wed, Feb 23, 2011 at 4:59 AM, Ayush Jain wrote: > >> Dear members, >> >> I am too excited to share that discussexcel.com website development is in >> good progress and we are ready to launch the website on 4th Anniversary of >> our Google group. i.e. 16th -17th March. >> >> In the m

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

*EXCEL in EXCEL* Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Wed, Feb 23, 2011 at 4:59 AM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to l

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

I go for 1) building XL-lence - Andy On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th

Re: $$Excel-Macros$$ Creating directories

I Hope this will help. Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Wed, Feb 23, 2011 at 4:03 PM, ashish koul wrote: > you want to save blank excel files in the path or what > > > On Wed, Feb 23, 2011 at 1:13 AM, Hems wrote: >

Re: $$Excel-Macros$$ Wedding Planner

Haha.. Gr8 one as usual Ayush... Wish I had one when I got married... ;) cheers!!! On Wed, Feb 23, 2011 at 8:46 AM, Ayush wrote: > The most expensive wedding ever was that of Vanisha Mittal, daughter of > world’s 8th richest person Lakshmi Mittal, to investment banker Amit Bhatia > in 2004. It c

Re: $$Excel-Macros$$ Creating directories

you want to save blank excel files in the path or what On Wed, Feb 23, 2011 at 1:13 AM, Hems wrote: > Hello Experts > > Please find attached excel. I want to create directory, sub directory and > file name as per excel columns and save the file as per the file name. > > Kindly let me if it is po

Re: $$Excel-Macros$$ Insert Row after Change in Value in a Selection

try this one Sub () Dim i, j, k, z As Long k = Sheets(1).Range("a65356").End(xlUp).Row For i = k To 2 Step -1 If Sheets(1).Cells(i, 1).Text <> Sheets(1).Cells(i - 1, 1).Text Then Range("a" & i).Select Selection.EntireRow.Insert End If Next i Cells(1, 1).Select

Re: $$Excel-Macros$$ Insert Row after Change in Value in a Selection

Sub () Dim i, j, k, z As Long z = 1 ' change column name here if u want to x = "a" Range(x & "65356").Select Selection.End(xlUp).Select k = ActiveCell.Row For i = k To 1 Step -1 If LCase(Range(x & i).Text) <> LCase(Range(x & i - 1).Text) Then Range(x & i).Select

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

"Excellence in Excel" On 2/23/2011 12:59 AM, Ayush Jain wrote: Dear members, I am too excited to share that discussexcel.com website development is in good progress and we are ready to launch the website on 4th Anniversary of our Google group. i.e. 16th -17th March.

Re: $$Excel-Macros$$ How to Edit a Macro to Insert the Copied Spreadsheet at Last Blank Spreadsheet in the Workbook

Sheets("a").Copy After:=Sheets(Worksheets.Count) or ActiveSheet.Copy After:=Sheets(Worksheets.Count) On Wed, Feb 23, 2011 at 3:13 AM, wrote: > I just created a macro to copy and insert a spreadsheet. Here is the code: > > Sub CopySpreadSheet() > ' > ' CopySpreadSheet Macro > ' Copy a spre

$$Excel-Macros$$ Insert Row after Change in Value in a Selection

I have a range where I want to insert a row when the data changes. Example Column B xyz xyz xyz yyz yyz yyz yyz yyz yyz zyx zyx zyx zyx zyx zyx I want to insert a row between xyz and yyz. Also between yyz and zyx. I need am trying to find / write it using VBA. Any help would be greatley appre

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Let Us Excel! On Feb 22, 2011 9:59am, Ayush Jain wrote: Dear members, I am too excited to share that discussexcel.com website development is in good progress and we are ready to launch the website on 4th Anniversary of our Google group. ie 16th -17th March. In the meantime, Can you

$$Excel-Macros$$ How to Edit a Macro to Insert the Copied Spreadsheet at Last Blank Spreadsheet in the Workbook

I just created a macro to copy and insert a spreadsheet. Here is the code: Sub CopySpreadSheet() ' ' CopySpreadSheet Macro ' Copy a spreadsheet and insert it into a new spreadskeet ' ' Keyboard Shortcut: Ctrl+s ' Sheets("Apr 03 - Apr 09, 2011").Select Sheets("Apr 03 - Apr 09, 2011").Copy Before:=

$$Excel-Macros$$ Creating directories

Hello Experts Please find attached excel. I want to create directory, sub directory and file name as per excel columns and save the file as per the file name. Kindly let me if it is possible with the help of excel macros. Thanks in advance. Cheers... -- -

Re: $$Excel-Macros$$ Need Help

Hi find attach, check whether it helps as per my understanding NA count should be 0 On Tue, Feb 22, 2011 at 8:59 PM, Prathima R wrote: > My colleague has this equation set up to count the number of cells within > a range that are three standard deviations higher than the mean. But when he > ha

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

How about Excel in Excel? On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th March. > >

Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Achieve excellence in excel !!! On Tue, Feb 22, 2011 at 9:59 PM, Ayush Jain wrote: > Dear members, > > I am too excited to share that discussexcel.com website development is in > good progress and we are ready to launch the website on 4th Anniversary of > our Google group. i.e. 16th -17th March.

Re: $$Excel-Macros$$ Macro DataMatchError

can you please point me where in the code I have to put this new condition. I am new to VB. I will appreciate if you can modify my code. Regards, san On Mon, Feb 21, 2011 at 11:12 PM, rakesh kumar wrote: > *Just put one more condition for if length search term = length found..* > > > On Tue, F

$$Excel-Macros$$ Re: Need help on VBA code

Can you send a sample file? On Feb 22, 9:00 am, vinu wrote: > Hello Team, > > I need code on the below scenario: > > I have data dump which contains 15 columns of data. I need code to > perform the below steps: > Col A(Region), Col D(country), Col J(comments).  For eg I filter the > Col A (Region

Re: $$Excel-Macros$$ Need VBA help to delete multiple Columns & Filter

try this Sub A() Dim I, J, K As Long If Sheets(1).FilterMode Then Sheets(1).ShowAllData End If Sheets(1).Range("a1:ax" & Sheets(1).Range("a1").End(xlDown).Row).AutoFilter Field:=1, Criteria1:="AP" Sheets(1).Range("a1:ax" & Sheets(1).Range("a1").End(xlDown).Row).AutoFilter Field:=5, Criteria1:="<10"

Re: $$Excel-Macros$$ Dear Gurus please revisit this thread and help me out

Sorry, maybe my response didn't go anywhere... Have you tried stepping through the code and see where it fails? Can you send me some sample files? Paul From: Dave To: MS EXCEL AND VBA MACROS Sent: Tue, February 22, 2011 12:52:54 PM Subject: $$Excel-Macros$$

$$Excel-Macros$$ 22 days left - Launch of discussexcel.com

Dear members, I am too excited to share that discussexcel.com website development is in good progress and we are ready to launch the website on 4th Anniversary of our Google group. i.e. 16th -17th March. In the meantime, Can you advise a good tagline, punchline for website. My thoughts are : 1)

$$Excel-Macros$$ Dear Gurus please revisit this thread and help me out

I have a post as below Paul Schreiner has been helping me out on it. http://groups.google.com/group/excel-macros/browse_thread/thread/9565d70088ca5677/524288e52789b113#524288e52789b113 I inserted the macro as a module in my spreadsheet . I had to insert Dim RecCnt Dim MatNo as I was getting "

$$Excel-Macros$$ Value Required based on status updation in column

In My excel database there are Huge database availble for this eg I have given the unique current status (which can be repeted many times ) what I want is when ever Below status updated in "Current status " Column Rest colums should give me the value based on status provided In that This the just

RE: $$Excel-Macros$$ Printing Query using a excel sheet

Can you explain ? is there an error message ? what happens ? Daiel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Rajesh Shah Envoyé : mardi 22 février 2011 12:41 À : excel-macros@googlegroups.com Objet : Re: $$Excel-Macros$$ Printing Query using a e

Re: $$Excel-Macros$$ how to lock selected cell or rows

select whole sheet right click - > format-> protection uncheck locked use this code Sub lockcells() ActiveSheet.Unprotect Password:="ashish" ActiveCell.Locked = True ActiveSheet.Protect Password:="ashish" End Sub you can uprotect the sheet then select the cell right clickit On Tue, Feb 22,

Re: $$Excel-Macros$$ Lookup a name and return a value

hi marcus see the attachment i tried to solve it with formulae let me know if you require the macro for it. On Tue, Feb 22, 2011 at 2:44 PM, Marcus wrote: > Hi > Can anyone assist me, fixing this macro? I want it to lookup each name > in Sheet1, find it in Sheet2 and return the ID number to Shee

Re: $$Excel-Macros$$ Printing Query using a excel sheet

Hello This doesnt work Rajesh On 21 February 2011 21:29, Daniel wrote: > Hello, > > Try : > > With ActiveSheet.PageSetup >.CenterHeader = "original for the buyer" >ActiveSheet.PrintOut >.CenterHeader = "Duplicate for the seller" >ActiveSheet.PrintOut >.CenterHeader = "Transpo

$$Excel-Macros$$ Need VBA help to delete multiple Columns & Filter

Hello Team, I need help on the below scenario. 1. I have a 50 columns of data, in this I need delete multiple entire column("C:F", "K", "AA:AD") how do I do this. I have listed all the column heading in column which needs to be deleted - need code for this. 2. I need to delete few rows based

$$Excel-Macros$$ Need help on VBA code

Hello Team, I need code on the below scenario: I have data dump which contains 15 columns of data. I need code to perform the below steps: Col A(Region), Col D(country), Col J(comments). For eg I filter the Col A (Region) by "ANZ". Then column D(states) contains like PAK, ENG, AU, NZ etc.,(In t

Re: $$Excel-Macros$$ Help, please, with debugging a function

Dave, I use a version of this code to examine the "white space" in a file to see if it is empty- if empty, I delete that range, and reduce file size. So if the code locates a cell that is populated either with a number or formula, it moves the cell pointer to that cell so I can determine if that ce

$$Excel-Macros$$ Need Help

My colleague has this equation set up to count the number of cells within a range that are three standard deviations higher than the mean. But when he has N/As in the set, it's returning those in the count as well. Do you have any ideas on how to adjust the formula to only count straight numeric v

Re: $$Excel-Macros$$Help me with positioning of graphics MACRO.

Thanks Daniel for helping me solve my problem. Hector 2011/2/22 Daniel > To place the top left part of the chart in , say, D15 : > > > > ActiveChart.Parent.Top = Range("D15").Top > > ActiveChart.Parent.Left = Range("D15").Left > > > > HTH > > Daniel > > > > *De :* excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Printing Query using a excel sheet

Thanks for the reply I shall try the macro and revert back Regards Rajesh On 21 February 2011 21:29, Daniel wrote: > Hello, > > Try : > > With ActiveSheet.PageSetup >.CenterHeader = "original for the buyer" >ActiveSheet.PrintOut >.CenterHeader = "Duplicate for the seller" >Active

Re: $$Excel-Macros$$ Printing Query using a excel sheet

Hi Friends, Please help me with a MIS guy. We are looking for someone with 1 - 2 yrs of experience as MIS Executive. Salary range - 12- 15 k. Please refer someone. Location - Pushp Vihar. Please mail your cv at chitra.gan...@jraca.com On Tue, Feb 22, 2011 at 2:31 PM, Rajesh Shah wrote: > Hell

$$Excel-Macros$$ Help on Macro Code

Hi Experts, Please help on the following code, where it is wrong and please correct Option Explicit Sub Create_TOC() Dim wbBook As Workbook Dim wsActive As Worksheet Dim wsSheet As Worksheet Dim InRow As Long Dim InPages As Long Dim InCount As Long Set wbBook - ActiveWorkbook With Application .

Re: $$Excel-Macros$$ how i convert pdf file to Excel using macro.

>From the Adobe Pdf File>Export >xml open excel and import that xml and done On Sat, Feb 19, 2011 at 12:47 PM, rashid memon wrote: > Dear Experts, > > i want to convert PDF file to Excel so plz provide me macro > > file is attached... > > > Looking forward to receive your kind atten

Re: $$Excel-Macros$$ Printing Query using a excel sheet

Hi Rajesh Please follow below points. 1. Copy main sheet. 2. Paste six times and rename as Original for Buyers, Duplicate for Seller, Triplicate 3. When you made invoice select all copies and transact in original copy it will changed in all copies 4. Don't alter in main he

RE: $$Excel-Macros$$ I need to extract data from a sheet to another in the same workbook - please help.

Have a look at the following file (without "Others" sheet) : http://www.filedropper.com/110221_1 The problem is to know which enterprise owns a separate sheet and which one doesn't. If this is not somewhere in a sheet, each time there will be a new enterprise, the code will need to be modified. To

RE: $$Excel-Macros$$Help me with positioning of graphics MACRO.

To place the top left part of the chart in , say, D15 : ActiveChart.Parent.Top = Range("D15").Top ActiveChart.Parent.Left = Range("D15").Left HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Hector Ruiz Envoyé : lundi 21 février 2011 2

Re: $$Excel-Macros$$ Macro Help - Please!

Dear Kamal, Please see attached sheet..if it help.. On Mon, Feb 21, 2011 at 11:25 PM, kamal shah wrote: > Hello Excel Gurus, > > Need small favour from experts, > I have two columns in Excel, I need a macro, where if Column A contains > value as "Step", column B should populate "Complete". > If

Re: $$Excel-Macros$$ how to lock selected cell or rows

thanks a lot ashish ji, ashish ji, one question there is no way or macro if we just selected the cells and run that or apply that macro (or formula) the cell turn locked for the specific field thanks Rohan On Tue, Feb 22, 2011 at 1:51 PM, ashish koul wrote: > check the link > > > http://supp

$$Excel-Macros$$ Lookup a name and return a value

Hi Can anyone assist me, fixing this macro? I want it to lookup each name in Sheet1, find it in Sheet2 and return the ID number to Sheet1. The challenge is that the name lookup shouldn't be exact, i.e. "lisa flisa" equals "lisa". *Sheet1* Column C Column F NameID kalle balle li

$$Excel-Macros$$ Printing Query using a excel sheet

Hello Members Good Day! I have a excel sheet (invoice copy) which i want to print 7 copies I have a problem with the header that i want to print. The header is different for all the 7 pages while all the other content remains the same. the header of the invoice in the first page to be printed shou

FW: $$Excel-Macros$$ Help needed to Consolidate the data MM/Year

Hi, I have a consolidate list of the 7 digit no I wants make all the 7 digit no to 16 digit like this Actual DATA I wants Make Like this but in place of 0 I want only space 1234567 01234567 Please advice any formula for this. Regards Kailash

Re: $$Excel-Macros$$ Macro DataMatchError

*Just put one more condition for if length search term = length found..* On Tue, Feb 22, 2011 at 9:05 AM, San Pat wrote: > Hi > > I have a macro with a command button "ClosePosition" in the Sheet > "OpenPosition" to close my OpenPosition. See the attached file. > > It is working fine when I en

Re: $$Excel-Macros$$ I need to extract data from a sheet to another in the same workbook - please help.

Hey Daniel, There are around 11 no. of enterprises that own a particular/ individual sheet. for this do I need to create a different module for all the 11 no. of enterprises? As far as the"others" sheet is concerned it would contain around more than 80-90 enterprises, other than these 11 enterprise

Re: $$Excel-Macros$$ how to lock selected cell or rows

check the link http://support.microsoft.com/kb/214081 vba code it will lock the cells in a1 to a 60 Sub lockcells() Sheets(1).Protect Password:="ashish" Sheets(1).Unprotect Password:="ashish" Sheets(1).Cells.Select Selection.Locked = False Sheets(1).Range("a1:a60").Locked = True Sheets(1).Pro

Re: FW: $$Excel-Macros$$ Help needed to Consolidate the data MM/Year

REPT(" ",16-LEN(A1))&A1 On Tue, Feb 22, 2011 at 1:05 PM, Mishra, Kailash (GE Capital, Non-GE) < kailash.mis...@ge.com> wrote: > Hi, > > > > I have a consolidate list of the 7 digit no I wants make all the 7 digit no > to 16 digit like this > > > > *Actual DATA I wants Make Like this but in