Re: $$Excel-Macros$$ Issue with Selection as collection

Dear Markkim, your code is correct, but please use it within procedure like... Sub selection_area() Dim rcell As Range For Each rcell In Selection rcell.Value = 1 Next End Sub -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http

$$Excel-Macros$$ Issue with Selection as collection

Hi all Well, I am not sure what's going on here.. I selected few cells then run the following code (for test purpose) dim rcell as range for each rcell in selection rcell.value = 1 Next Then I gets complie error message: For Each may only iterate over a collection object or an array ..

Re: $$Excel-Macros$$ Automation

Dear Shanshank, Please try below link http://spreadsheets.about.com/od/iffunctions/ss/Excel-2007-Nested-If-Function-Step-By-Step-Tutorial.htm http://spreadsheets.about.com/od/tipsandfaqs/qt/nested_if.htm On Thu, Sep 22, 2011 at 10:41 AM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote:

Re: $$Excel-Macros$$ Help.

Dear Vijay, Please check below link https://www.odesk.com/.../*Global*-*Reporting* -Analyst-with-strong-background -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Using VBA to switch between calculated fields

Hi Clint Can you attach the sample file On Wed, Sep 21, 2011 at 11:08 PM, Clint wrote: > This one has been driving me crazy. VBA seems to have a problem > removing calculated fields. See code below. > > > Sub Value_Click() > >'' >Application.ScreenUpdating = False >Application.Calc

$$Excel-Macros$$ Export Data

Hi Group I have a spread sheet which has 3 TABS and the last tab is saved with the required information and i need a VBA code for exporting only the TAB named as "Details" to be exported on my desktop with xls format and file which has to be saved should be named as "Details - Present Date( DD-MM-

Re: $$Excel-Macros$$ Automation

Hello Noorain, Can u suggest me any tips or tricks for nesting From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, 21 September 2011 6:07 PM Subject: Re: $$Excel-Macros$$ Automation Most welcome Shashank On Wed, Sep 21, 2011 at 5:06

Re: $$Excel-Macros$$ Automation

Thank you too Viper!! From: §»VIPER«§ To: excel-macros@googlegroups.com Sent: Wednesday, 21 September 2011 4:52 PM Subject: Re: $$Excel-Macros$$ Automation hi this one would help pfa -- Great day, viper On Wed, Sep 21, 2011 at 3:40 PM, shashank bhosle

$$Excel-Macros$$ JOB

*Experience:* 2 - 5 Years *Location:* Noida *Compensation:* Rupees 2,25,000 - 3,00,000 *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization *Industry Type:* Legal *Role:* Process Flow Analyst *Functional Area:* ITES/BPO/KPO, Customer Service, Ops. *Post

$$Excel-Macros$$ Using VBA to switch between calculated fields

This one has been driving me crazy. VBA seems to have a problem removing calculated fields. See code below. Sub Value_Click() '' Application.ScreenUpdating = False Application.Calculation = xlManual ' Dim PF As PivotField Dim pfNew As PivotField Dim Field As String

Re: $$Excel-Macros$$ Fwd: Macro to open file from a location and consolidate data (Please dont consider this as a Duplicate post)

Hi Ashish THanks for the macro. As I said my MS Office does not work at home, I will try this at office and let you know the results. I am very grateful to you for lending me an helping hand in such situation. THanks once again, Subramanian V On Wed, Sep 21, 2011 at 6:05 AM, ashish koul wrote

Re: $$Excel-Macros$$ Need help on String Matching

You could use a combination of Haseeb's formula and this array formula =INDEX(Sheet1!$A:$A,MIN(IFERROR(MATCH(RIGHT(A2,ABS(LEN(A2)+1-ROW(INDEX($A:$A,1):INDEX($A:$A,LEN(A2)&"*",Sheet1!$A:$A,0),""))) The trick would be to identify *when* you would use either... Sam Mathai Chacko (GL) On Wed, S

Re: $$Excel-Macros$$ Need help on String Matching

*Dear friend, =VLOOKUP("*"&A1&"*",Sheet1!A:A,1,0) please help me after vlookup"*",&a1&"*" Thanks with Mothilal * On Tue, Jul 12, 2011 at 7:31 PM, Anish Shrivastava wrote: > Thanks Ankur, Rajan, Haseeb and Ashish for helping me.. :) > > > On Tue, Jul 12, 2011 at 5:37 PM, Rajan_Ve

$$Excel-Macros$$ Re: List of text files with data to Excel.

Hi Ashish, You are the man!!! This works great! After I had a backup get posted to the wrong location while updating a computer in the shop, our operators suddenly started complaining that thier tables were wrong that they had been manually updating each time they saved thier work. This will all

Re: $$Excel-Macros$$ Automation

Most welcome Shashank On Wed, Sep 21, 2011 at 5:06 PM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > Thank you Noorain thank you very much > > -- > *From:* NOORAIN ANSARI > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, 21 September 2011

Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

Dear Rashmiv, Please see attached automated Sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Sep 21, 2011 at 1:13 PM, Rsh wrote: > Hi

$$Excel-Macros$$

Hi Friends, Pls some one help, I have many files every day opening and selecting required column information copying to onother file by manually. I need to copy from "Test1" to "copy" file and required columns by easy way. If there a quick or sample way creating a Macro.

Re: $$Excel-Macros$$ Automation

Thank you Noorain thank you very much From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Wednesday, 21 September 2011 5:02 PM Subject: Re: $$Excel-Macros$$ Automation Dear Shashank,   Please find attached sheet.. Thanks & regards, Noorain Ansari h

Re: $$Excel-Macros$$ REF# error in excel 2010 when reffered file not opened

Hi Justys, Can u share sample sheet.. On Wed, Sep 21, 2011 at 12:45 PM, e_milia wrote: > Hi all, > > I have some strange error in my budget files and I realy need your > help urgently. > I have two files and one of them is linked to the second one by > function GETPIVOTDATA. When I open the fir

Re: $$Excel-Macros$$ Need help to locate data on same row each time i click OK

You've created the userform, but it looks like you don't have ANY of the code behind it. I thought your question was how to ensure that each trip is entered sequentially, now I am not so sure. Are you familiar with VBA? Are you wanting specific assistance? or are you looking for some one to writ

Re: $$Excel-Macros$$ sessions in vba

Are you asking how to add the Developer tab to the ribbon? Or.. ??   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.”

$$Excel-Macros$$ Need help to locate data on same row each time i click OK

Hi all, I have an excel file in attachment with user form. When I click on Trip1 in / out --- Its respective data gets fitted in cell C6 and D6. Similarly when I click on Trip2 in / out --- Its respective data should get stored in E6 and F6. Constraint: Trip 1 to Trip 6 are sequential.Tha

$$Excel-Macros$$ REF# error in excel 2010 when reffered file not opened

Hi all, I have some strange error in my budget files and I realy need your help urgently. I have two files and one of them is linked to the second one by function GETPIVOTDATA. When I open the first file without opening the reffered one there is a REF error no matter if I choose to updated or not

$$Excel-Macros$$ sessions in vba

how to create session in vba for excel 2010 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.lin

$$Excel-Macros$$ Automation

   Dear All , Please help me to automate the sheet -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http:/

Re: $$Excel-Macros$$ Need help on String Matching

Hi Haseeb, Thanks for you help on this query but recently I noticed onething, this formula works when we have to match strings from left. In this case it works fine. But when I have the below scenario, it doesnt work properly. For example, in source sheet I have "Analex Corporation" and in Destin