Dear All,
I have 2 workbooks, one source workbook with data spread on different sheets and one other workbook where the data needs to be copied to with one working sheet.
The data from the different sheets from the source workbook need to copied below each other on to the single sheet on the other workbook.
The copying of the data is based on a criteria which is the name of the workbook and based on this criteria a copy method of choice should be utilized.
(The copy method is a specific order of columns to be copied from the source to the working sheet.) There are 3 different copy methods based on the name of the sheets of the source workbook.
For example I have a source workbook with sheets which are types of fruits, vegetables and legumes (please see snip here below).
The data from these sheets needs to be copied to the working sheet based on their category (fruits, vegetables or legumes) and each category has its own copying method.
Does anyone have a good approach for this?
Source Workbook:
Working Sheet
Thank you in advance.
I have 2 workbooks, one source workbook with data spread on different sheets and one other workbook where the data needs to be copied to with one working sheet.
The data from the different sheets from the source workbook need to copied below each other on to the single sheet on the other workbook.
The copying of the data is based on a criteria which is the name of the workbook and based on this criteria a copy method of choice should be utilized.
(The copy method is a specific order of columns to be copied from the source to the working sheet.) There are 3 different copy methods based on the name of the sheets of the source workbook.
For example I have a source workbook with sheets which are types of fruits, vegetables and legumes (please see snip here below).
The data from these sheets needs to be copied to the working sheet based on their category (fruits, vegetables or legumes) and each category has its own copying method.
Does anyone have a good approach for this?
Source Workbook:
Working Sheet
Thank you in advance.