When you start with the code, It is through the Button on a Sheet called "DATA INPUT FORMS" which is the Active Worksheet at that moment until another Sheet is made active.
So all code that refers to specific sheets, other than the active Sheet which in this case is "DATA INPUT FORMS", need the name of the Sheet in it.
Now if you would leave the periods out like so
it will again refer to the active Sheet.
A good way of testing is to have a Sheet with data in Column A to let's say A25 and in another Sheet with data in Colunn A to A10.
If the data to A25 is called Sheet1 and the data to A10 is called Sheet2 you could run a trial code from Sheet1 like
See what your result is
Now put the periods in place and run it again from Sheet1
Make sure all the references, Sheets, Ranges, Names etc are proper.
See if there are any errors after referencing everything properly.
In the original attachments, week and a half ago, the "continuation" Button was to have information for existing students appended.
Not any more?
Bookmarks