How can I combine multiple excel files into a single master file and have a button that can select the file that I want? The button will have many levels as the files are categorised

Hi,

Watch this video to learn how to consolidate data from multiple files - https://www.youtube.com/watch?v=yL11ugShdrk

When it comes to selecting a specific file for printing, importing the data is, in my view, not a viable option.

"Print a file" can mean many things; a single file may contain multiple sheets, each with its own individual print settings. We can not import the layout (column widths, font sizes, colors, etc. from all the cells) and the print settings from a file.

One possibility would be a type of file manager, an Excel file that provides a list of all files across all folders, which could then be sorted by date or other criteria. We could include a link that an employee could click to open the corresponding file.

Andreas.

I think, the best thing to do is to use Excel's built-in Power Query and Slicers. It creates clean navigation buttons without breaking a sweat.

Here is the quick setup:

• Merge everything: Go to Data > Get Data > From File > From Folder. Point it at your main shared drive folder and hit Combine & Transform. Excel will automatically dig through all the subfolders and pull the data into one master sheet.

• Make the buttons: Click anywhere inside your new master table, head up to the Table Design tab, and click Insert Slicer.

• Set the levels: Check the boxes for Folder Path and File Name. This drops clickable buttons right onto your sheet. Your employee can click a folder level, see the filtered files, and print immediately.