Hi all,
I would like to consolidate the following data ranges using VBA.
1. copy range H4:J(last row) of all sheets from Jan-19 to the last sheets. Number of worksheets may be more than 12. All datas copied will be stored on sheet(P-List) and remove duplicate based on SKU ID column. (see sample P-List-result)
2. copy range K3:K(last column) of all sheets from Jan-19 to the last sheets. All datas copied will stored on sheet(A-List), transpose and then remove duplicate.
Is it possible the sheets to be copied from are not name specific?
Thank you in advance.
I would like to consolidate the following data ranges using VBA.
1. copy range H4:J(last row) of all sheets from Jan-19 to the last sheets. Number of worksheets may be more than 12. All datas copied will be stored on sheet(P-List) and remove duplicate based on SKU ID column. (see sample P-List-result)
2. copy range K3:K(last column) of all sheets from Jan-19 to the last sheets. All datas copied will stored on sheet(A-List), transpose and then remove duplicate.
Is it possible the sheets to be copied from are not name specific?
Thank you in advance.