Hello,
I am pretty new at VBA and trying to create a simple macro to copy rows of data from multiple excel workbooks and paste them in another excel file in certain columns. The files where the data needs to be extracted from are all the same format however their names and locations can be different from day to day so I would want the user to be able to select the files to import. The data that needs to be copied is found in columns A, B and F of each import file, starting at row 5 but with an indefinite number of total rows. These need to be extracted and pasted on the main macro file, in the second tab in columns A, D and W.
Any guidance would be much appreciated
I am pretty new at VBA and trying to create a simple macro to copy rows of data from multiple excel workbooks and paste them in another excel file in certain columns. The files where the data needs to be extracted from are all the same format however their names and locations can be different from day to day so I would want the user to be able to select the files to import. The data that needs to be copied is found in columns A, B and F of each import file, starting at row 5 but with an indefinite number of total rows. These need to be extracted and pasted on the main macro file, in the second tab in columns A, D and W.
Any guidance would be much appreciated