I am unfamiliar with VBA however the language seems easier to read than to write. I am familiar with other aspects of Excel.
I have medium size sets of data. They have different properties including alpha, integer, date, etc..
I would like to set up a macro to search through the data dump based on criteria asked of me specific to a row and return a random list of entire rows that is approximately 10% of total rows where the criteria matches up with what I have specified.
Site Building Room Tag 100-Emerson Court A A101 SS102058 100-Emerson Court A A115 SS107052 100-Emerson Court A A123 SS104800 100-Emerson Court B B117 1000875 102-Capitol_School Cafeteria 128 800187
So if I choose the site to be "100-Emerson_Court" and there are 400 rows with "100-Emerson_Court" in column A, in a separate sheet called "audit", it will transpose a random 10% or 40 of the rows.
I am unsure if there is information I am accidentally omitting. Ask and I will try to answer as well as I know
Bookmarks