Hi,
I have a different excel workbooks with name ProjectResourceReport-A,ProjectResourceReport-B,ProjectResourceReport-C,ProjectResourceReport-D likewise till ProjectResourceReport-Z.
I want to make a macro to make a consolidated report.
Each time I make a new excel workbook ProjectResourceReport-All and copy past all cells from each workbooks.
the columns in the workbooks are
i want this
1.JPG
from
these workbooks
2.JPG3.JPG
Thanks.