I have 35 files with data in 14 columns of data I want to merge into one file with a macro. The goal is to run the macro and pull any data in the 14 columns into a specified destination without any blank rows. Another way of stating it is the macro should only create a row if data exist in the subsidary file.
Currently each subsidary file has 100 rows, but could grow to a max of 300. Thanks.
Bookmarks