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

2016-01-30 Thread SUDHIR VERMA
👏👏👏 great Abhishek ji. On 25 January 2016 at 11:58, Shrinivas Shevde wrote: > Really a great job > Very very thanks > Regards > Shrinivas > > On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain > wrote: > >> Please see attached. >> >> HTH >> >> On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde < >

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

2016-01-24 Thread Shrinivas Shevde
Really a great job Very very thanks Regards Shrinivas On Mon, Jan 25, 2016 at 11:49 AM, Abhishek Jain wrote: > Please see attached. > > HTH > > On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde > wrote: > >> Dear Abhishek >> Thanks for the macros.Its exactly As I want. >> Can you do only a sma

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

2016-01-24 Thread Abhishek Jain
Please see attached. HTH On Mon, Jan 25, 2016 at 11:43 AM, Shrinivas Shevde wrote: > Dear Abhishek > Thanks for the macros.Its exactly As I want. > Can you do only a small help further. > Sheet Name should also appeared the cell M16 of each sheet.(In template > marked in Green).If sheet name i

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

2016-01-24 Thread Shrinivas Shevde
Dear Abhishek Thanks for the macros.Its exactly As I want. Can you do only a small help further. Sheet Name should also appeared the cell M16 of each sheet.(In template marked in Green).If sheet name is AAA then in M16 it should be AAA Thanks once again for great help Regards Shrinivas On Sat, J

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

2016-01-23 Thread Abhishek Jain
Open the attached file. Please note that you can only run this macro only once because when you do it again, it will already have the sheets created with those names and hence would give you an error. I gathered that you need it likewise (make copies once). If you want further copies, just change

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$$ 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