•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Create a table that reflects only selected data?
Hello!
I have an excel sheet at work that customers use to order supplies from us.
The supplies are all in a list with an empty cell next to each item where they fill in the quantity they want to order.
This list is rather long, so to help out my techs, I was wanting to create a table that will automatically translate the data from items they want to order when they enter a quantity next to it.
Like if I had a list of 50 items, and I put a quantity number next to number 24 and 48, only they would populate in a separate table (with the entered quantity).
Essentially the example below:
| ID | Description | Qty |
|---|---|---|
| 101 | Item 1 | |
| 102 | Item 2 | 7 |
| 103 | Item 3 | |
| 104 | Item 4 | 2 |
| 105 | Item 5 |
| ID | Description | Qty |
|---|---|---|
| 102 | Item 2 | 7 |
| 104 | Item 4 | 2 |
Is this something I could do?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#table
#quantity
#supplies
#item