Hi...I have 5 daily (mon-Fri) sheets on 1 workbook that contain jobs for multiple departments that I do work for. There are 10 available rows in each department that are filled in each day for different departments. The amount of rows used depend on the number of jobs each day..ie Mon might have 3 lines used , Tues might have 5 , etc.
At the end of the week , I copy the rows used from each day into a master spreadsheet that just lists all jobs done for the week for each dept. and calculates the total costs
What I would like to be able to do is to is to have a macro that would copy the rows from each day that contain data and paste them into my summary sheet without having to copy & paste manually.
Not sure how to go about this , so any ideas would be greatly appreciated.::
Bookmarks