Thank you everyone.
On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar
wrote:
> Hi Pravin,
>
> PFA!!
>
>
> Edit your data in Pending CN and Highlight the row which you want to paste
> in Party Wise and hit the macro.
>
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E
r you can.” - John Wesley
-
>
> From: Pravin Gunjal
>To: excel-macros@googlegroups.com
>Sent: Friday, November 14, 2014 2:07 AM
>Subject: Re: $$Excel-Macros$$ To create a sheet with macro and overwri
Hi Pravin,
PFA!!
Edit your data in Pending CN and Highlight the row which you want to paste
in Party Wise and hit the macro.
Regards
Ashish
--
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 @
*Hi Paul :* If I add this code in my code it creates new sheet and deletes
immediately. Pl look in to this.
*Hi Ashish :* Your file is creating new sheet every time but I want the
same sheet to be overwritten with changes.
Thank you,
On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar
wrote:
> Hi P
Hi Pravin,
PFA.!!
Regards
Ashish
--
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 thread titles,
From: Pravin Gunjal
>To: excel-macros@googlegroups.com
>Sent: Thursday, November 13, 2014 7:53 AM
>Subject: $$Excel-Macros$$ To create a sheet with macro and overwrite on next
>attempt
>
>
>
>Hi,
>
>I have recorded a macro to create a new sheet called "
*Hi,I have recorded a macro to create a new sheet called "Party Wise" based
on the info available in sheet called "Pending CN"When I go for second
attempt it's giving an error because of the sheet name.Could you please
look in to this and arrange a solu
