Hi,
May I know how to write a code to automatically filter each component types (C type, P type) available in my data, copy paste to their respective sheet and arrange according to their component names (C-100, C-10, etc)?
<tbody>
Component
Amount
C-100
4
C-10
5
P-150
7
C-100
3...