Home

Linking Template to a running list.

%3CLINGO-SUB%20id%3D%22lingo-sub-633400%22%20slang%3D%22en-US%22%3ELinking%20Template%20to%20a%20running%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633400%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone.%20I%20am%20currently%20trying%20to%20take%20a%20template%20that%20I%20have%20which%20is%20used%20to%20collect%20data%20from%20individual%20employees%20in%20order%20to%20assign%20assets%20to%20them.%20I%20am%20wanting%20to%20connect%20this%20file%20to%20another%20sheet%20that%20creates%20a%20running%20list%20of%20info%20filled%20out%20every%20time.%20The%20issue%20I%20am%20having%20is%20that%20every-time%20the%20info%20is%20filled%20out%20it%20changes%20the%20info%20already%20in%20the%20other%20document.%20Is%20there%20a%20way%20for%20me%20to%20use%20VBA%20or%20Macros%20in%20order%20to%20allow%20that%20each%20time%20the%20form%20is%20filled%20out%20it%20creates%20new%20lines%20with%20that%20information%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20makes%20sense%20let%20me%20know%20if%20you%20need%20clarifications.%20Appreciate%20all%20the%20help%20I%20can%20get.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F115665iD549746798F60D15%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Equipment%20Form.PNG%22%20title%3D%22Equipment%20Form.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633897%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20Template%20to%20a%20running%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633897%22%20slang%3D%22en-US%22%3EI%20suggest%20you%20attach%20your%20sample%20file%20with%20sample%20data%20and%20desired%20results.%20I%20believe%20built-in%20formulas%20can%20achieve%20your%20desired%20results.%20VBA%20must%20be%20the%20last%20resort%2C%20not%20the%20default%3B%20otherwise%2C%20Microsoft%20would%20have%20not%20consistently%20added%20new%20built-in%20functions%20for%20each%20version%20if%20VBA%20would%20still%20be%20the%20default%20solution!%3C%2FLINGO-BODY%3E
natethegreat
Visitor

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!
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies