I currently many columns of data that I want in one single column and am trying to automate the process with a macro.
I don't want to combine/consolidate the data. I want to copy the data from Col B and place it under the last cell of data in Col A, then copy the data from Col C and place it under the last cell of data Col A (which now also has the original Col B data underneath the original Col A data), then from Col D to Col A, etc... until all of the data is in Col A.
The length of each column will be changing on a daily basis, i.e. each column will have a different # of rows.
Does anyone know of way to make this happen?
Any help is greatly appreciated!
Thanks,
Greg
I don't want to combine/consolidate the data. I want to copy the data from Col B and place it under the last cell of data in Col A, then copy the data from Col C and place it under the last cell of data Col A (which now also has the original Col B data underneath the original Col A data), then from Col D to Col A, etc... until all of the data is in Col A.
The length of each column will be changing on a daily basis, i.e. each column will have a different # of rows.
Does anyone know of way to make this happen?
Any help is greatly appreciated!
Thanks,
Greg