mohdamir1989
New Member
- Joined
- Oct 17, 2017
- Messages
- 42
Hi
I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column.
I need it all in a different format which I need to grab with single validated list.
Any possibilities??
Sheet 1 Format
<tbody>
</tbody>
Data to be processed at Sheet 2
<tbody>
</tbody>
Only to pick available information upon Month change.
Best Regards
I am trying to pull data from other sheet based on single cell (Month) reference. Just like a list in one cell. Sheet 1 contains multiple entries segregated with month column.
I need it all in a different format which I need to grab with single validated list.
Any possibilities??
Sheet 1 Format
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Data to be processed at Sheet 2
S.No | Complaint# | Order No | Date | Shop Name | Asset code | Fault& Ramedy | Part Change Name | Level | Territory | Amount | Remarks | Agency | Complaint Fwd Date | Closing Date | Total Days | Total Hours | Manual Level | Month | Jan |
<tbody>
</tbody>
Only to pick available information upon Month change.
Best Regards