Linking Template to a running list.

Copper Contributor

Hello everyone. I am currently trying to take a template that I have which is used to collect data from individual employees in order to assign assets to them. I am wanting to connect this file to another sheet that creates a running list of info filled out every time. The issue I am having is that every-time the info is filled out it changes the info already in the other document. Is there a way for me to use VBA or Macros in order to allow that each time the form is filled out it creates new lines with that information? 

 

Hope this makes sense let me know if you need clarifications. Appreciate all the help I can get.Equipment Form.PNG

1 Reply
I suggest you attach your sample file with sample data and desired results. I believe built-in formulas can achieve your desired results. VBA must be the last resort, not the default; otherwise, Microsoft would have not consistently added new built-in functions for each version if VBA would still be the default solution!