Hi,
Is it possible to link a whole worksheet of an excel file with a new file. I maintain 2 sheets for yearly audit & monthly audit. in one sheet there are 12 tabs Jan till December (I maintain 20 files for 20 employees) and in the another sheet to checkout there performance i maintain a sheet with 20 tabs for each employee. In month end i need to send the compiled sheet to my senior.
currently i copy & paste the sheet of each employee for each month to the monthly audit sheet which is very much time consuming.
Please help, if there is any other way to do this task?