thedeadzeds
New member
- Joined
- Oct 25, 2011
- Messages
- 37
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi All,
Just wondering if this is possible. I have a spreadsheet, attached which I would like to do the following with.
If the customer concern column in ‘Step 2 sheet’ shows ‘alleged’ or ‘found’
Then
1 - In the ‘Defend Ltr sheet’, automatically populate the ‘Complaint Point column C10 to C39’ with the relevant text in the ‘Statement’ column in the ‘step 2’ TAB. For example, C10 in the Defend Ltr tab would equal C6 from the Step 2 tab.
2 - In the ‘Defend Ltr sheet’, automatically populate the ‘Category column o10 to o39’ with the relevant text in the ‘Category’ column in the ‘step 2’ TAB. For example, o10 in the Defend Ltr tab would equal b6 from the Step 2 tab.
So I would envisage the ‘Defend Ltr tab’ looking like this the completed information in the Defend Ltr tab:
Hope this makes sense.
Thanks
Craig.
Just wondering if this is possible. I have a spreadsheet, attached which I would like to do the following with.
If the customer concern column in ‘Step 2 sheet’ shows ‘alleged’ or ‘found’
Then
1 - In the ‘Defend Ltr sheet’, automatically populate the ‘Complaint Point column C10 to C39’ with the relevant text in the ‘Statement’ column in the ‘step 2’ TAB. For example, C10 in the Defend Ltr tab would equal C6 from the Step 2 tab.
2 - In the ‘Defend Ltr sheet’, automatically populate the ‘Category column o10 to o39’ with the relevant text in the ‘Category’ column in the ‘step 2’ TAB. For example, o10 in the Defend Ltr tab would equal b6 from the Step 2 tab.
So I would envisage the ‘Defend Ltr tab’ looking like this the completed information in the Defend Ltr tab:
Hope this makes sense.
Thanks
Craig.