$$Excel-Macros$$ MS excel training company Gurgaon

The Greatest Diwali Bumper Discount at Advance Excel Training with SSDN Technologies...!! Microsoft® Excel Advanced certification training helps you to understand how to organize, visualize, calculate & manage data in MS Excel . Learn how to create efficient formulas and use some of the 450+

$$Excel-Macros$$ MS Excel Training for Microsoft Office Specialist Certification

This* MS Excel 2013 *Course has been designed for students, clerical workers, book keepers, and

Re: $$Excel-Macros$$ MS Excel

oglegroups.com Subject: $$Excel-Macros$$ MS Excel Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealerItemaa1ba2aa3ca4aa5da6 Regards, Rajender Soni

$$Excel-Macros$$ MS Excel

Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealerItemaa1ba2aa3ca4aa5da6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

$$Excel-Macros$$ MS Excel

Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealer Item a a1 b a2 a a3 c a4 a a5 d a6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$ MS Excel 2003 to 2010

Hi Prashant, Please download Interactive menu to ribbon guide http://www.microsoft.com/en-us/download/confirmation.aspx?id=16642 . Enjoy Team XLS On Mon, Oct 14, 2013 at 3:21 PM, Prashant Pednekar wrote: > Dear friends > > We are migrating from MS Excel 2003 to Excel

Fwd: $$Excel-Macros$$ MS Excel 2003 to 2010

Good morning all. Sorry ! I did not used *Please help.* in my earlier mail. Request you to help me. Thanks Prashant. -- Forwarded message -- From: Prashant Pednekar Date: Mon, Oct 14, 2013 at 3:21 PM Subject: $$Excel-Macros$$ MS Excel 2003 to 2010 To: excel-macros

$$Excel-Macros$$ MS Excel 2003 to 2010

Dear friends We are migrating from MS Excel 2003 to Excel 2010 Dose any one of you has Menu and commond by command comparion in both version.s i.e. 2003 2010 Data > Validation ??? Else is anyone has related material. Regards Prashant -- Are you =EXP(E

$$Excel-Macros$$ MS Excel Password Recovery Software

hello Everyone I tell you my self experience about Excel password recoverysoftware, a few days ago I have lost my excel file password then I could not remember what was my excel file password then I searched an excel file password recovery software on

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

That did it. I found out the issue (that user had macros disabled) and made appropriate changes so it will now run. On Monday, January 28, 2013 7:25:04 PM UTC-8, David Grugeon wrote: > > Hi Richard > > I suppose you are trying to say that, although the workbook opens, it does > not do whatever

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

Thank you David. Unfortunately you are right. I say unfortunately because I am forced to change my password every 3 months, so having it on my logon means one more thing to remember. Any thoughts on what resources the alternate login, which never changes, is looking for Thanks again On Monda

Re: $$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

Hi Richard I suppose you are trying to say that, although the workbook opens, it does not do whatever the macro should do. Could this be because it is running in the scheduler's workspace, which does not have access to your workspace. you may need to get scheduler to run it using either your log

$$Excel-Macros$$ MS Excel, VBA and Windows Scheduler

I have a workbook which has a VBA script in the thisworkbook called sub workbook_open. When I open the workbook, it runs perfectly, and does exactly what I want it to do. If I try to schedule it to run at 5PM everyday, Windows Scheduler will show that the job is running, and I know that the wor

Re: $$Excel-Macros$$ MS Excel Vlookup query

N(ROW($L$12:$L$26))+1,""),ROW(A1)),4) >>>> An array formula that must be entered using ctrl+shift+enter >>>> >>>> Don Guillett >>>> Microsoft Excel Developer >>>> SalesAid Software >>>> dguille...@gmail.com >>&g

Re: $$Excel-Macros$$ MS Excel Vlookup query

re >> dguille...@gmail.com >> >> *From:* vinod rao >> *Sent:* Monday, August 20, 2012 1:05 PM >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ MS Excel Vlookup query >> >> Hi, >> >> I need a formula plz. >>

Re: $$Excel-Macros$$ MS Excel Vlookup query

entered using ctrl+shift+enter > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* vinod rao > *Sent:* Monday, August 20, 2012 1:05 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ MS Excel

Re: $$Excel-Macros$$ MS Excel Vlookup query

August 20, 2012 1:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ MS Excel Vlookup query Hi, I need a formula plz. My data base is very huge. i cannot use autofilter. On Mon, Aug 20, 2012 at 11:18 PM, dguillett1 wrote: Just use data>filter>autofilter Don Guil

Re: $$Excel-Macros$$ MS Excel Vlookup query

:* vinod rao > *Sent:* Monday, August 20, 2012 12:35 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ MS Excel Vlookup query > > Hi Team, > > I want to put vlookup or any other foumula and get the second/third lookup > data. > > See attached fi

