Re: $$Excel-Macros$$ Help for macro

2016-02-05 Thread Shrinivas Shevde
Dear Paul Really great thanks for help. Regards Shrinivas On Fri, Feb 5, 2016 at 6:08 PM, Paul Schreiner wrote: > Change your macro to: > Sub MyFilter() > Dim lngStart As Long, lngEnd As Long, thisWB As Workbook > Dim NewWB As Workbook > > Set thisWB = ActiveWorkbook > '

Re: $$Excel-Macros$$ Help for macro

2016-02-05 Thread Paul Schreiner
Change your macro to:Sub MyFilter()    Dim lngStart As Long, lngEnd As Long, thisWB As Workbook     Dim NewWB As Workbook         Set thisWB = ActiveWorkbook     '-     ' Create a new workbook     '-     Workbooks.Add

Re: $$Excel-Macros$$ Help for macro

2016-02-05 Thread Shrinivas Shevde
Dear Paul Thanks for reply. Cant get it. Can you please modify it for me and send it back Thanks in Advance Regards Shrinivas On Thu, Feb 4, 2016 at 6:16 PM, Paul Schreiner wrote: > In your macro, you CREATE the new workbook: > > Workbooks.Add > ActiveWorkbook.SaveAs Filename:=thisWB.Pat

Re: $$Excel-Macros$$ Help for macro

2016-02-04 Thread Paul Schreiner
In your macro, you CREATE the new workbook:     Workbooks.Add     ActiveWorkbook.SaveAs Filename:=thisWB.Path & "\filter.xls" But then you immediately CLOSE it!     ActiveWorkbook.Close savechanges:=False  So, then when you filter the data, copy it to the clipboard and select Sheet1,it's in the CU

Re: $$Excel-Macros$$ Help for Macro

2014-06-11 Thread Shrinivas Shevde
Dear Vaibhav After running macro try to shift heading & you can see data is copied below heading Can u please how to do the same Regards shrinivas On Thu, Jun 12, 2014 at 10:35 AM, Shrinivas Shevde wrote: > Dear Be Tran Van > Thanks for kind help will check today and back by evening > > regard

Re: $$Excel-Macros$$ Help for Macro

2014-06-11 Thread Shrinivas Shevde
Dear Be Tran Van Thanks for kind help will check today and back by evening regards Shrinivas On Thu, Jun 12, 2014 at 10:28 AM, Shrinivas Shevde wrote: > Dear Vaibhav > First of all thanks for the help. > I was out of station for 2 days so I could not reply sorry for that > I will check the sam

Re: $$Excel-Macros$$ Help for Macro

2014-06-11 Thread Shrinivas Shevde
Dear Vaibhav First of all thanks for the help. I was out of station for 2 days so I could not reply sorry for that I will check the same today and will be back by evening Once again thanks Regards Shrinivas On Thu, Jun 12, 2014 at 12:09 AM, Bé Trần Văn wrote: > See the attached file. > > > > 2

Re: $$Excel-Macros$$ Help for Macro

2014-06-11 Thread Vaibhav Joshi
Hey Srinivas Did this helped?? On Mon, Jun 9, 2014 at 9:27 PM, Vaibhav Joshi wrote: > Hey check this.. > > To run macro click blue button. After running macro try to shift heading & > you can see data is copied below heading. > > This is on assumption FIFO. so already existing data wont be d

Re: $$Excel-Macros$$ Help for Macro

2014-06-09 Thread Vaibhav Joshi
ok.. I will try to send you by tonight.. Cheers!! On Mon, Jun 9, 2014 at 12:08 PM, Shrinivas Shevde wrote: > Dear Vaibhav > Thanks for reply. > As I mentioned earlier today I have 10 rows and I run the macro. I will > get output. > Tomorrow I will add more 12 rows and if I run the macro I wil

Re: $$Excel-Macros$$ Help for Macro

2014-06-08 Thread Shrinivas Shevde
Dear Vaibhav Thanks for reply. As I mentioned earlier today I have 10 rows and I run the macro. I will get output. Tomorrow I will add more 12 rows and if I run the macro I will get output and it will overwrite the last one .there are chances someone will change the data and resend .What I want is

Re: $$Excel-Macros$$ Help for Macro

2014-06-07 Thread Shrinivas Shevde
Cant understand what is this attachment On Sat, Jun 7, 2014 at 4:07 PM, Vaibhav Joshi wrote: > FYI > > > On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde > wrote: > >> Dear Vaibhav >> Where is attachment >> >> Regards >> Shrinivas >> >> >> On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote:

Re: $$Excel-Macros$$ Help for Macro

2014-06-07 Thread Vaibhav Joshi
FYI On Sat, Jun 7, 2014 at 4:01 PM, Shrinivas Shevde wrote: > Dear Vaibhav > Where is attachment > > Regards > Shrinivas > > > On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote: > >> hi >> >> check this.. >> >> It is dynamic.. >> >> CHeers!! >> >> >> On Fri, Jun 6, 2014 at 12:54 PM, Shriniva

Re: $$Excel-Macros$$ Help for Macro

2014-06-07 Thread Shrinivas Shevde
Dear Vaibhav Where is attachment Regards Shrinivas On Sat, Jun 7, 2014 at 1:30 PM, Vaibhav Joshi wrote: > hi > > check this.. > > It is dynamic.. > > CHeers!! > > > On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde > wrote: > >> Dear All >> Please help me for Macro >> 1. I have a work book wh

Re: $$Excel-Macros$$ Help for Macro

2014-06-07 Thread Vaibhav Joshi
hi check this.. It is dynamic.. CHeers!! On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde wrote: > Dear All > Please help me for Macro > 1. I have a work book which content many sheet. > 2.In a work book there is data sheet.(master sheet) sheet attached > 3.In a master sheet there is data w

Re: $$Excel-Macros$$ Help for Macro

2014-06-06 Thread Shrinivas Shevde
can anyone help me? Thanks in advance On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde wrote: > Dear All > Please help me for Macro > 1. I have a work book which content many sheet. > 2.In a work book there is data sheet.(master sheet) sheet attached > 3.In a master sheet there is data which c