Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

It's ok Amar. Its our duty to help our Groups... Regards, Gawli Anil On Wed, Aug 22, 2012 at 12:21 PM, amar takale wrote: > Dear Anil > Thanks very much for this help.I was searching this code long times.Really > I will thanks to you. > Amar > > > On Wed, Aug 22, 2012 at 11:55 AM, अनिल नारायण गवल

Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

Dear Anil Thanks very much for this help.I was searching this code long times.Really I will thanks to you. Amar On Wed, Aug 22, 2012 at 11:55 AM, अनिल नारायण गवली wrote: > Dear Amar, > > Pls find attached sheet enclosed. > > Regards, > Gawli Anil > > On Wed, Aug 22, 2012 at 11:49 AM, amar takale

Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

Dear Amar, Assume "xyz" is password of all sheets You can use below code.. Sub Unprotect_sheets() Dim sh As Worksheet For Each sh In ThisWorkbook.Sheets sh.Unprotect "xyz" Next sh End Sub On Wed, Aug 22, 2012 at 11:49 AM, amar takale wrote: > Hi all Experts, > How to all worksheets protect to

Re: $$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

Dear Amar, Pls find attached sheet enclosed. Regards, Gawli Anil On Wed, Aug 22, 2012 at 11:49 AM, amar takale wrote: > Hi all Experts, > How to all worksheets protect to unprotect at one time,Is there any VBA > code to unprotect sheet at one time. > > -- > Join official facebook page of this

$$Excel-Macros$$ Required VBA code for Unprotect All sheet at one time

Hi all Experts, How to all worksheets protect to unprotect at one time,Is there any VBA code to unprotect sheet at one time. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate th

Re: $$Excel-Macros$$ Error! Pasting more than 15 digits

Thanks Sara & Kuldeep for the suggestion. I need to paste value in bulk & Sara I fixed it from your method. Thanks Karan Singh On Tue, Aug 21, 2012 at 4:37 PM, Saravanan Anna wrote: > Hi, > > Put one single quote and then paste the value. (it is applied only past > value one by one only) > >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Dear Mr. Amar, Can you explain me in detail that will help me lot. I am not able understand the logic behind the attached excel THANKS & REGARDS, CA KSAGAR On Tue, Aug 21, 2012 at 4:01 PM, Amresh Maurya wrote: > > Hi CA KSAGAR , > > GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET L

Re: $$Excel-Macros$$ Urgent Required Technical Project manager Norristown PA

Hi Karan, Please don't post any job mails. It's not job posting form, So concentrate on it. Regards, Kuldeep Singh On Tue, Aug 21, 2012 at 11:36 PM, karan bhatia wrote: > > *Please respond to ka...@hmgamerica.com > * > *Position: *Project manager Capacity Planning > > *Location:* Norristown PA

RE: $$Excel-Macros$$ Merging Two excel sheets on single sheet

PFA Siraj From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Kumar Sharma Sent: Tuesday, August 21, 2012 6:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Noorain, Plz find t

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

it can be done with consolidation function venus On Aug 21, 2012 5:18 PM, "Rakesh Kumar Sharma" wrote: > Dear Experts, > > Is there any way to merge or combine data of two sheets on a single sheet. > > > > > > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > > -- > Join off

Re: $$Excel-Macros$$ Java Developer

Dear Ayush Please ban Sent from BlackBerry® on Airtel -Original Message- From: ROHIT KUMAR Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 01:49:48 To: ROHIT KUMAR Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Java Developer *Send me your resume@ sam.

Re: $$Excel-Macros$$ Sr Java Developer ,Cleveland, Ohio

Hi karan, Please follow forum rule #6 JOB posting are not allowed in this forum Sent from BlackBerry® on Airtel -Original Message- From: karan bhatia Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 01:37:50 Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ S

$$Excel-Macros$$ Java Developer

