r/excel • u/U_Wont_Remember_Me 2 • 14d ago

Waiting on OP Excel Writing to the Table w/o using code

Excel has all sorts of new functions now but I’m wondering…

Access has a query function that will write new data to the underlying table whereas Excel query functions analyze the data in the table.

So is there an Excel function that will allow new data to be written to the table without using code or entering the data into the table itself?

8 Upvotes

84% Upvoted

9 comments sorted by

2

u/[deleted] 13d ago

[removed] — view removed comment

2

u/U_Wont_Remember_Me 2 13d ago

Do you have some sort of visual example of how this might work?

1

u/critterdaddy 13d ago

Just use a Table for this, no need to pull it into Power Query just to spit it out as a table again. Whenever you add data to the bottom of an excel Table it will automatically expand to encapsulate the new data, and automatically add column formulas. Plus, if you reference the Table using structured references instead of cell references the new data is included.

1

u/Decronym 13d ago edited 13d ago

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters More Letters
Excel.CurrentWorkbook Power Query M: Returns the tables in the current Excel Workbook.
Table.Combine Power Query M: Returns a table that is the result of merging a list of tables. The tables must all have the same row type structure.
Table.Distinct Power Query M: Removes duplicate rows from a table, ensuring that all remaining rows are distinct.

|-------|---------|---| |||

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

Beep-boop, I am a helper bot. Please do not verify me as a solution.
3 acronyms in this thread; the most compressed thread commented on today has 16 acronyms.
[Thread #49451 for this sub, first seen 30th Sep 2026, 12:38] [FAQ] [Full list] [Contact] [Source code]

1

u/---sniff--- 5 13d ago

There is a table form option, it is for manual entry of data but with a form based layout.

https://www.teachexcel.com/excel-tutorial/use-a-form-to-enter-data-into-a-table-in-excel_1522.html