Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Sanjib Chatterjee
Dear Mr Jitendra Singh, I want whenever I am doing entry in the master sheets it will copy the data to correspondence sheets. So, why do I need to delete the sheets every time. Hope Your will understand my problem. I need your help Thanking you in advance Sanjib Chatterjee On Wed, May 17,

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Jitendra Singh
Hi Mr. chatterjee, Before executing please delete all sheets. Thanks http://vbatutorial.blogspot.in/ ⁣Sent from BlueMail ​ On 17 May 2017, 9:56 AM, at 9:56 AM, Sanjib Chatterjee wrote: >Dear Preeti Tomar > >Many Many thank you for your prompt help. > >This is what exactly I am looking for. B

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Preeti Tomar
https://jeetexltips.blogspot.in/2017/05/Filterinvba.html On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Sir / madam, > > Please see the attachment. > > I have a problem I want to copy data base on the Person name which i > highlighted with yell

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Sanjib Chatterjee
Dear Jitendra Singh, I want automatically doing the task if match it will automatically copy data to other sheets. any help will be appreciated Sanjib Chatterjee On Tue, May 16, 2017 at 3:08 PM, Jitendra Singh wrote: > Use advance filter || > > Sent from BlueMail

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

2017-05-16 Thread Jitendra Singh
Use advance filter || ⁣Sent from BlueMail ​ On 16 May 2017, 2:00 PM, at 2:00 PM, Sanjib Chatterjee wrote: >Dear Sir / madam, > >Please see the attachment. > >I have a problem I want to copy data base on the Person name which i >highlighted with yellow colour. >suppose if the person name "JKM" a