Re: $$Excel-Macros$$ MS Excel Vlookup query

Just use data>filter>autofilter Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: vinod rao Sent: Monday, August 20, 2012 12:35 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MS Excel Vlookup query Hi Team, I want to put vlookup or any

$$Excel-Macros$$ MS Excel Vlookup query

Hi Team, I want to put vlookup or any other foumula and get the second/third lookup data. See attached file for example. Thanks advance for any help. Regards Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for

$$Excel-Macros$$ MS-Excel Hanging

My Excel 2011 is stopped always -- FORUM RULES (934+ 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 get quick attention or may not be answered. 2) Do

$$Excel-Macros$$ MS EXCEL 2007 and Significance Testing

I have data from two surveys. One survey was completed on 900 people before a certain event happened, and then a second survey was completed on a further 900 people after an event happened. I need to calculate the % difference between the two whilst looking at the demographics of the individuals.

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

Hey please see the answer :- 1-B, 2-D, 3-D, 4-B, 5-C, 6-D, 7-A, 8-C, 9-B, 10-A, 11-B, 12-C, 13-D, 14-B, 15-D, 16-B, 17-B, 18-A, 19-B, 20-C, On Sat, Jul 23, 2011 at 9:49 AM, XLS S wrote: > MS Excel MCQ Quiz > > > 1. You can use the formula pallette to > > A) format cells containing numbers >

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

hi I need answers also pls Thanks On Sat, Jul 23, 2011 at 9:49 AM, XLS S wrote: > MS Excel MCQ Quiz > > > 1. You can use the formula pallette to > > A) format cells containing numbers > B) create and edit formula containing functions > C) enter assumptions data > D) copy a range of cells >

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

Hi I need answers also pls thanks On Sat, Jul 23, 2011 at 9:49 AM, XLS S wrote: > MS Excel MCQ Quiz > > > 1. You can use the formula pallette to > > A) format cells containing numbers > B) create and edit formula containing functions > C) enter assumptions data > D) copy a range of cells >

Re: $$Excel-Macros$$ MS Excel MCQ Quiz

please paste the ans. also. -- -- 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.linkedin.com/groups

$$Excel-Macros$$ MS Excel MCQ Quiz

MS Excel MCQ Quiz 1. You can use the formula pallette to A) format cells containing numbers B) create and edit formula containing functions C) enter assumptions data D) copy a range of cells 2. When a range is selected, how can you activate the previous cell? A) Press the Alt key B) Pre

$$Excel-Macros$$ MS Excel VBA Interview Questions & Answers

Hi Friends, Click here --> http://www.excelitems.com/2010/12/excel-vba-interview-questions.html These Excel VBA Interview questions are being posted keeping in mind that reader is aware of working with VBA, have some programming and MS Excel background and is aware of terminologies. This questio

Re: $$Excel-Macros$$ MS Excel help needed for newbie

Please check the sheet Regards On Thu, Oct 7, 2010 at 12:00 PM, Dean Brown wrote: > I have several questions so if it's ok with you I'll ask then one at a > time (that'll give me time to digest any answers). > > Ok, here's problem 1. > > I want the person using the spreadsheet to input a value i

Re: $$Excel-Macros$$ MS Excel help needed for newbie

or, another formula in A2 *=MATCH(TRUE,A1={"A","B","C","D","E"},0)*20-10* * * *** * On Thu, Oct 7, 2010 at 4:23 PM, siti Vi wrote: > *formula in cell A2 * > =CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90) > *formula in cell A3* > =A2+10 > > > On Thu, Oct 7, 2010 at 1:30 PM, Dean Br

Re: $$Excel-Macros$$ MS Excel help needed for newbie