*Send me your resume@ sam.ultimateli...@gmail.com* * * *Position: *Java Developer** *Location:* Cleveland, Ohio *Duration:* : 6-12 months + * * *Skills Required* · Spring, · MVC · JQuery · Netbeans, · SVN, · Glassfish server (nice to hav

Re: $$Excel-Macros$$ Urgent Required Project manager Capacity Planning,Norristown PA

I thought this user was already banned. karan bhatia wrote: > *Please respond to ka...@hmgamerica.com > * > *Position: *Project manager Capacity Planning > > *Location:* Norristown PA > > *Duration:* 6 to 9 Months > > * > Job Description* > > It is desired that the capacity candidate kn

Re: $$Excel-Macros$$ PowerPivot in excel 2007

Dear Amit, Please visit on below link, hope it will help to resolve your query. http://www.powerpivotpro.com/2010/12/powerpivot-for-excel-2007/ -- With Regards, Noorain Ansari http:// noorainansari.com http://

Re: $$Excel-Macros$$ Project Manager with Capacity Planning West Norristown PA

Dear Mr. Rohit, Please don't Job posting It is against of Forum Rule. On Tue, Aug 21, 2012 at 9:06 PM, ROHIT KUMAR wrote: > > > Send me your Resumes @ s...@hmgamerica.com > > * > Project Manager with Capacity Planning > West Norristown PA > 6 Months Plus* > > One of our Direct Client is lookin

$$Excel-Macros$$ Project Manager with Capacity Planning West Norristown PA

Send me your References @ s...@hmgamerica.com * Project Manager with Capacity Planning West Norristown PA 6 Months Plus* One of our Direct Client is looking for Project Manager with Capacity Planning experience The job description is as follows: It is desired that the capacity candidate know ho

Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid

Sub rearranecolumnsSAS() Dim lr As Long Dim i As Long Dim dlr As Long lr = Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To Cells(1, Columns.Count).End(xlToLeft).Column dlr = Cells(Rows.Count, 1).End(xlUp).Row + 1 Cells(2, 1).Resize(lr - 1).Copy Cells(dlr, 1) Cel

Re: $$Excel-Macros$$ conditional formatting

Dear Amit, Create a simple Conditional formating rule and Manage it for Whole rows. Hilary Screen shot is nicely describing it. On Tue, Aug 21, 2012 at 7:30 PM, Amit Desai (MERU) wrote: > Dear Pravin, > > ** ** > > Could you please explain, how did you put the conditional formatting in > al

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

hi, Try below Ashish code... Sub m() Dim i, j, k, s As Long s = Sheets.Count For i = 1 To s Sheets(i).Select 'change upper row here in this case it will start copying from second row j = 2 ' it will copy till last used row automatically k = ActiveSheet.UsedRange.Rows.Count Rows(j & ":" & k).Cop

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

Move your destination sheet to be the FIRST SHEET and use this Sub combineem() For i = 2 To Sheets.Count Sheets(i).UsedRange.Copy Sheets(1).Cells(Rows.Count, 1).End(xlUp)(2) Next i End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rakesh Kumar Sharma Se

Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid

Hello Experts, I am sorry, but I am not getting right result for my query. May be I am not able to explain what I am looking for @ Don - I think there is some misunderstanding. PFA where I mentioned my expected result. I tried Using array - But unsuccessful. My First array will be A1:A

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

Dear Noorain, Plz find the sample file. I need to combine data on last sheet. & in also that case when the data is on different workbooks On Tue, Aug 21, 2012 at 5:57 PM, NOORAIN ANSARI wrote: > Dear Rakesh, > > Can you share your sample workbook with us. > > > On Tue, Aug 21, 2012 at 5:17

RE: $$Excel-Macros$$ conditional formatting

Dear Pravin, Could you please explain, how did you put the conditional formatting in all the cells together? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin Gunjal Sent: 21 August 2012 18:56 To: sperdwo...@gmail.com; excel-macro

$$Excel-Macros$$ conditional formatting

*Hi Smitha* * * *Pl try this...* * * *With regards, **Pravin Gunjal** * * * -- Forwarded message -- From: Smitha S R Date: Mon, Aug 20, 2012 at 4:59 PM Subject: Re: $$Excel-Macros$$ conditional formatting To: excel-macros@googlegroups.com The colour should be filled in the who

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

I would use a worksheet_change macro to do an autofilter for you. To show all select c5 and touch space bar Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("b5:d5")) Is Nothing Then Exit Sub If ActiveSheet.FilterMode = True Then ActiveSheet.ShowAllData tc = Target.C

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

Dear Amar, You can use SUMPRODUCT Function in 2003 instead of countifs,Sumifs,Averageif and Averageifs. On Tue, Aug 21, 2012 at 4:55 PM, amar takale wrote: > Hi Vijayendra > It is not excel 2003 version formula > > On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao > wrote: > >> >> >> 2012/8/21

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

Yes. Have you tried looking?   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 ever you can.” - John Wesley

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

Dear Rakesh, Can you share your sample workbook with us. On Tue, Aug 21, 2012 at 5:17 PM, Rakesh Kumar Sharma wrote: > Dear Experts, > > Is there any way to merge or combine data of two sheets on a single sheet. > > > > > > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > >

Re: $$Excel-Macros$$ Merging Two excel sheets on single sheet

There are many ways... Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rakesh Kumar Sharma Sent: Tuesday, August 21, 2012 6:47 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Merging Two excel sheets on single sheet Dear Experts, Is there an

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

