$$Excel-Macros$$ Re: $$Excel - Macro$$, Automatically copy and paste the Formulas based on user inputs

2009-08-18 Thread venkatesh
hi Chetan! Can you please send a attachement with an example, which can help us to sort the isssue ASAP. Regards On Aug 18, 2:42 pm, Suhas wrote: > Hello Experts, > > I have a worksheet where the user enters all the data, and the second > worksheet gets updated based on the formulas linked to

$$Excel-Macros$$ Re: Sharing -loss of data - even though 1 user per sheet

2009-08-19 Thread venkatesh
Hi Mel! can you please share the worksheet for better understanding. Venky On Aug 19, 10:18 am, "melissa.brown" wrote: > Hi Everyone, > I have a shared workbook which contains one sheet for each person in > our workgroup. Each sheet has a set of checkboxes and a button. As the > person works t

$$Excel-Macros$$ VLOOKUP HELP NEED

2012-05-14 Thread Venkatesh Narla
Hi All, I need help in Vlookup need formula. "Hi All, Column A has data; Column ""F"" is the range need E to pull" 10001 #N/AA 10001 10002

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

2012-05-14 Thread Venkatesh Narla
Thanks Aamir.. thanks. I can write simeple VBA code for this On Mon, May 14, 2012 at 11:45 PM, Aamir Shahzad wrote: > =OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1) > > Aamir Shahzad > > On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla > wrote: >> >> Hi All, >>

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

2012-05-14 Thread Venkatesh Narla
m [mailto:excel-macros@googlegroups.com] > On Behalf Of Venkatesh Narla > Sent: 14 May 2012 11:30 > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ VLOOKUP HELP NEED > > Hi All, > I need help in Vlookup need formula. > > "Hi All, > Column

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

2012-05-14 Thread Venkatesh Narla
Hi Rajan, Can i get VBA code for this Thanks, Venkatesh. On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla wrote: > Thanks a lot... > > On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma > wrote: >> See the attached Solution >> With >> >> Index/Match() >>

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

2012-05-14 Thread Venkatesh Narla
earchOrder:=xlByRows, _ > SearchDirection:=xlNext).**Offset(, -1) > Next > End Sub > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > -Original Message- From: Venkatesh Narla > Sent: Monday, May 14, 2012 1:55 PM > To: exce

Re: $$Excel-Macros$$ vlookup query

2011-07-08 Thread Venkatesh Srinivas
at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><>&

$$Excel-Macros$$ Need Help for Sumif

2011-07-26 Thread Venkatesh Narla
Hi All, Need help for SUMIF Function i am doing time sheet conslidation i am not able sum up all days for one resource in other TAB Example: Resource7/1/20117/2/20117/3/2011 7/4/20117/5/20117/6/20117/7/20117/8/2011 7/

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

2011-07-26 Thread Venkatesh Srinivas
I some how feel he need to know a bit of database basics... - Clean and organize the database before working on it... - Ensure to know the compatible formula- other features based on version and its disadvantages Regards Venkatesh +91 9841969353 On Wed, Jul 27, 2011 at 9:41 AM, XLS S

$$Excel-Macros$$ VBA PDF books link need

2012-07-01 Thread Venkatesh Narla
Hi All, Please help me to fine the VBA PDF books link need. Thanks, Venkatesh. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

Re: $$Excel-Macros$$ VBA PDF books link need

2012-07-02 Thread Venkatesh Narla
Dear Noorain Ansari, Thanks a lot... Thanks, Venkatesh. On Sun, Jul 1, 2012 at 10:56 PM, NOORAIN ANSARI wrote: > Dear Venkatesh, > Hi Venkatesh, > > Download EXCEL-VBA Ebook.. > > http://search.4shared.com/q/CCAD/1/excel+vba > http://pdftop.net/excel+vba

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-07-16 Thread Venkatesh Narla
Hi All, This is Venkatesh Narla i am 26 years old and worked as Release manager in Accenture(Bangalore Location). Currently looking out for new job. 5+ years in MIS. I am from Andhra Pradesh. Thanks, Venkatesh Narla. On Mon, Jun 11, 2012 at 9:04 AM, Anand Kumar wrote: > Hi, > > I

Re: $$Excel-Macros$$ Vlookup Problem

