Sorry I was out of town and couldn't get along with you.
Ok , listed down are the criteria and ways how i need the rows copied.
1. "Yesterday" would be "trade date" i.e Mon - Fri. It is ok if we come across any holidays.
2. Each piece of "yesterday's work" work would consist of an entire row ex. A2 to K2. and each piece of work would have a date updated to it.
3.Range should be always the data of "yesterdays work".
4. Each member's work is identified in the sheet under CW (May be Column K or L ) for each sheet and work book. that if I have done the work, my name will be under the column K or L or any other column. We dont have to track it as you asked because it is already in the tracker.
Now, I will describe how we do it manually. May be you can get an idea from it apart from the above.
We have a folder named for example Global. There are 5 Workbooks in it for tracking each members' daily process/work. Now what I do is I create a new excel workbook in desktop with the same format as in the folder.Lets say it is the Master QC tracker. Now I open any of the Workbook (say Mine) in the folder.I have 5 sheets inside the workbook viz Rec, Fup, IC, IC1 and IC2. Yesterday I might have done 60 Rec, 9 Fup, 20 IC, 30 iC1, and 30 IC2.
I filter by yesterdays date.
copy 10% of each transaction from yesterdays work i.e 6 Rec, 1 FUP ( Atleast 1 if total fup is below 10 ), 2 IC, 3 IC1 and 3 IC2.
Paste the data one by one to the respective sheets of the workbook in the desktop..
message edited by RobinMicheal