I have 2 sheets names "Ref1" and "WFMS-Dump" in "Ref1" sheet ther eis a list of header names from H2 till the last non blank cell, and with respect to the same headers need to be shifted or reaggnaged in sheet WFMS.
er:- if H2 in Ref sheet header name is in row no 2, then it should search the row 2 header name in sheet WFMS and after found sound be cut and placed in A:A in same sheet WFMS and loop till tbe last non blank cell of column H in Ref sheet.
I hoep I am clear.
this is in Ref sheet H2 till the last non blank cell
er:- if H2 in Ref sheet header name is in row no 2, then it should search the row 2 header name in sheet WFMS and after found sound be cut and placed in A:A in same sheet WFMS and loop till tbe last non blank cell of column H in Ref sheet.
I hoep I am clear.
this is in Ref sheet H2 till the last non blank cell
Sr.NO | Column Header | Rearrange to Column |
1 | INCIDENT_NUMBER | A |
2 | INCIDENT_ID | B |
3 | CUSTOMER_TICKET_NUMBER | C |
4 | RTTS_TICKET_NUMBER | D |
5 | PROJECT_NUMBER | E |
6 | TASK_NUMBER | F |
7 | SEVERITY | G |
8 | CREATED_BY | H |
9 | PP_Dept | I |
10 | FAULT_REPORTED_TYPE | J |
11 | NETWORK | K |
12 | TECHNOLOGY | L |
13 | INCIDENT_TYPE_NAME | M |
14 | Fault_Area | N |
15 | Fault_Sub_Area | O |
16 | INCIDENT_CREATION_DATE | P |
17 | INCIDENT_LAST_UPDATE_DATE | Q |
18 | CLOSE_DATE | R |
19 | INCIDENT_STATUS_NAME | S |
20 | TASK_TYPE_NAME | T |
21 | PP_Task_Reverse_Index_ByTaskID | U |
22 | TASK_CREATION_DATE | V |
23 | TASK_LAST_UPDATE_DATE | W |
24 | ACTUAL_START_DATE | X |
25 | ACTUAL_END_DATE | Y |
26 | TASK_STATUS_NAME | Z |
27 | ORGANIZATION_NAME | AA |
28 | LC_NO_SLOT | AB |
29 | WC_NAME | AC |
30 | CS_RESOLUTION_CODE | AD |
31 | RESOLUTION_CODE | AE |
32 | REASON_CODE | AF |
33 | CANCEL_REASON_CODE | AG |
34 | COMPLAINT_OPEN_REASON | AH |
35 | LAST_DEACTIVATION_REASON | AI |
36 | Deactivate_Reason | AJ |
37 | PROBLEM_CODE | AK |