Re: $$Excel-Macros$$ Extract Data on basis of different Criterias

2013-07-03 Thread Vabs VBA
HI Pl share sample file. Thanks On Wed, Jul 3, 2013 at 7:30 PM, SG wrote: > Hi Experts, > > I want to create a report in which data would be extracted on basis of > atleast 4 filters from base data sheet.please help me with a macro example. > > Thanks in advance. > > -- > Are you =EXP(E:RT) o

Re: $$Excel-Macros$$ Query in For Each Next

2013-07-02 Thread Vabs VBA
Hi X refer to each cell in range A1 to D5. Thanks On 3 Jul 2013 10:41, "Prafull Jadhav" wrote: > Dear All, > > Good Morning.. > > > I got below macro from net ..Can you explain me what "x" stand here... > > > > *Sub Upper_()* > > *For Each x In Range("A1:D5")* > *'For Each x In Range("A1:D5")*

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Last file is with vba solution. On 1 Jul 2013 21:23, wrote: > ** > Okay! I am not very proficient with VBA. If you pls help me out in this > regard! > > Thanks Sandeep > Sent on my BlackBerry® from Vodafone > ------ > *From: * Vabs VBA &

Re: $$Excel-Macros$$ Thought you'd find this interesting

2013-07-01 Thread Vabs VBA
Thanks On Mon, Jul 1, 2013 at 7:00 AM, raghu wrote: > ** > Hi, > > I’ve just learned about the water crisis and thought you would be > interested to check out this story: > > https://waterforward.charitywater.org > > Thanks, > raghu >

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Kindly suggest solution accordingly. > > Thanks. > > Sandeep. > Sent on my BlackBerry® from Vodafone > -- > *From: * Vabs VBA > *Sender: * excel-macros@googlegroups.com > *Date: *Mon, 1 Jul 2013 15:24:40 +0530 > *To: *excel-macros@googlegroup

Re: $$Excel-Macros$$ Unable to Open Excel File... How to repair it..

2013-07-01 Thread Vabs VBA
Hey since you have sent corrupted file. we cant help you on that. Pl send original file before opening the same so we might recover. Thanks On Mon, Jul 1, 2013 at 11:27 AM, B Sharma wrote: > > > Dear Friends and excel experts,,, > I am facing this problem 3-4 time and now I want a remedy /

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Sandeep. > Sent on my BlackBerry® from Vodafone > ------ > *From: * Vabs VBA > *Sender: * excel-macros@googlegroups.com > *Date: *Mon, 1 Jul 2013 12:52:50 +0530 > *To: *excel-macros@googlegroups.com > *ReplyTo: * excel-macros@googlegroups.com > *

Re: $$Excel-Macros$$ Need Help to lock cursor or sheet display.

2013-07-01 Thread Vabs VBA
Hi You can hide all unwanted col & rows and protect workbook so that user will not be having access to that portion. Thanks On Mon, Jul 1, 2013 at 9:25 AM, Ashish Kumar wrote: > Dear Seniors, > > I have a data from Colum A to Column D in excel sheet, I want show only > this data in sheet & res

Re: $$Excel-Macros$$ Dependent Data validation with Dynamic name range!

2013-07-01 Thread Vabs VBA
Hi Pl share youe excel file. Thanks On Mon, Jul 1, 2013 at 10:07 AM, wrote: > Dear Excel expert! > > I am stuck at a point! I have kept five dynamic name range using offset > funtion viz Grouping which has a component like liabilities, asset, income > and expenses. And also have created dynam