Hi to anyone reading
So i need some help, i know what i need but don't know if the title explains it correctly
I need, i think, 2 different scripts to move data from one sheet to another, based of of variables located on the previous sheet, i have attached an example workbook with a description on each page for further reference. forum.ozgrid.com/index.php?attachment/73123/
So, there are 4 sheet altogether
Agent Data
Check Data
Breakdown
Reports
Agent data contains only names and a number value used for determine the number of checks to be done, the names provided will match the names on Check Data Sheet
Check data is the raw data (this is obtained from a different system and copied in, nothing needs to be done to assist this, good old manual copy and paste will be used.) that is checked
On the Check Data Sheet i would like a button activated VBA script that Once the button is pressed a random selection of of rows pulled from this sheet are copied on to the "Breakdown" sheet, if more than 10 checks are from one agent then 10% rounded up to the next whole number need to be copied to "Breakdown" Sheet, (however a max limit of 15 per agent), if less than 10 then any random row, the amount of randoms is already worked out on sheet "Agent Data" and the values need to come from there as some check codes are ignored while counting in row C on "Agent Data" Sheet.
Once the data is on the Breakdown sheet a manual audit is performed and Rows F to K are filled in. Once this has all been filled in a i would like a button for pressing this would copy rows F to K to the corresponding agent data to the correct report headed by that agents name on "Reports" sheet.
Sounds complicated, am may very well be, if this is a big job then please tell me.
Thank you in advance