Code for Random 10% Audit of Department

I have an excel document – Application Log Rev1 within this document I have 7 tabs.

Tabs 1 – 5 are departments with information

Tab 6 is Level 1 management audit – Basically a manager needs to extract a random 10% of each department and copy the data, I’m assuming it’s like a VLookup but a little more in depth, because I want the macro to randomly select the data.

Tab 7 is level 2 management audit – Basically a higher up manager is looking at the level 1 managers work to audit him. Level 2 needs to extract a random 10% from Tab 6 etc.

I am confident this can be done with excel as I know it’s super powerful. However, my problem is I have absolutely no clue when it comes to VBA’s Macro’s. I also think what I am asking for is quite complex.

Can anyone please help me. I’ve attached an example of the document I am using if it helps. Oh god I could cry right now!

Welcome to the forum.

There is no document attached, that's the first thing.

Secondly, is your profile up-to-date?

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I will do it for you this time.)

Your profile was created in 2014, hence my question. So, you are still using Excel 2000 - yes?

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. I will provide the link for you this time: https://www.mrexcel.com/board/thread...-tabs.1209790/)