praweencom
New Member
- Joined
- Mar 10, 2019
- Messages
- 1
I have an worksheet columns from A to BA in Sheet with multiple coulmns:
<code>Column A: Employee Number
Coulmn B: First Name Source
Coulmn C: First Name Target
Coulmn D: First Name Validate (True/False)
Coulmn E: Last Name Source
Coulmn F: Last Name Target
Coulmn G: Last Name Validate (True/False)
and so on...</code>I have many columns like D and G in the sheet with True or False as result.
I’m now trying to create a sheet which shows list of First Name with False Validation for multiple validations as below in Sheet 2.
Table: First Name Validation (Table 1)
<code>Coulmn A2: Employee Number
Coulmn B2: First Name Source
Column C2: First Name Target</code>In the same sheet after the values for above, the below data should be shown:
Table: Second Name Validation (Table 2)
<code>Column Ax: Employee Number
Coulmn Bx: Last Name Target
Column Cx: Last Name Target</code>x: Any row based on the number of entires from table 1.. Basically, I’m trying to show the data in one sheet with Employee Number as key field with validation false for each criteria. This would be easy on end user to see everything in a single sheet instead of multiple sheets, filter and identifying employee number.
Is this possible in excel with VBA? Thank You.
<code>Column A: Employee Number
Coulmn B: First Name Source
Coulmn C: First Name Target
Coulmn D: First Name Validate (True/False)
Coulmn E: Last Name Source
Coulmn F: Last Name Target
Coulmn G: Last Name Validate (True/False)
and so on...</code>I have many columns like D and G in the sheet with True or False as result.
I’m now trying to create a sheet which shows list of First Name with False Validation for multiple validations as below in Sheet 2.
Table: First Name Validation (Table 1)
<code>Coulmn A2: Employee Number
Coulmn B2: First Name Source
Column C2: First Name Target</code>In the same sheet after the values for above, the below data should be shown:
Table: Second Name Validation (Table 2)
<code>Column Ax: Employee Number
Coulmn Bx: Last Name Target
Column Cx: Last Name Target</code>x: Any row based on the number of entires from table 1.. Basically, I’m trying to show the data in one sheet with Employee Number as key field with validation false for each criteria. This would be easy on end user to see everything in a single sheet instead of multiple sheets, filter and identifying employee number.
Is this possible in excel with VBA? Thank You.
