Re: $$Excel-Macros$$ How to delete alternate sheets faster

Dear Noorain Sir, Can you ammend your code that when we run macro, a message box appear and ask for select the sheets which you want to delete and we will select the multiple sheet which we want to delete. Aamir Shahzad On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal wrote: > *Dear Noorain* > *I

$$Excel-Macros$$ Fwd: VBA enabled sheet doesn't allow to protect

*Hello,* *Can somebody help me out on this issue * *Thanks in advance.* * * *Regards* *Pravin Gunjal. * -- Forwarded message -- From: Pravin Gunjal Date: Tue, Oct 30, 2012 at 6:58 PM Subject: VBA enabled sheet doesn't allow to protect To: excel-macros@googlegroups.com *Dear R

Re: $$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

Dear Sundar, Please convert cell as Text Select required cell and press ctrl+1 and change format of cell as text. On Thu, Nov 1, 2012 at 11:52 AM, Sundarvelan N wrote: > Dear Gurus, > > I have a file which has the values like 6 - 11 > > 7 - 20 > > 2 - 27 > > which is automatically changing to

Re: $$Excel-Macros$$ How to delete alternate sheets faster

Dear Pravin, Please press Alt+F11 and goto Insert-module and paste code and press F5 to execute macro. Hope it will useful for you. On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal wrote: > *Dear Noorain* > * > * > *Pl inform how to and where to use this code..* > *Thank you.* > * > * > *Pravi

$$Excel-Macros$$ 6 - 11 automatically changing to date formate it should display as it is

Dear Gurus, I have a file which has the values like 6 - 11 7 - 20 2 - 27 which is automatically changing to date format but it should display the same 6 - 11 7 - 20 2 - 27 Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to delete alternate sheets faster

*Dear Noorain* * * *Pl inform how to and where to use this code..* *Thank you.* * * *Pravin. * On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI wrote: > Dear Pravin, > > > Please try > > Sub delete_alternative_sheet() > Dim i As Integer > On Error Resume Next > For i = 2 To Sheets.Count Step 2 >

Re: $$Excel-Macros$$ Recover Excel File

goto Run type %Appdata% their u'll find Microsoft folder inside that u'll find Excel folder their u'll find different version excel file On Thu, Nov 1, 2012 at 11:09 AM, amar takale wrote: > Dear Anil > Can you explain detail.I used your solution by run type but what. > > > On Thu, No

Re: $$Excel-Macros$$ Unhide sheet

Another approach with *for next* loop Sub unhide_sheet() For i = 1 To Sheets.Count Sheets(i).Visible = True Next i End Sub On Thu, Nov 1, 2012 at 10:47 AM, अनिल नारायण गवली wrote: > > Dear Amar, > > open excel sheet > press Alt+f11 > insert a module > copy following code > > Sub UnHideAllSheet

Re: $$Excel-Macros$$ Recover Excel File

Dear Anil Can you explain detail.I used your solution by run type but what. On Thu, Nov 1, 2012 at 10:09 AM, अनिल नारायण गवली wrote: > Yes Dear, > Just goto Run type %appdata% > in that goto Microsoft-> Excel > there u'll find the old data . > > Regards, > Anil Gawli > > On Wed, Oct 31, 2

Re: $$Excel-Macros$$ How to delete alternate sheets faster

