kiwikiki718
Board Regular
- Joined
- Apr 7, 2017
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
Hello I an trying to automate geting a value from a list of subjects I have on one worksheet and placing the value into another work sheet 2xs for each record.
Worksheet 1 column A has a list that I want to copy the values from A1 down to the last record and input each value into worksheet 2 twice including “_pass” for the first value and _Failed for the 2nd value starting at Column A1 and moving to the next column (B1) etc basically just creating headings on worksheet 2 from the list.
For example if the first value from the list on worksheet 1 is Math.
I want to take that Value and input it into worksheet 2 Cell A1 displaying Math_Pass and cell B1 displaying Math_Failed. Then move on to the next value in the list and do the same placing the value in the next column C1 etc.
Thank u in advance.
Worksheet 1 column A has a list that I want to copy the values from A1 down to the last record and input each value into worksheet 2 twice including “_pass” for the first value and _Failed for the 2nd value starting at Column A1 and moving to the next column (B1) etc basically just creating headings on worksheet 2 from the list.
For example if the first value from the list on worksheet 1 is Math.
I want to take that Value and input it into worksheet 2 Cell A1 displaying Math_Pass and cell B1 displaying Math_Failed. Then move on to the next value in the list and do the same placing the value in the next column C1 etc.
Thank u in advance.
