Hi,
I have a lot of Data from many Sheets and I would like to use VBA to auto consolidate the latest Month Data into one Summary Sheet.
Below are some sample data:
<tbody>
Sheet1
May-17
Jun-17
Jul-17
Aug-17
Sep-17
PARTs
Tatal Quantity
price
Tatal Quantity
price
Tatal Quantity
price
Tatal...