Workbook 1, Sheet1 is with data in four columns - A, C, E and G. Each of columns has a header in row 7, then data that goes down from row 8. The number of data points in each row does vary.
Workbook 2 has a Sheet2. Starting at A8, we want to create a list in Sheet2 that contains all the data from each of the four columns in Workbook 1, Sheet 1.
So Cell A8 in Workbook 2, Sheet 2, will start with the data from A8 in Workbook 1, Sheet 1 and go down however many rows there is data points. Then the data from Workbook 1, Sheet 1, C8 downwards will be appeneded to that etc.
Is there macro commands that could do this?
Workbook 2 has a Sheet2. Starting at A8, we want to create a list in Sheet2 that contains all the data from each of the four columns in Workbook 1, Sheet 1.
So Cell A8 in Workbook 2, Sheet 2, will start with the data from A8 in Workbook 1, Sheet 1 and go down however many rows there is data points. Then the data from Workbook 1, Sheet 1, C8 downwards will be appeneded to that etc.
Is there macro commands that could do this?
