Hi,
I would like to combine the same column (D) from multiple worksheets into one column. I tried the consolidation function and lookup functions but couldn't figure it out.
Every worksheets represents a month, and some of the codes in each column are listed more than once. If possible, I would also like to get rid of the duplicates (if possible already in the function not the manual formatting) and also the blanket cells.
I attached a sample workbook to illustrate the problem.
If possible, I would also like to sum up the volume for each month of each code.
Appreciate any help.
Thanks.
Bookmarks