Dear Pravin, Please try Sub delete_alternative_sheet() Dim i As Integer On Error Resume Next For i = 2 To Sheets.Count Step 2 Sheets(i).Delete Next i End Sub On Thu, Nov 1, 2012 at 10:51 AM, Pravin Gunjal wrote: > *Dear Friends,* > * > * > *Greetings !* > * > * > *I am having an excel file (o

Re: $$Excel-Macros$$ Unhide sheet

Dear Amar, open excel sheet press Alt+f11 insert a module copy following code Sub UnHideAllSheets() For Each c In Sheets c.Visible = True Next c End Sub and run the macro On Thu, Nov 1, 2012 at 10:17 AM, amar takale wrote: > Hi All Champs, > Can anybody tell me how to unhide worksheets

$$Excel-Macros$$ Unhide sheet

Hi All Champs, Can anybody tell me how to unhide worksheets in excel at one times in Excel 2003.Bcos there are alot of time waste to unhide sheets one by one Pls give solution Regards Amar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ m

Re: $$Excel-Macros$$ Recover Excel File

Yes Dear, Just goto Run type %appdata% in that goto Microsoft-> Excel there u'll find the old data . Regards, Anil Gawli On Wed, Oct 31, 2012 at 7:39 PM, Paul Schreiner wrote: > There are many possibilities, but most depend on your computer system. > > Do you (or someone else) regularly back up

Re: $$Excel-Macros$$ Mysterious Date Grouping in a Pivot Table

Hi, Change Date format and try again. thanks satendra On Thu, Nov 1, 2012 at 4:03 AM, Greg2011 wrote: > Hi, > > I have a pivot table that includes a field in the 'PivotTable Field List', > that is not in the source data. It appears to be a copy of a Date field > that has somehow been grouped b

Re: $$Excel-Macros$$ Qc Results update tool

Like how you connect without using macros? Regards David Grugeon On 1 November 2012 13:01, Rajan_Verma wrote: > Can you explain more? > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.c

RE: $$Excel-Macros$$ Qc Results update tool

Can you explain more? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nevin Bennet Sent: 31 October 2012 10:15 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Qc Results u

$$Excel-Macros$$ stock cover for material requirement

Hi All, I'd like you to help me on stock cover formula that will help me calculate stock coverage. Please look inside the file. regards Pawel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Mysterious Date Grouping in a Pivot Table

Hi Greg Couple of issues. First the date in the data is actually text of something that looks like a date, followed by a space. As such it cannot easily be converted to a true date. To convert it you would need to st up a new column and use =DATE("20"&MID(A2,7,2),LEFT(A2,2),MID(A2,4,2)) The pi

Re: $$Excel-Macros$$ excel macros for pasting to selected range

I tried it and it didn't work. I select two whole rows and when I run the macros nothing happens On Wednesday, October 31, 2012 12:26:09 PM UTC-7, Sam Mathai Chacko wrote: > Is this what you wanted?? > > Sub CopyToRows() > > Dim strRange As String > strRange = Selection.EntireRow.A

$$Excel-Macros$$ Re: Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

fantastic Paul. yes, all workbooks in only one folder. worked like a charm. Many thanks. Mel On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote: > I have a master spreadsheet with 5 tabs. On my master sheet (called > Master) - on the tab called 'Option Letter' I need to copy c

Re: $$Excel-Macros$$ excel macros for pasting to selected range

Is this what you wanted?? Sub CopyToRows() Dim strRange As String strRange = Selection.EntireRow.Address(0, 0) Range(strRange).Value = Range("2:2").Value End Sub Regards, Sam Mathai Chacko On Thu, Nov 1, 2012 at 12:50 AM, key log wrote: > Hi all, > > This is a very easy macro bu

$$Excel-Macros$$ excel macros for pasting to selected range

Hi all, This is a very easy macro but since I just started learning about VBA I'm having a hard time making something that works. What I want to do is have a macros button that will paste a specific row to a selected field. So, I want the user to select whatever rows they want, say rows 99-101

Re: $$Excel-Macros$$ Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

Is the 200 workbooks the ONLY files in the folder C:\EBACKUP ? If so, you can place this macro in a "standard" module of your master workbook: Sub CopyData()     Dim fso, Fldr, fl, fc, f     Dim Sht     Sht = "Option Letter"     Fldr = "C:\EBACKUP\"     Application.ScreenUpdating = False     Set

$$Excel-Macros$$ How to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

On Wednesday, October 31, 2012 12:49:45 PM UTC-4, Mel wrote: > > I have a master spreadsheet with 5 tabs. On my master sheet (called > Master) - on the tab called 'Option Letter' I need to copy cells B131, > B202, B319, B424 to the same > tab (same name on each sheet 'Option Letter') on over

$$Excel-Macros$$ Bar Graph

Hi, Can you provide me the bar graph for the below data. Volumes & Time Spent Process Name Volumes Time Spent Weekly Product1 11 17:36:01 1 Product2 18 64:31:41 1 Product3 1 0:48:34 2 Product4 5 2:33:21 1 Product5 15 3:30:05 1 Product6 5 2:04:13 1 Product7 1 0:11:00

$$Excel-Macros$$ Need help to create VBA to copy 4 cells from one spreadsheet to over 200 spreadsheats in same folder

I have a master spreadsheet with 5 tabs. On my master sheet (called Master) - on the tab called 'Option Letter' I need to copy cells B131, B202, B319, B424 to the same tab (same name on each sheet 'Option Letter') on over 200 spreadsheets. I will need to unprotect the Option Letter tab (no pa

$$Excel-Macros$$ QC results update tool

Hi Friends, Iam not able to find the right kind of code which is used to connect QC test lab folder using macros.Objective is to update around 1200 tc using macros. It would be great if somebody is guiding me and iam very new to using macros.. Regards -- Join official facebook page of this

$$Excel-Macros$$ Qc Results update tool

Hi Friends, Iam not able to find the right kind of code which is used to connect QC test lab folder using macros. It would be great if somebody is guiding me and iam very new to using macros.. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Preserving number leading 0 querytable excel

thanks kuldeep, but not solved my problem Divaker On Tue, Oct 30, 2012 at 10:08 PM, Kuldeep Singh wrote: > > Hi Sir, > > Please see this link. I hope it will help you. > > > http://blog.sqlauthority.com/2012/09/30/sql-server-preserve-leading-zero-while-coping-to-excel-from-ssms/ > > Regards, > K

RE: $$Excel-Macros$$ need help

=DATE(D2,C2,B2) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Neeraj Sent: 31 October 2012 11:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ need help Dear Experts, Kindly fi

Re: $$Excel-Macros$$ Obtain percentile values through pivot table

please find the attached sample file. On Wed, Oct 31, 2012 at 2:29 PM, Shaik Waheed wrote: > yeah sure, can u share ur sample file > > > On Wed, Oct 31, 2012 at 2:33 PM, Sheyn Lee wrote: > >> Dear Excel group members, >> Is there any way that I can get percentile values from a pivot table. >>

Re: $$Excel-Macros$$ Creating Alarm/Alert MSG for every Hour

The editor used by Puttu is replacing the quotes with "smart quotes" (notice the way the quotes at the beginning and end of “Send Massange” (sic) are different?)   Replace them with " also, these macros must reside in a "standard" module rather than a sheet module. Paul

Re: $$Excel-Macros$$ Recover Excel File

There are many possibilities, but most depend on your computer system. Do you (or someone else) regularly back up your folders? If this is a company computer, does someone else back up the folders where you stored this file? If so, then the file can be restored from the last backup. If not, then

$$Excel-Macros$$ need solution........

Dear All,  After Long time i coming back to Excel-Macros group to get some solution in the excel formula. here i attached the file with my question. any one can solve the problem wit Regards     Delin.F   Administrator Asst -- Join official facebook page of this forum @ https://www.faceboo

RE: $$Excel-Macros$$ Vlookup Book

Dear Noorain, Are you back? Could you please share the file please? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of noorain.ans...@gmail.com Sent: 29 October 2012

Re: $$Excel-Macros$$ Serial no

you can also use =IF(MONTH($B$2)=MONTH(A5),COUNT($D$3:D4)+1,"") Aamir Shahzad On Wed, Oct 31, 2012 at 5:18 PM, Rohan Young wrote: > hi Prashant, > > PFA > > regds > > On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle > wrote: > >> Dear Experts >> >> Please help to arrive serial number with if c

Re: $$Excel-Macros$$ Serial no

hi Prashant, PFA regds On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ me

Re: $$Excel-Macros$$ Serial no

Dear Prashant, Please try it. =IF($B$2="&$B$2),"") and See attached sheet for more reference. On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this f

Re: $$Excel-Macros$$ Serial no

Hi, Try this...=COUNTIF($A$4:A4,A4) On Wed, Oct 31, 2012 at 5:35 PM, Prashant Pawle wrote: > Dear Experts > > Please help to arrive serial number with if condition > > Regards, > > Prashant > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RUL

$$Excel-Macros$$ Serial no

Dear Experts Please help to arrive serial number with if condition Regards, Prashant -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Recover Excel File

Dear Expert, Please tell me any body how can i Restore my excel file after save... I save my excel file and closed. can i get old.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) U

Re: $$Excel-Macros$$ Obtain percentile values through pivot table

yeah sure, can u share ur sample file On Wed, Oct 31, 2012 at 2:33 PM, Sheyn Lee wrote: > Dear Excel group members, > Is there any way that I can get percentile values from a pivot table. > Appreciate your help. > S > > -- > Join official facebook page of this forum @ > https://www.facebook.com/

$$Excel-Macros$$ Obtain percentile values through pivot table

Dear Excel group members, Is there any way that I can get percentile values from a pivot table. Appreciate your help. S -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect

Move the Rajan's Code to the Command button Class Module (On Click Event) Regards, Anoop On Tue, Oct 30, 2012 at 6:55 PM, Rajan_Verma wrote: > *So you want button for protect or Unprotect Sheet?* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:*

Re: $$Excel-Macros$$ need solutions

PFA Aamir Shahzad On Wed, Oct 31, 2012 at 1:04 PM, Shaik Waheed wrote: > PFA, > Hope this is what u were luking for > > On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote: > >> PFA >> >> -- >> *Rajesh Kumar Agarwal* >> *9811063001* >> >> -- >> Join official facebook page of this forum @ >> h

Re: $$Excel-Macros$$ need solutions

PFA, Hope this is what u were luking for On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote: > PFA > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for viol

Re: $$Excel-Macros$$ need solutions

Hi, Find Another solution i think this is right solution.. as per ur requirement.. thankx satendra On Wed, Oct 31, 2012 at 1:23 PM, Amresh Maurya wrote: > On Wed, Oct 31, 2012 at 1:22 PM, Satendra kumar > wrote: > > Hi, > > > > Find Attachment. > > > > > > On We

Re: $$Excel-Macros$$ need solutions

On Wed, Oct 31, 2012 at 1:22 PM, Satendra kumar wrote: > Hi, > > Find Attachment. > > > On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote: >> >> PFA >> >> -- >> Rajesh Kumar Agarwal >> 9811063001 >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.c

Re: $$Excel-Macros$$ need solutions

Hi, Find Attachment. On Wed, Oct 31, 2012 at 1:20 PM, Rajesh Agarwal wrote: > PFA > > -- > *Rajesh Kumar Agarwal* > *9811063001* > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violat

$$Excel-Macros$$ need solutions

PFA -- *Rajesh Kumar Agarwal* *9811063001* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula P