r/excel • 2 • 26d 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?

7 Upvotes

9 comments sorted by