Data pull with criteria

[Deepak]

if in salary sheet Column O i select only 1 Trust then Macro will give in All trust data

 

[Abhijeet]

Problem ye ho raha hai ki 3 sheets me jo bhi O column me Trust ke numbers hai un sare trust ka data macro pull kar raha hai If 21 Salary ke O column me hai 37 Travel ke O column me hai aur 57 absence ke O column to in sare trust ka data macro pull kar raha hai

 

[Deepak]

Problem ye ho raha hai ki 3 sheets me jo bhi O column me Trust ke numbers hai un sare trust ka data macro pull kar raha hai If 21 Salary ke O column me hai 37 Travel ke O column me hai aur 57 absence ke O column to in sare trust ka data macro pull kar raha hai

Same has been posted you earlier.
Pls make a sample data & it's exported files as you want.
Zip the folder & upload here.

 

[Abhijeet]

Hi Deepak This macro is Ok for me i can manage with these .Only one thing can u tell me if specific path & file name i want save these work book then what should be change in the code .I can mention Path in Excel & workbook name is Trust numbers then in excel i can paste what should be in name to add

 

[Abhijeet]

No Issue this macro is ok for me this is work only where to save that path is mention in Excel that path i want save these files please tell me

Same has been posted you earlier.
Pls make a sample data & it's exported files as you want.
Zip the folder & upload here.

 

[Deepak]

No need to manage! upload what i asked & we will loop it.

for filepath i made a new named range path.