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 sonal...@gmail.com 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

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 prafulltjad...@gmail.com 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

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, chhajersand...@gmail.com 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

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 kumar.ashish...@gmail.comwrote: Dear Seniors, I have a data from Colum A to Column D in excel sheet, I want show only

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 v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 12:52:50 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros

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 sharma@gmail.com wrote: Dear Friends and excel experts,,, I am facing this problem 3-4 time and now I

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

2013-07-01 Thread Vabs VBA
on my BlackBerry® from Vodafone -- *From: * Vabs VBA v...@vabs.in *Sender: * excel-macros@googlegroups.com *Date: *Mon, 1 Jul 2013 15:24:40 +0530 *To: *excel-macros@googlegroups.comexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re

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 raghunandan.rallapa...@gmail.comwrote: ** Hi, I’ve just learned about the water crisis and thought you would be interested to check out this story:

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, chhajersand...@gmail.com 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 v...@vabs.in