Hi, I need some help. I am trying to create some way (probably a button with a macro) to basically fill in certain fields of a sheet with the click of a button.
In my file you will see that the first sheet has names and other info on students. The second sheet has a form I created that has certain fields. What I want to be able to do is to click a button beside a students name if they get in trouble so that it will automatically fill in their name (column B and C), ID# (column E), and grade (column F) from the Names sheet into the proper cells on the Form sheet (name goes into D4, ID# goes into cell F4, and grade goes into cell D5). That will just be a time saver and then I can print the form and fill out any additional info later.
I also often sort and re-sort names on this list and the names on the list grows and shrinks as students move in and out of the class. I need the button to still work - copying all the correct info with each name each time.
Can anyone help with this? My mind if fried and I am not really a programmer or anything. I appreciate any help offered. I am using Excel 2011 for Mac but also have Excel 2010 for PC if needed.
myfile.xlsx
Bookmarks