Good morning everyone. I need your evaluate support to get the following using a VBA function if possible:
I have the following table (Table1):
MaintItem M1 M2 M3 12345678 10 2 12345679 2 10 11223344 2 2 2
and i would like to add the records in the following Table2:
MaintItem Freq HRS 12345678 M1 10 12345678 M2 2 12345678 M3 12345679 M1 2 12345679 M2 12345679 M3 10 11223344 M1 2 11223344
11223344M2
M32
2
For each frequency (M1,M2,M3) of the MaintItem in Table1 i would like to have a record in the Table2 with the indication of the HRS.
Hope it is clear.
Thanks in advance for any suggestion.
LM