I have a series of spreadsheets, one for each month, from the past several years. I want to bring the annual data from these different sheets all together to one worksheet. I realize that putting all of the years into one workbook would crash my computer. So, annual is fine.
However, there are different lengths in each column. Some go from 1 to 100, some go from 1 to 1000. I REALLY don't want to go through and manually copy each month onto the master sheet.
I am trying to figure out how to copy a range of cells referentially, but nothing seems to work. I can use "xlDown", then "xlRight". It's fine if the column to the right is shorter than the current column.
This is mind boggling!
Here is a sample:Sample Numbers.xlsx
Bookmarks