2012-07-16 Thread Venkatesh Narla
Hi, Please find the attachment and let me know.. any thing els need.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay wrote: > Hi Friends, > > Please solve my VLookup Query. > Description is given in attached file. > Thanks. > > -- > With regards, &g

Re: $$Excel-Macros$$ Please solve my Pivot Table Problem

2012-07-17 Thread Venkatesh Narla
Hi, Please find the updated file Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay wrote: > Hi Friends, > > I need your help to solve my PT Problem. > The description is given in sheet itself. Please FA. > > Thanks. > > -- > With regards, > >

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
rajesh can you confirm if the number of rows in just 13 or will it cross more than that... if its just Jan to Dec.. we can fix it with an simple {if condition.. } or else we need to find other ideas.. Regards Venkatesh On 8/3/09, Rajesh Janardanan wrote: > > > Dear All, > Ne

$$Excel-Macros$$ Re: URGENT HELP

2009-08-02 Thread venkatesh srinivas
sorry guys.. looks like i am too late...to reply sorry ... On 8/3/09, Rajesh Janardanan wrote: > > Guys, > > I am waiting for an answer , Please respond > > Best regards > rajesh > > > On Mon, Aug 3, 2009 at 8:01 AM, Rajesh Janardanan wrote: > >> >> Dear All, >> Need an urgent help , please ref

$$Excel-Macros$$ Re: NAMED Range

2009-08-12 Thread venkatesh srinivas
Hi Suresh! can you please give an example of us to solve the problem> might be you can add a example with your desired result.. Rgds Venkatesh On Tue, Aug 11, 2009 at 8:57 PM, suresh k wrote: > Hi All, > > I have selected A1 to A5 and given some name(In Named Range). > > No

$$Excel-Macros$$ Re: help Needed!

2009-08-12 Thread venkatesh srinivas
result.. so that the formula can you given accordingly Regards Venkatesh On Wed, Aug 12, 2009 at 12:53 PM, Abdul Rehman wrote: > Hi All, > > Can anyone guide me how to input formula in column J(file attached) to > calculate the value. I am doing tht individually for each row. Would it b

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
hi dilip! Please fine enclosed the solve sheet.' On 8/18/09, Dilip Pandey wrote: > > Hi Sachin, > > Attached herewith is the dummy scenario with solution. Thanks. > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com >

$$Excel-Macros$$ Re: column chart

2009-08-18 Thread venkatesh srinivas
Hi Lynn! Please let me know if the below mentioned file solves our problem On 8/18/09, Lynn wrote: > > > i have the following columns > - dates > - no. of boxes packed > - no. of boxes to be packed. > > how do i do a column chart which compares the no. of boxes packed vs > to be packed ? > >

$$Excel-Macros$$ Re: Need to track minutes

2009-08-18 Thread venkatesh srinivas
can you please send at attachement with an example will be great for us to sort it ASAP On 8/18/09, Sachin Gohil wrote: > > Dear All, > > I have to maintain database of alarms received & closed, format is date & > time, and need to keep track of differences in minutes, please help. > > Thanks. >

Re: $$Excel-Macros$$ Excel Learning

2010-02-15 Thread Venkatesh Narla
Hi, RaHul, MS office 2007 if using very easy to learn bcz in help u can see the clipings and u easy to learn the pivot tables and charts it is very easy. Best Regards, Venkatesh Narla. On Mon, Feb 15, 2010 at 1:38 PM, RAHUL SUREKA wrote: > Hii, > I want to learn Excel Micro

Re: $$Excel-Macros$$ Excel Formula Required

2010-03-19 Thread Venkatesh Narla
Hi, Can u explain me what is ur query i did some this pls have a look On Thu, Mar 18, 2010 at 2:31 PM, Venkatesan c wrote: > Dear All, > > Any one can Assist me attached file query It's something like reverse Lookup > > -- >

Re: $$Excel-Macros$$ Pivot table problem Pls help me

2010-07-27 Thread Venkatesh Narla
Thanks a Lot I have done that.. On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote: > Dear All, > I have problem in 2007 Excel Pivot table > Pls find the Pictures. > > > Best Regards, > Venkates

Re: $$Excel-Macros$$ Need Formula

2010-07-29 Thread Venkatesh Narla
Hi, Can u check this this can be helpor not On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest wrote: > Dear All, > > Please find attach the sheet wherein I need the Data from "Tracking Sheet" > should go the each individual sheets the data. > > Please see attach file for more understanding. > >