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?
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
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies