I am wanted to import data from multiple workbooks on a shared drive to a master table. The master table has every column any workbook would have. The issue is that some of the workbooks do not contain all of the columns the master has. I just want to import the columns for those workbooks and leave the blank columns blank.
So workbook 1 would populate rows 1-20 and WB 2 would populate rows 20-60 etc.
Can anyone point me in the right direction for making this as easy as possible?
So workbook 1 would populate rows 1-20 and WB 2 would populate rows 20-60 etc.
Can anyone point me in the right direction for making this as easy as possible?
