Hello VBA Guru's
I am working on a project that is way over my head atm. I will attach the file below.
Basically I want the Red "Enter Score" button to post the Score Results located in K30 into the correct cell, of the sheet that matches the criteria set on the "Quick_Test" Sheet. Quick_Test!M7 needs to be matched up with B2 in 11 possible sheets named Subject1 thru Subject11.
Once the correct Sheet is located, then the criteria set in Quick_Test should decide where the contents of Quick_Test!K30 should be pasted. And the contents of Quick_Test!K30 are formatted as a Percentage, but they need to be pasted into the Subject Sheets as a Number. So 90% should be pasted as 90, not as .9
Any help is greatly appreciated!
Quick_Test.xlsm
Bookmarks