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
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: