
Active Member

January 27, 2021

Hello
I'm not a big excel user and only use basic functions for the most part and I was hoping to get some advice on using excel to a data input table which uses the input data to populate 2 different tables. For example, I work in safety and many of my team members carry out safety audits on a number of different people in different regions. I would like to create 2 tables. One showing who has been audited and on what day of what month. Another showing how many audits each auditor has done in each month and if they have hit their audit targets.
I was hoping these tables could be populated by entering the data in one table by completing drop down options and hitting a "GO" tab to update the tables with the inputted data. Is this possible to do in excel? (pretty sure it is somehow) and is it a simple or complicated process? Can anyone point me in the right direction as to where I can find out how to do this?
Help is much appreciated
Alan


Trusted Members

December 20, 2019


VIP

Trusted Members

December 7, 2016

Hello,
Search the blog section in this site and you will find some good articles, links below to two of them.
https://www.myonlinetraininghu.....xcel-forms
https://www.myonlinetraininghu.....xcel-forms
Br,
Anders

Answers Post
1 Guest(s)
