Hello there,

I have a requirement to copy specific columns from 2 different excels to a new excel.

One of my excel is stored to Shared Drive and the other excel is stored to SharePoint.

In both excel there are certain columns which are similar i.e. Project No, Project Name, Project Budget, Project Status and Project Region are the columns available in both the excels. But the columns are not aligned properly in both the excels. For e.g. In first excel Project Name could be in column D, whereas in 2nd excel the Project Name column could be in column Z.

So what I require - I'll have a Master file to my desktop, in which only above said columns will be available.

I want to run a Macro on daily basis or on manual basis, to fetch the data from both the files and paste to my Master file

For e.g. in 1st excel, there is a data till row 1200, so first macro will paste the data to Master file till row 1200 and from 2nd excel, the data to be pasted after row 1200.

Appreciate your help!