• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA How do I copy a “find all” result to another sheet who's name is matching with find value?

jigar donda

New Member
I have a master data in sheet name "1.MAIN" I want to fetch data from there to another sheet for e.g
Data in sheet:- 1.MAIN

AMT NAME DATE
500 AD 12-11-2020
200 BM 05-08-2020
800 AD 08-12-2020

now for each and every unique name in the list, I have different sheet, in above e.g. I ll be having 2 sheets 1. AD 2. BM
Now what I want is transfer data from master sheet to that particular sheet who's sheet name is matching
In above e.g.
Data I need in sheet:- AD
should be....

AMT NAME DATE
500 AD 12-11-2020
800 AD 08-12-2020

Data I need in sheet:- BM
should be....
AMT NAME DATE
200 BM 05-08-2020

I have posted same q. on stack overflow check with below link
Any help will be appriciated by word of thx
 
Last edited:
jigar donda
Your cross-posting link do not work.
...Yes, now that link works.
As a new member, You've read Forum Rules
 
Last edited:
Back
Top