I have a process where I receive new workbooks each day (anywhere from 1 to 4) and they are all housed in a folder. I want to be able to store all of this information within a single master file for analysis purposes. The individual files always contain the same number of columns and a single header row, but the number of rows of data will vary. I would like to be able to select from the master file which individual files I want to import and append the full data set, but without importing the header row each time. I am new to VB and macros, so any and all help is much appreciated.
Thank you in advance!!
Bookmarks