Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-22 Thread Shrinivas Shevde
Dear Paul, Very very thanks for reply. I may not able to modify the macros. Find attached file. There are 2 sheets one is template and another is sheet 1 I want to make 7 sheets of template.(This is just example actually I want to make more than 50 sheets in January Sheet name is mentioned in the S

Re: $$Excel-Macros$$ Unique Problem in unhanding sheet

2016-01-22 Thread Paul Schreiner
I'm afraid your workbook IS protected.Unless you know the password, I'm afraid you will not be able to display the hidden sheets.  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

$$Excel-Macros$$ Re: formula for creating numbers

2016-01-22 Thread GENIUS
OK I DID IT AND THANK YOU VERY MUCH FOR YOUR KINDNESS -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ VBA Code for Create Name Range

2016-01-22 Thread amar takale
Dear All Here I want VBA code for creating Name Range (Ctrl+F3).If there are few companies then it is possible to create name rage for each sector but if there are more than 100 companies with different sector in both column then there are a lot of time consuming.So i want this code. If we click

Re: $$Excel-Macros$$ Create Multiple sheet

2016-01-22 Thread Paul Schreiner
Are you able to modify macros if they are provided?If not, then we'll need to know EXACTLY which cells contain the list of sheet names and how to come up with the names for the new sheets. Paul- “Do all the good you can, By all the means you can, In all the

$$Excel-Macros$$ Create Multiple sheet

2016-01-22 Thread Shrinivas Shevde
Dear Experts, I want a help in macro. I have a excel sheet as a template. Now I want to make a multiple sheet with same template. Currently I am doing it manually like copy sheet and rename the same. Can Any one write a macro which will ask user no of sheet to be created and it will creat no of sh

Re: $$Excel-Macros$$ Re: Pivot Sorting

2016-01-22 Thread Satendra kumar
Hi Mandeep, find the attachment.. thanks satendra kumar On Fri, Jan 22, 2016 at 12:39 PM, Mandeep Baluja wrote: PFA !! thread closed !!! Regards, Mandeep baluja https://www.linkedin.com/messaging/thread/6086488646137958400 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y