Hi,
I have a workbook with three worksheets "Dairy", "Milk" and "Cream". Ranges in each work sheet is
Dairy: A2:BO last row with data
Milk: A5:BO last row with data
Cream: A5:Y last row with data
I am trying to combine 3 worksheets copy paste under sheet "Farm".
I would like to copy the Dairy Range first, then copy Milk range below last row of Dairy Range and copy Cream range under last row of Milk Range. Is this possible to do with VBA. Appreciate any help. Thanks
I have a workbook with three worksheets "Dairy", "Milk" and "Cream". Ranges in each work sheet is
Dairy: A2:BO last row with data
Milk: A5:BO last row with data
Cream: A5:Y last row with data
I am trying to combine 3 worksheets copy paste under sheet "Farm".
I would like to copy the Dairy Range first, then copy Milk range below last row of Dairy Range and copy Cream range under last row of Milk Range. Is this possible to do with VBA. Appreciate any help. Thanks