Hi All,
I have a VBA code that allows me to select various files from different file locations from different years and almost helps to create a timeseries table. However i have the following issue:
a)I would like to implement a list box that allows me to select the years i would like to copy over from a listbox
b)Also sometimes it misses out the years and causes a gap in the data, not sure because there maybe an extra gap in the file name or unknown character that isn't allowing it to be picked up
i have a copy of the excel sheet stored in the above link if that helps.
Would welcome your thoughts and insight
Thanks
I have a VBA code that allows me to select various files from different file locations from different years and almost helps to create a timeseries table. However i have the following issue:
a)I would like to implement a list box that allows me to select the years i would like to copy over from a listbox
b)Also sometimes it misses out the years and causes a gap in the data, not sure because there maybe an extra gap in the file name or unknown character that isn't allowing it to be picked up
Create Time Series.xlsm
drive.google.com
i have a copy of the excel sheet stored in the above link if that helps.
Would welcome your thoughts and insight
Thanks