Hi everyone,
I have a data model where I have one table that is used to provide source information for one of our researchers who sends out a family survey. Currently, the primary table is pulled down from power query and is a merging of three source tables. I have merged her existing dates into a customized power query table. However, she needs to be able to manually input her survey dates on a daily basis. She is not familiar with power query and is extremely resistant to entering data in one table and then having it transfer to the larger table. Is there a way to allow her to manually enter the data but still have an updated power query table as the foundation of it? The power query table is constantly updating information and adding new clients. She will need to be able to still sort the table by any of the column headers, including all of the dates. I have attached a sample worksheet as an example.
Thanks in advance!
Lou
Bookmarks