I have a function that transfers the values in certain
cells to a new worksheet. I recieve around 10 of these
identical layout, but separate files each day. Is there a
way to apply the function to all the excel files instead
of having to write the code for each separate file? any
help would be great. thanks, mate.