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
> '
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
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
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
Dear All
Please find attached sheet which contain macro.
Basically there is data in sheet Book "Filter Macro".
I need to filter this data on Date basis and filter data need to paste in
new workbook.
Every time filter data then new wokbook will be created.
Now my problem is that its filterd the data
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
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
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
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
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
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
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:
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
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
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
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
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 content 5 field
4.I want to transfer the data Deptwise.
5.Order of the column is not same in master sheet and
17 matches
Mail list logo
