Hello everyone,
I was hoping to get some help to solving below.
We have 2 workbooks namely 1.PR (Contains sheet1, sheet2 and so on……) and 2. T log (Contains sheet1, sheet2 and so on……).
I was hoping to get some help to solving below.
We have 2 workbooks namely 1.PR (Contains sheet1, sheet2 and so on……) and 2. T log (Contains sheet1, sheet2 and so on……).
- From T log sheet Column K end row data Need to add in PR sheet A column last row
- Condition: Sometimes the dates are not changing on daily basis.
- From T log sheet Column B end row data Need to add in PR sheet H column last row
- A. From T log sheet Column K data repeat 2 times (Colored in Orange)
- Conditions:
- pick the data from column E row data (Colored in Green) and add in PR sheet O column
- condition: above point 1 starts in same row O column need to add
- pick the data from column F row data (Colored in Grey) and add in PR sheet P column
- condition: above point 1 starts in same row O column need to add
- B. From T log sheet Column K data repeat 4 times (Colored in Blue)
- Conditions:
- pick the data from column E row data and add in PR sheet O column
- condition: above point 1 starts in same row O column need to add
- pick the data from column F row data and add in PR sheet P column
- condition: above point 1 starts in same row O column need to add
- A. From T log sheet Column K data repeat 2 times (Colored in Orange)
- Conditions:
- pick the data from column B row data (Colored in Pink) and add in PR sheet I column
- condition: above point 1 starts in same row I column need to add
- pick the data from column B row data (Colored in Pink) and add in PR sheet J column
- condition: above point 1 starts in same row J column need to add
- B. From T log sheet Column K data repeat 4 times (Colored in Black)
- Conditions:
- pick the data from column B row data and add in PR sheet I column
- condition: above point 1 starts in same row I column need to add
- pick the data from column B row data and add in PR sheet J column
- condition: above point 1 starts in same row J column need to add
- From PR sheet Column J end row data Need to add in same sheet N column last row
Attachments
Last edited: