Hi,
I am fairly new to VBA and survived until today by just copying and pasting codes from the internet. However, I can not seem to find an answer to what I need to do now as I think that it is too simple. Here it is: I have columns that include 15-digit alphanumeric characters (IDs) that differ as to how many rows. All I want to do is to copy the non blank cells in each column and paste them to a new sheet and in just a single column. So if there are 8 rows in Sheet 1, column A, 15 rows in column B and 6 rows in column C that are not blank, I need Sheet 2, Column A to list 29 IDs.
Also, I am just planning to formulate in Sheet 3 that in every 60 IDs in Sheet 2, Column A, a cell would concatenate the 60 IDs in a single cell and separate them by a comma. I know that this might be easy to do in VBA as well so if you may kindly assist when you're feeling a little generous. It's that season anyways.
Thanks a lot in advance!
Marc
Bookmarks