Hi Vijayendra It is not excel 2003 version formula On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao wrote: > > > 2012/8/21 amar takale > >> Hi Vijayendra Rao >> Can you send same sheet (If & Ifs) Bocs I used Excel 2003 so it is >> difficult to understand. So Pls if possible Send me Sheet. >> Than

Re: $$Excel-Macros$$ Error! Pasting more than 15 digits

Hi, Put one single quote and then paste the value. (it is applied only past value one by one only) If you want bulk paste: 1. make the format of the cell as 'text' 2. Past special - text. Regards Sara On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh wrote: > Dear All, > > I need your assistance

Re: $$Excel-Macros$$ Error! Pasting more than 15 digits

Hi Karan, See attached file. Regards, Kuldeep Singh On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh wrote: > Dear All, > > I need your assistance in pasting below values in excel. I tried to paste but > couldn't get the right result. When I'm pasting this digits it's showing > like this :

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Hi CA KSAGAR , GO IN DEVELOPERS TOOLS INSERT SCROLL BAR THEN REFER MY SHEET LOGIC.. Regards Amresh On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Ameresh, > > Kindly tell me how we can put scroll in excel like you have done in > attached work

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Dear Ameresh, Kindly tell me how we can put scroll in excel like you have done in attached worksheet... Thanks & Regards, CA KSAGAR On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली wrote: > Dear Amar > Your formula is right > if you want only the highlighted color then on filter field click o

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Dear Amar Your formula is right if you want only the highlighted color then on filter field click on filter by color . it is easily available there Thanks & Regards, Gawli anil On Tue, Aug 21, 2012 at 3:20 PM, amar takale wrote: > Hi Amresh > I used excel 2003 So I cant see formulas.I also

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Hi Amresh I used excel 2003 So I cant see formulas.I also not understand what are doing? In which cell I put search name Then highlight search name cell. Amar On Tue, Aug 21, 2012 at 3:04 PM, Amresh Maurya wrote: > Hi Amar, > > find the attached file. hope it will help you in search the data. >

Re: $$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Hi Amar, find the attached file. hope it will help you in search the data. Regards Amresh On Tue, Aug 21, 2012 at 2:22 PM, amar takale wrote: > Hi experts, > I know it is Conditional formatting but if I search name then highlight > that cell but if there are 1000 name & I search name then I sc

Re: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]

Hi Vijayendra Rao Can you send same sheet (If & Ifs) Bocs I used Excel 2003 so it is difficult to understand. So Pls if possible Send me Sheet. Thanks Very Much Amar On Thu, Aug 16, 2012 at 4:39 PM, Vijayendra Rao wrote: > > Hi, > > Please find attached file with example. > > Regards, > Vijayendr

Re: $$Excel-Macros$$ Re: Cell show blank but in it show formula

Thanks very much Vijayajith. On Fri, Aug 17, 2012 at 8:49 PM, vijayajith VA wrote: > HI Prince,,, > > To avoid 0 s & na please use below formula > > =IF(VLOOKUP(F4,B4:D9,2,0)=0,"",VLOOKUP(F4,B4:D9,2,0)) > > > On Thu, Aug 16, 2012 at 10:52 PM, Prince Dubey wrote: > >> Please see the attachment >>

$$Excel-Macros$$ Search & Highlight name in list (1000 name list)

Hi experts, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name & I search name then I scroll bar up & down which cell highlight. I want to jump that cell directly with highlight.Is it possible? Thanks Amar -- Join official facebook page of

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

Dear Vinod, Please try it.. =OFFSET($O$11,SMALL(IF($L$12:$L$20=$F$13,ROW($O$12:$O$20),""),ROW(A1))-11,0) with ctrl+shift+enter See attachment for more clarity. On Tue, Aug 21, 2012 at 9:49 AM, Kuldeep Singh wrote: > > Hi Vinod, > > Please See attached file. > > Regards, > Kuldeep Singh > > >

Re: $$Excel-Macros$$ How the excel searching the data in it

Hi Indrajit, I know it is Conditional formatting but if I search name then highlight that cell but if there are 1000 name & I search name then I scroll bar up & down which cell highlight. I want to jump that cell directly with highlight.Is it possible? Thanks Amar On Fri, Aug 17, 2012 at 5:02 PM,

Re: $$Excel-Macros$$ Cell show blank but in it show formula

NOORAIN Sir, Thanks very much Sir On Fri, Aug 17, 2012 at 12:01 PM, NOORAIN ANSARI wrote: > Dear Amar, > > Please try it. > > *=IF(ISERR(INDEX(INDIRECT($D$2),C4)),"",INDEX(INDIRECT($D$2),C4))* > > see attached sheet. > > > On Thu, Aug 16, 2012 at 5:18 PM, amar takale wrote: > >> Thanks to all v