hi everyone. Do you have any idea how to create an excel master list. like for example; on the first sheet it will be the number of enrolees, lets say there are only (12) total enrolees. On the second sheet it will be the names of enrolees. So, i will be adding names/enrolees on the second sheet then, the first sheet will automatically increase to (13). do you have any idea? Do you have any format?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
excel master list creation help
0
Post Edited
Title: Title was not descriptive.
Discussion
Please do amend your question to give it a meaningful title, lol:
Variatus (rep: 4889) Nov 16, '17 at 9:34 pm
Answers
0
It seems that you are visualising the second sheet as a kind of entry form where you enter the names, have them transferred to Sheet1, and clear Sheet2 for the next entry. If this is what you want you will need to use (learn?) VBA..
However, if you intend to use Sheet2 as an entry form the question must be asked why you don't use a real entry form. VBA allows you to create a custom user form which is much more attractive than anything you might create using a spreadsheet instead.
0
Since it seems like your are not entirely sure how this should funciton, I will give you a basic solution; use cell linking!
On the first sheet go to where you want the names to be and select the first cell and type = and then go to the second sheet and select the cell that will contain the name and hit Enter. Then, go back to the cell where you just entered that formula and click the bottom-right part of the cell and drag it down to copy the formula to all cells where you want the names to be pulled-in.
0
Cell linking will do and a easiest way. Try it and if required use count if function for calculation the employees.