Blanchetdb
Board Regular
- Joined
- Jul 31, 2018
- Messages
- 161
- Office Version
- 2016
- Platform
- Windows
my work requires me to take a submitted document (created in excel) Sheet 1:
Branch: Science
Group/Level: AS02
City: Vancouver
etc.....
In sheet 2, all rows start with a process number (column A) and the information above is populated
ex:
column A B C D
Process Number Branch GR/LV City
15-ICA-VAR-156 / Operations / AS02 / Vancouver
16-ICA-VAR-134 / Science / AS02 / Vancouver
Based on the information submitted on the form in sheet 1, a search would happen in Sheet 2 and send me (email) only the process numbers that fulfill all the critereas....so in this case 16-ICA-VAR-134
can someone help me on how to do this as I presently do it manually
Branch: Science
Group/Level: AS02
City: Vancouver
etc.....
In sheet 2, all rows start with a process number (column A) and the information above is populated
ex:
column A B C D
Process Number Branch GR/LV City
15-ICA-VAR-156 / Operations / AS02 / Vancouver
16-ICA-VAR-134 / Science / AS02 / Vancouver
Based on the information submitted on the form in sheet 1, a search would happen in Sheet 2 and send me (email) only the process numbers that fulfill all the critereas....so in this case 16-ICA-VAR-134
can someone help me on how to do this as I presently do it manually
