•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sorting columns on a LARGE Excel sheet with 5 pages
Hello, I’m looking for some help learning how to sort data columns on this excel sheet. The sheet is used to track inventory by the person who’s using it. In the top right of the page you’ll see a row of Zones with corresponding numbers. Below the zone, the name of the person consuming the inventory. Then a little below that, random numbers I’ve entered to simulate inventory demand. I need a way to select the zones and sort them from smallest to largest number while keeping the column information the same.
Also this page is connect to 4 other pages. The other pages are coded to look at this page and carry the data over. Is it possible to code this Excel sheet so that ALL pages sort by zone?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#rows.com
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#machine learning in spreadsheet applications
#row zero
#no-code spreadsheet solutions
#large dataset processing
#Excel
#sorting
#inventory
#columns
#zones
#data