*formula in cell A2 * =CHOOSE(MATCH(TRUE,A1={"A","B","C","D","E"},0),10,30,50,70,90) *formula in cell A3* =A2+10 On Thu, Oct 7, 2010 at 1:30 PM, Dean Brown wrote: > I have several questions so if it's ok with you I'll ask then one at a > time (that'll give me time to digest any answers). > > Ok,

$$Excel-Macros$$ MS Excel help needed for newbie

I have several questions so if it's ok with you I'll ask then one at a time (that'll give me time to digest any answers). Ok, here's problem 1. I want the person using the spreadsheet to input a value into cell A1. The value that is input is going to be either A,B,C,D or E. The values of cells A2

$$Excel-Macros$$ MS Excel VBA cut and paste from multiple workbooks into one central Output worksheet.

So far I have created the first part of the macro which validates in the'MASTER' worksheet the Filename (in 'Column A') and worksheet (in 'Column B') Validity parameters with a 'Yes' and 'No' text in ('Column C'). Worksheet: MASTER FilenameworksheetValidity

Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

Date: *Fri, 14 May 2010 21:23:43 +0530 > *To: * > *Subject: *$$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach > > I friends, i have excel-2007 bible by john walkenbach, if anybody wants, > just inform me, i will send to their e mail id. > regards > sudhir > > On F

$$Excel-Macros$$ Ms-Excel Bible by john walkenbach

Mr excel, Can you send the link for 2003 version Thanks Harry -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN g

Re: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

Yes, would you please send to me also? Many thanks. Sent from my BlackBerry Smartphone provided by Alltel -Original Message- From: sudhir kumar Date: Fri, 14 May 2010 21:23:43 To: Subject: $$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach I friends, i have excel-2007 bible by

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

I friends, i have excel-2007 bible by john walkenbach, if anybody wants, just inform me, i will send to their e mail id. regards sudhir On Fri, May 14, 2010 at 10:14 AM, Mr excel wrote: > i had also found 2003 version shall i upload it to the forum. > > > On Fri, May 14, 2010 at 10:12 AM, Mr exc

$$Excel-Macros$$ Ms-Excel Bible2007 by john walkenbach

I friends, i have excel-2007 bible by john walkenbach, if anybody wants, just inform me, i will send to their e mail id. regards sudhir On Fri, May 14, 2010 at 10:14 AM, Mr excel wrote: > i had also found 2003 version shall i upload it to the forum. > > > On Fri, May 14, 2010 at 10:12 AM, Mr exc

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

i had also found 2003 version shall i upload it to the forum. On Fri, May 14, 2010 at 10:12 AM, Mr excel wrote: > hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it > here. > > > > On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote: > >> Hi Excel Masters,

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

you can download it from this link *http://www.easy-share.com/1909713544/Excel 2007 Bible.pdf Regards Hemant Koranne * On Fri, May 14, 2010 at 10:06 AM, Vikas Chouhan wrote: > me also send pleasvikask...@gmail.com > > On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com>

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

hi, i had Excel Bible 2002 by John Walkenbach.if u want it i will post it here. On Thu, May 13, 2010 at 11:52 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Excel Masters, > > Could any one have MS-Excel Bible by john walkenbach e-book. > if so could please send it to me at 06n...@gmail.com. > > >

Re: $$Excel-Macros$$ Ms-Excel Bible by john walkenbach

me also send pleasvikask...@gmail.com On Thu, May 13, 2010 at 11:22 AM, Nani Ram <06n...@gmail.com> wrote: > Hi Excel Masters, > > Could any one have MS-Excel Bible by john walkenbach e-book. > if so could please send it to me at 06n...@gmail.com. > > > Thanks in advance, > > Nani

$$Excel-Macros$$ Ms-Excel Bible by john walkenbach

Hi Excel Masters, Could any one have MS-Excel Bible by john walkenbach e-book. if so could please send it to me at 06n...@gmail.com. Thanks in advance, Nani Ram -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

e: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior On Mar 17, 11:57 am, Paul Schreiner wrote: > Can you send me the file? No, sorry I can't.  It's got confidential info.  So, stupid question, but just wanna make sure ... with Locking checked and She

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

On Mar 17, 11:57 am, Paul Schreiner wrote: > Can you send me the file? No, sorry I can't. It's got confidential info. So, stupid question, but just wanna make sure ... with Locking checked and Sheet Protection on, those cells should definitely not be accepting user input, right? --

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

Mar 2010 06:52:07 -0700 > Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell > locking behavior > From: jeffhollifield1...@gmail.com > To: excel-macros@googlegroups.com > > I don't think my question was clear. I understand how to lock or > unlock cells.

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

, March 17, 2010 9:52:07 AM Subject: Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior I don't think my question was clear.  I understand how to lock or unlock cells.  The problem I'm having isn't with this.  What I'm seeing is that when the Worksheet P

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

x27; thing once. > > Regards - Dave. > > > > > Date: Tue, 16 Mar 2010 10:35:15 -0700 > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking > > behavior > > From: jeffhollifield1...@gmail.com > > To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

> Regards - Dave. > > > Date: Tue, 16 Mar 2010 10:35:15 -0700 > > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell > locking behavior > > From: jeffhollifield1...@gmail.com > > To: excel-macros@googlegroups.com > > > > > Hi all, &g

RE: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

l key, and just do the 'Locked' thing once. Regards - Dave. > Date: Tue, 16 Mar 2010 10:35:15 -0700 > Subject: $$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking > behavior > From: jeffhollifield1...@gmail.com > To: excel-macros@googlegroups.com

$$Excel-Macros$$ MS Excel 2003: odd sheet protection/cell locking behavior

Hi all, I've got an Excel spreadsheet that is used for collecting some data from end users and each tab uses Sheet Protection with a password, with users able to select locked & unlocked cells. We also have a mix of locked & unlocked cells on each tab. There's also no VBA in this workbook. On o