RE: $$Excel-Macros$$ Learning Macro

U CAN JOIN THIS ONLINE COURSE FOR LEARNING MACROS IN DETAIL, ITS AWESOME GO AND HAVE A LOOK... http://www.masterofmacros.com/ Date: Thu, 9 Dec 2010 11:01:47 +0530 Subject: $$Excel-Macros$$ Learning Macro From: balbirku...@sify.com To: excel-macros@googlegroups.com Dear Friends, I dont

$$Excel-Macros$$ Re: Learning Macro

Hi, If you do a google search for the term MS Excel VBA tutorials you will find a lot of websites for that. The best way would be to take a task that you do repeatedly and start creating a macro for it. Learning from one project you will eventually learn how to automate a lot of tasks. In case yo

$$Excel-Macros$$ Learning Macro

Dear Friends, I dont know how create macros in excel and how and what codes are used for its creation. But, I am interested in Knowing them. Please suggest me from where i could learn. With Thanks & Regards -- Balbir Kumar --

Re: $$Excel-Macros$$ cumulative sum in pivot table

check the attachment see if it helps . Kantilal Badale On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra wrote: > Hi Group, > > I have one pivot table. In that I want to show the cumulative sum. > e.g. > Qtr1 sale:- 10 units > Qtr2 sale:- 20 units > Qtr3 sale:- 10 units > Qtr4 sale:- 30 unit

$$Excel-Macros$$ Need to separate/parse directory path and filename using Excel 2007 ...

Hi, I needed to override the Data Import Wizard so I have created a macro which functions perfectly. However, the filename is hard coded in the macro and I need to run the macro on different files and select each file individually. After searching through the Mr Excel Forum archives, I learned abo

Re: $$Excel-Macros$$ cumulative sum in pivot table

Hi Alisha, It would be really helpful if you can share a dump file. Regards, Deepak Rai On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra wrote: > Hi Group, > > I have one pivot table. In that I want to show the cumulative sum. > e.g. > Qtr1 sale:- 10 units > Qtr2 sale:- 20 units > Qtr3 sale:-

Re: $$Excel-Macros$$ Need help on dynamic list

Hi, Please find the attached solution. In sheet one I have two validation lists, which is taking data from Sheet2. Sheet2 has named ranges. Hope this will help you. With the help of Named Range and Indirect formula you can do this very easily. Regards, Deepak Rai On Wed, Dec 8, 2010 at 7:33 PM

$$Excel-Macros$$ how to protect & unprotect the sheet with same button

Hi Experts i am want to give an edit button in my worksheet, for protecting & unprotecting the sheet how can i use it. I try this code but not working,pls correct it Sub Macro6() If ActiveSheet.Protect = True Then ActiveSheet.Unprotect Else If ActiveSheet.Protect = False Then ActiveSheet.Protect

RE: $$Excel-Macros$$ Error in Macro Code

Hi Vebhav, Is there any data after the range you mention? For example, if today's data is Range A1:B330, is there any data in cells A331:B65000? If the cells below the data is blank, then we should be able to help you. Also, the other highlighted range, H2:H341; how does that relate to the firs

RE: $$Excel-Macros$$ Select the next cell when the page open

Hello, Here is an example if the setting can be done using row 1 : Private Sub Worksheet_Activate() Dim lastcolumn lastcolumn = Cells(1, Columns.Count).End(xlToLeft).Offset(, 1).Column Cells(1, lastcolumn).Select End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

You are welcome Sharat. Best Regards, DILIPandey On 12/8/10, Sharath Sambrani wrote: > Fantastic!!! > > Thanks a ton Dilip! > > Sharath > > -- Forwarded message -- > From: Dilip Pandey > Date: Wed, Dec 8, 2010 at 8:43 PM > Subject: Re: $$Excel-Macros$$ Need help on Excel Dynamic

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Hi Sharath, Please check the attached file which has the resolution as per your requirements. :) Best Regards, DILIPandey On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani < sharath.c.sambr...@gmail.com> wrote: > Hi, > > I have two columns A and B. > > column A contains list of tasks and column

$$Excel-Macros$$ Need help on Excel Dynamic List

Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belon

$$Excel-Macros$$ Need help on dynamic list

Hi, I have two columns A and B. column A contains list of tasks and column B contains sub-tasks against each primary task. i would like to have two drop down cells in column C and D. whenever i select an option in the dropdown in cell C1, the list in D1 should show only the sub-tasks that belon

Re: $$Excel-Macros$$ **URGENT**Help Required

Hi Ashish, Any updates?? On Mon, Dec 6, 2010 at 3:04 PM, girish kumar wrote: > Hi Ashish, > > i want one small info again in provided macro > > if i hide the Master sheet macro is not running, is there any way to hide > the Master sheet and run the macro successfully? > > thanks in advance > > R

Re: $$Excel-Macros$$ if formula help

Thanks CG,Andril & ashish On Wed, Dec 8, 2010 at 2:13 PM, ashish koul wrote: > try this you can avoid using multiple ifs with this > > > > > On Wed, Dec 8, 2010 at 11:48 AM, C.G.Kumar wrote: > >> Solved & file Attached. Hope it serves the purpose. >> >> Regards, >> >> C.G.Kumar >> >> >> >> On W

Re: $$Excel-Macros$$ Fwd: insert a blank row

Dear Sir I dont know much about macros hence pls send in the given file On Wed, Dec 8, 2010 at 1:58 PM, ashish koul wrote: > try this see if it helps > > Sub rowinsertcola() > > > Dim i, j, k, z, h As Long > j = 1 > z = 1 > > > Range("a65356").Select > Selection.End(xlUp).Select > > k = Active

Re: $$Excel-Macros$$ Error in Macro Code

I want the highlighed code to be in a standard format. The data which i get daily it keep varies and i get struck at range(A1:B334). when i recorded this macro at that time it was A1 :B334 and next day it changed to A1:B321, Next day i ran the macro...not able to execute.i hope you understood my q

Re: $$Excel-Macros$$ Fwd: insert a blank row

try this see if it helps Sub rowinsertcola() Dim i, j, k, z, h As Long j = 1 z = 1 Range("a65356").Select Selection.End(xlUp).Select k = ActiveCell.Row For i = 5 To k + z Step 1 If (i Mod j = 0) Then ActiveSheet.Cells(i + z, 1).Select Selection.EntireRow.Insert z =

Re: $$Excel-Macros$$ Hi - Number need to fill randomly

Pls find the attached... Regards, Manoj Kumar On Wed, Dec 8, 2010 at 12:34 PM, Manjunath C wrote: > Hi Team, > > I need to fill the highlighted(brown) coloumn with numbers 1 to 90 randomly > by clicking the button "Press" each time. > Finally we need the data as highlighted in yellow. > > Thank

$$Excel-Macros$$ insert a blank row

Dear all can any one help me in inserting black rows after line no.5 like 5 then blank row then 6 and then again blank row and again regards LKModi -- -- Some important links for excel users: 1. Follow us on TWIT

$$Excel-Macros$$ Reqd : Add in to convert Number to text in Excel 2007

Hi Manjunath, Try this:http://openexcel.googlecode.com/files/OPEN_XL.zip Thanks & Regards Ashish Jain (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com