IS THERE A WAY TO SEARCH FOR AND CALCULATE MULTIPLE EXCEL FILES?
IF GOT MULTIPLE WEEKLY TIME SHEETS IN A FILE ON A SERVER AND NEED TO BE ABLE
TO RUN A SEARH FOR THE ACTIVE WEEK AND PREVIOS WEEK AND CALCULATE TIME FOR
EACH EMPLOYEE BY NAME OR ID #. EACH TIME SHEET HAS 7 TABS 1 FOR EACH DAY OF
THE WEEK. IS THIS POSSIBLE WITH THE USE OF MACROS OR FORMULAS?
--
THANKS
BRIAN
|