$$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-04 Thread PRADEEP KUMAR KOKNE
Hello all, Can you write code for to filter(Column S)-> select the complete visible data and paste it in new workbook and save it. Example: Column S can have 50 lines data with 10 names Thanks -- 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) !

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-06 Thread Abhishek Jain
Yes, we can. On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR KOKNE < pradeepkumar...@gmail.com> wrote: > Hello all, > > Can you write code for to filter(Column S)-> select the complete visible > data and paste it in new workbook and save it. > > Example: Column S can have 50 lines data with 10 name

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
Abhishek, snarky...I like it! :) Paul From: Abhishek Jain To: MS EXCEL AND VBA MACROS Sent: Wednesday, October 7, 2015 2:37 AM Subject: Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop Yes, we can. On Sun, Oct 4, 2015 at 3:47 PM, PRADEEP KUMAR

Re: $$Excel-Macros$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Paul Schreiner
Close     End Sub I hope this helps. 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$$ filter and copy/paste in new workbook and save it on desktop

2015-10-07 Thread Leo
sisthenameofanewworkbook" and close > > '------------------------------------ > ActiveWorkbook.SaveAs _ > > Filename:="C:\Users\(*youruseridgoeshere*)\Desktop\thisisthenameofanewworkbook.xlsb", > > _ >