•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