Home

Auto populating a grid from a spreadsheet

Robster1
New Contributor

Sorry that this is basic!  However can anyone provide a bit of education on Excel?? In particular on how to get existing and new data in a spreadsheet to auto populate a grid?

4 Replies
What do you mean by "auto populate a grid"? Do you mean getting data from an external source (like a database, or a csv file) into Excel? Check out the options Excel offers to you on the Data tab of the ribbon.

Many thanks Jan, much appreciated.  It's for a spreadsheet that is already populated with various data fields.  This can also be added to of course on an ongoing basis.  The solution will be to have the data auto-feed/auto-populate into an associated (adjacent) grid.  So that when someone enters or changes the data in the spreadsheet it automatically feeds into/changes in the separate grid.   I hope that makes sense...?

So why would you need the same data twice?
Highlighted
It's a results element in the grid. It's a interpretation of the original data entered into the spreadsheet. So it's showing an outcome in the grid and a set of results based on the spreadsheet...
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies