In the attached workbook there are three named ranges in cells D7 G7 H7. I am going to combine multiple workbooks in a folder. Each file will have these named ranges.
When i combine the workbooks I want to be able to put each of these 3 values into a column of its own.
How do i do this?
Book3.xlsm (12.3 KB)