Edgarvelez
Board Regular
- Joined
- Jun 6, 2019
- Messages
- 197
- Office Version
- 2016
- Platform
- Windows
Hi all,
I have two sheets one named DashBoard and Sheet1
In Dashboard Starting I4 I will have a range of values (dynamic range).
If C3 in DashBoard equals "Sheet Line No." then look up the values in Dashboard starting at I7 on Sheet1 in Column A and check if Columns H I J K in the same row are blank,
I they are blank then return message box with the Line Number and the words Check OK
If any H I J K are not blank then return message box with the Line Number and the words Shipped.
Example:
I have entered starting in I4
4
5
6
7
8
21
My Message box should return as follows:
Sheet Line No. 4 OK
Sheet Line No. 5 Shipped
Sheet Line No. 6 Shipped
Sheet Line No. 7 Shipped
Sheet Line No. 8 Shipped
Sheet Line No. 21 Shipped
I have two sheets one named DashBoard and Sheet1
In Dashboard Starting I4 I will have a range of values (dynamic range).
If C3 in DashBoard equals "Sheet Line No." then look up the values in Dashboard starting at I7 on Sheet1 in Column A and check if Columns H I J K in the same row are blank,
I they are blank then return message box with the Line Number and the words Check OK
If any H I J K are not blank then return message box with the Line Number and the words Shipped.
Example:
I have entered starting in I4
4
5
6
7
8
21
My Message box should return as follows:
Sheet Line No. 4 OK
Sheet Line No. 5 Shipped
Sheet Line No. 6 Shipped
Sheet Line No. 7 Shipped
Sheet Line No. 8 Shipped
Sheet Line No. 21 Shipped