Thank you Mumps, it works great. thank you once again
The files are in different folder & the master in a different.
All the data in the files are stored in sheet 1 & i want the entire sheet data to be placed in sheet 1 of master files, but i don't want the data to be overlapped with the others.
the data from the source file should be placed as values in the master excel.
Thank you for your time
i want some help with VBA code.
i have few workbooks & want to move the data from the different workbooks into one master file.
the files are in different location & all have the same headers.
i want to be able to copy the data & paste into the master without overlapping into the other data & also do a paste special while pasting it into the master file.
Thank you for the assistants.
Thank you nbvc.
Need you'r help with grouping.
in Sheet2 i have few data that needs to be grouped depending on the criteria in Sheet1 & give the count for the grouped data in the table.
just a sample data in the excel but the real data would be lot more.
Thank you for the help.
Thank you its working great.
I am sorry, i din get the part "and now use this formula to get the one's not in the 5%".
where do you want me to use the formula
Ok thank you for the help.
let me explain the full steps.
the accounts will be place in the Daily Production tab, then from their it will pick % of the data depending on the target into the status tab.
then from the status tab depending on the target it will display accounts in the production tab.
then it would randomly put accounts into the Quality tab.
but when the accounts are displayed from the status tab to the production tab it displays even the blank. So the quality tab also picks up the blanks.
will it be picking only the first 5%, & not randomly
Could you let me know how to increase the the Numbers from first 5% to 25%.
thank you in advance.
The thing is i want the production tab to automatically pull accounts from the status tab without any blanks.
So the final output in the quality tab wont have any blanks in it.
the accounts it pulls from the status tab has a criteria of pulling accounts depending on the first table of the target tab.
i need help with getting the executed values from a formula to display in the production sheet without any blanks.
i needs the non-blanks from the status tab to display in the production tab.
thanks for your help in advance.
Thank you, its working great
yes that would be great
to be precise 5% of the total accounts worked by the user
let me try & explain the exact steps
i want the accounts in production sheet to automatically appear in the sheet1 depending on the sheet2 target.
Sheet1 should be able to contain the users & their account depending on their target.
Production Sheet contains lots of headers, but i want it to display the exact info thats needed on sheet1
Thank you in advance
I need help with my project,
i would want to automatically pick accounts from a a huge list of data & display it to another page depending on the criteria.
the criteria would depend on the # of accounts done by the personA, i would need 5% of the accounts in sheet2