I want to concatenate 4 tables having the same structure, but located in different directories. What will change is the number of row to be imported (per month) and the contents of columns. How can this be implemented in VBA?
Sheets("sheet to be copied").Select
'selection of the data field
Range(Selection, Selection.End(xlToRight)).Select 'select to the left
Range(Selection, Selection.End(xlDown)).Select ' select downward
Selection.Copy 'copy selection