manoj_arsul
Board Regular
- Joined
- Jun 27, 2018
- Messages
- 61
Dear All ,
Can you please Help me to find function in VBA.
Conditions:
Enter any value in cell A10 - Sheet 1 (already fixed button - for click)
Find that value in each workbook like Sheet 3,Sheet 4, sheet 5, sheet 6......etc .
eg. if value is found in sheet 3 and sheet 4 then out put will be in sheet 2
ie. copied entire that row (multiple rows- if the value found multiple time) and 1st row of the sheet 3 & sheet 4 and paste in Sheet 2.
Eg. I am searching word America. - (clicked on Button)
Sheet 3.
Sheet 4.
Output in Sheet 2.
If the Value/word is not found the Popup Mssg "Enter Value not present in File etc"
Thanks in Advance!
Can you please Help me to find function in VBA.
Conditions:
Enter any value in cell A10 - Sheet 1 (already fixed button - for click)
Find that value in each workbook like Sheet 3,Sheet 4, sheet 5, sheet 6......etc .
eg. if value is found in sheet 3 and sheet 4 then out put will be in sheet 2
ie. copied entire that row (multiple rows- if the value found multiple time) and 1st row of the sheet 3 & sheet 4 and paste in Sheet 2.
Eg. I am searching word America. - (clicked on Button)
Sheet 3.
Country | Student Count | Passed | Failed |
China | 1000 | 800 | 200 |
America | 500 | 480 | 20 |
Japan | 500 | 470 | 30 |
Sheet 4.
Capital | Country | Student Count | Failed | Pass |
Tokyo | Japan | 400 | 50 | 350 |
Washington | America | 100 | 15 | 85 |
London | England | 700 | 100 | 600 |
Capetown | South Africa | 500 | 50 | 450 |
Washington | America | 400 | 20 | 380 |
Output in Sheet 2.
Country | Student Count | Passed | Failed |
America | 500 | 480 | 20 |
Capital | Country | Student Count | Failed | Pass |
Washington | America | 100 | 15 | 85 |
Washington | America | 400 | 20 | 380 |
If the Value/word is not found the Popup Mssg "Enter Value not present in File etc"
Thanks in Advance!