noveske
Board Regular
- Joined
- Apr 15, 2022
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Sheet1 is an input sheet.
Sheet2 is where the data outputs.
Using a Data Validation List to select an option on Sheet 1.
Drop down list options are A and B.
Is there a way to set VBA conditions where the selection of Sheet1.C1 would output an X on Sheet2.A1 and B would output an O in Sheet2:B1?
If Sheet1.C1=A then Sheet2.A1=X
If Sheet1.C1=B then Sheet2.B1=O
Then would repeat Sheet1.C2 would be to Sheet2.A1 / Sheet2.B1.
If Sheet1.C2=A then Sheet2.A2=X
If Sheet1.C2=B then Sheet2.B2=O
A clean way to set a range and output to corresponding row without copying the statements to check for each row?
Syntax errors from working on outputting to another sheet and the multiple cell range.
Sheet2 is where the data outputs.
Using a Data Validation List to select an option on Sheet 1.
Drop down list options are A and B.
Is there a way to set VBA conditions where the selection of Sheet1.C1 would output an X on Sheet2.A1 and B would output an O in Sheet2:B1?
If Sheet1.C1=A then Sheet2.A1=X
If Sheet1.C1=B then Sheet2.B1=O
Then would repeat Sheet1.C2 would be to Sheet2.A1 / Sheet2.B1.
If Sheet1.C2=A then Sheet2.A2=X
If Sheet1.C2=B then Sheet2.B2=O
A clean way to set a range and output to corresponding row without copying the statements to check for each row?
Syntax errors from working on outputting to another sheet and the multiple cell range.