Hi,
I'm trying to create one Worksheet that lists data from all other worksheets (not including itself). The problems I'm running into are, is there a way to make one final list and to automatically include future Worksheets that are created?
e.g.,
I will have Worksheet 1 and Worksheet 2. In a third worksheet, entitled Worksheet MAIN, for example, column C and D will populate all the non-blank data from Worksheet 1, A and B. All the data from the worksheets will be filled from top to bottom, meaning if there are 3 rows of data in columns A and B, it will be A1:B3. If 4 rows, then A1:B4, and so forth. Still in worksheet MAIN, C and D will then continue append to its list and populate all the non-blank data from Worksheet 2, A and B. That is the first problem, because the amount of non-blank data in each Worksheet may be different.
The second problem.
Is there any possible way, to already have a macro that will continue to populate Worksheet MAIN, C and D, with a new Worksheet (Worksheet 3, columns A and B) that's newly created for Worksheet 3, and so forth with future worksheets?
If this is impossible, please let me know.
Thanks in advanced!
I'm trying to create one Worksheet that lists data from all other worksheets (not including itself). The problems I'm running into are, is there a way to make one final list and to automatically include future Worksheets that are created?
e.g.,
I will have Worksheet 1 and Worksheet 2. In a third worksheet, entitled Worksheet MAIN, for example, column C and D will populate all the non-blank data from Worksheet 1, A and B. All the data from the worksheets will be filled from top to bottom, meaning if there are 3 rows of data in columns A and B, it will be A1:B3. If 4 rows, then A1:B4, and so forth. Still in worksheet MAIN, C and D will then continue append to its list and populate all the non-blank data from Worksheet 2, A and B. That is the first problem, because the amount of non-blank data in each Worksheet may be different.
The second problem.
Is there any possible way, to already have a macro that will continue to populate Worksheet MAIN, C and D, with a new Worksheet (Worksheet 3, columns A and B) that's newly created for Worksheet 3, and so forth with future worksheets?
If this is impossible, please let me know.
Thanks in advanced!
