Forum Discussion

Rita2020

Copper Contributor

Mar 10, 2020

VBA code for specific import

Hello Everyone: I am painfully new to VBA and am trying to figure out how to import only specific items from an attendance template, into a new master that contains only the employee name and schedu...

Macros and VBA

Riny_van_Eekelen

Platinum Contributor

Mar 10, 2020

Rita2020 You mention that you "managed to combine all the files". May I assume that you thus have one large file (that you can change) with all employees' attendance in the layout that you gave in your example?

If so, and when your version of Excel recognises the FILTER function, there is an easy way to achieve this, without VBA.

On your combined file, move the content of cell A1 over to B1 and insert one cell in A1, shifting all cells in column A down one row. This will align the name with the scheduled hours. Then, in a new sheet you can created a few header rows, similar to above and enter the FILTER formula as shown. Sit back and see what happens. Have attached a file replicating your example. Now, let me know if this works for you or not.