+ Reply to Thread
Results 1 to 1 of 1

Adding manual data entry columns to Power Query table

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    27

    Question Adding manual data entry columns to Power Query table

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query - Manual data entry to some columns
    By kehong216 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2021, 02:53 AM
  2. Adding columns to power query
    By JyothiGrace in forum Excel General
    Replies: 4
    Last Post: 01-26-2021, 02:11 AM
  3. Power Query Automation that include manual entry
    By coltan123 in forum Excel General
    Replies: 0
    Last Post: 09-10-2020, 05:07 AM
  4. Replies: 0
    Last Post: 09-26-2019, 10:36 AM
  5. Power Query SQL (Source) run with manual table parameter?
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2019, 09:03 PM
  6. [SOLVED] Adding manual data to a power query?
    By S7ewie in forum Excel General
    Replies: 20
    Last Post: 01-19-2019, 08:44 AM
  7. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1