Re: $$Excel-Macros$$ How to make Outline work in Protection

Hi Anoop, that was easy, however if you click on + of the outline, that does not work when the sheet is protected. This is the problem and i need to make that work with your help. regards, Zeeshan On Wed, Dec 5, 2012 at 10:47 AM, Anoop K Sharma wrote: > Hi Zeeshan, > > Please find attached.

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

Congrats Paul On Wed, Dec 5, 2012 at 2:08 AM, hanumant shinde wrote: > hearty congratulations Paul. i would like to know your blog link if you > post the blogs. > your knowledge is tremendous. > > -- > *From:* Ayush Jain > *To:* excel-macros > *Sent:* Monday, 3 De

Fwd: $$Excel-Macros$$ Scraping data from image

*Really a very good information. * *Thanks,* * * *Regards / Pravin.* -- Forwarded message -- From: Paul Schreiner Date: Fri, Nov 30, 2012 at 7:48 PM Subject: Re: $$Excel-Macros$$ Scraping data from image To: excel-macros@googlegroups.com -- Join official Facebook page of this f

Re: $$Excel-Macros$$ MACRO FOR LIST CHECK AND ADD ROWS

Thanks Mr. Paul No need to say Sorry. You helped me a lot. This macro is running perfectly now. Thanks a lot once again. Regards Amit On Tue, Dec 4, 2012 at 6:04 PM, Paul Schreiner wrote: > Amit, > > Sorry, > > Since I didn't know how large your data set would end up being, > I used a "Dicti

$$Excel-Macros$$ Re: Conditional Formatting

You need to create two conditional formats, one for the up arrow and one for the down arrow. In Excel 2010: For the up arrow: Select the range starting on cell L7 Go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format Write =L7>=$S$2 on the 'Format

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

hearty congratulations Paul. i would like to know your blog link if you post the blogs. your knowledge is tremendous. > > From: Ayush Jain >To: excel-macros >Sent: Monday, 3 December 2012 11:58 PM >Subject: $$Excel-Macros$$ Paul Schreiner - Most Helpful Membe

Re: $$Excel-Macros$$ Scraping data from image

Hi Paul, thanks a lot for your detailed explanation > > From: Paul Schreiner >To: excel-macros@googlegroups.com >Sent: Friday, 30 November 2012 7:48 PM >Subject: Re: $$Excel-Macros$$ Scraping data from image > > >Here's the "long" version of explanation: >

$$Excel-Macros$$ Conditional Formatting

Hi - I have a spreadsheet in which I have the following formula for statistical testing, =IF(L7>=$S$2,CHAR(233),IF(L7<=-$S$2,CHAR(234),"")). It displays an up arrow if the first IF statement is true and an down arrow if the second IF statement is true. I would like the arrow displayed to be b

Re: $$Excel-Macros$$ Multiple Values by Vlookup

Hi Noorain Sir, Below mentioned your requirement and find the attachment. =IFERROR(VLOOKUP($I$5,INDIRECT("F"&SMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1))&":"&"$G$11"),2,0),"") *Regards,* * * *Excel Beginner* * * On Tue, Dec 4, 2012 at 6:04 PM, NOORAIN ANSARI wrote:

$$Excel-Macros$$ a date query

Hi, Pls help me solve my query.   Pls find the file attached.   Thanks, Kenil -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *

Hey dats good news Manjunath.. Keep sharing Sent on my BlackBerry® from Vodafone -Original Message- From: Manjunath Narayanappa Sender: excel-macros@googlegroups.com Date: Tue, 4 Dec 2012 15:07:17 To: 'excel-macros@googlegroups.com' Reply-To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12 *

Hearty Congratulation Paul.. With the help of expertise. I started teaching Basic Excel to my friends Thanks Manjunath From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Mon, 3 Dec 2012 23:58:06 +0530 To: excel-macros ReplyTo: excel-macros@googlegroups.

$$Excel-Macros$$ Re: VBA Macros quiz #1

can i please get access to the quiz questions again? thanks! On Saturday, November 10, 2012 1:13:08 PM UTC+1, Ayush Jain wrote: > > Hello everyone, > > Here is another quiz for you to test VBA basics. There are 10 multiple > choice questions in the quiz and should not take more than 5 minutes to

Re: Fwd: $$Excel-Macros$$ Paul Schreiner - Most Helpful Member November'12

Even though this forum provides a TREMEDOUS service and makes getting assistance convenient.  I've many times expressed that the use of the written word actually makes providing this type of help more DIFFICULT! When asking for help, we tend to forget that what WE see on the screen isn't seen by

Re: $$Excel-Macros$$ Multiple Values by Vlookup

Thanks Viper for your nice solution, Generally we do it through Index, but we want to do it through Vlookup and it should work like Index, Pls suggest. *Aside to Paul Sir* : we want to make red colored part as dynamic in below mentioned formula =IFERROR(VLOOKUP($I$5,INDIRECT(ADDRESS(SMALL(I

Re: $$Excel-Macros$$ Excel Macro

I'm sorry to say that I've never heard of an application that can do as you ask. I would think it would be very difficult to interpret the macros. yes, the macro can record that you selected a cell. But it unless you've named the range that you're selecting, the macro doesn't know what the cell RE

Re: $$Excel-Macros$$ Multiple Values by Vlookup

below is the solution if i understood your requirement correctly =IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),""),ROW()-4)-4),"") with CSE pfa On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner wrote: > Noorain, > > In what way do you wish to make it more "dynamic"? > > How do you use

Re: $$Excel-Macros$$ Multiple Values by Vlookup

Noorain, In what way do you wish to make it more "dynamic"? How do you use this? 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

$$Excel-Macros$$ Multiple Values by Vlookup

Dear Group, Please find attached sample sheet, where vlookup is working on duplicate Data. Kindly suggest, how can we make it more dynamic. -- With Regards, Noorain Ansari http:// noorainansari.com http://

$$Excel-Macros$$ Latest file copy using excelvba

PFA workbook for sample design to copy files from one directory to another. Please help me to get the same. -- Thanks & Regards, Ganesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread title

$$Excel-Macros$$ Average from different sheets except blank data

*Can anybody solve this problem.* On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal wrote: > *Hello,* > *Can anybody help me to get the solution. Thanks.* > * > * > *Regards / Pravin > * > -- Forwarded message -- > From: Pravin Gunjal > Date: Sat, Dec 1, 2012 at 11:23 AM > Subject

$$Excel-Macros$$ EXCEL ADDIN MACRO

I am fresher to computer. I just have added a macro in Excel Addin in a separate module. I am getting error No. 13, while running this. I want to use this in all file. Kindly help me Sub TEXTFILE() Application.DisplayAlerts = False Application.ScreenUpdating = False On Error GoTo ErrHandl