•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?
Our take
If you're looking to streamline your ordering process, creating a dynamic table that reflects only the selected data can significantly enhance efficiency. By setting up a system that automatically compiles items based on the quantities entered, you empower your team to focus on what matters most: fulfilling customer needs. This approach not only simplifies data management but also ensures that only relevant information is highlighted, making it easier for your technicians to process orders accurately. Let’s explore how you can implement this solution effectively.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Helping a coworker- How to return a row with three criteria in an existing sheet?https://preview.redd.it/qpc1n7v6hnrg1.png?width=454&format=png&auto=webp&s=b418c6890f9257bc9e55d32d2d5fee93a0a02a31 Hey all , I KNOW there's an answer staring me in the face. I played around with PQ but didn't see what I liked. My coworker has data that looks like this In a new workbook, she wants to take this above data and return the number in C1 (and D1, and E1, etc.) in column A. But not just pasting vertically, returning it for every line of item#s. So Order A, Order A, Order A, etc. She also wants the item# returned in column B of the new book. Short of copying and pasting, I don't know a good way to do that. Finally, once she has those we can do an old fashioned lookup to get the qty to return in Column C, we're good there. Any thoughts? And please don't just say "PQ" and leave. If your answer is PQ, please give detailed instructions and advice. Editing to add output required: https://preview.redd.it/q3hcvmf1jnrg1.png?width=274&format=png&auto=webp&s=99dbd555d964a0f2aa3a09676efa27ae1af887f9 submitted by /u/Knitchick82 [link] [comments]
- New tables being created after filling previous onesHello, I am creating an Excel spreadsheet to calculate the cost of various parts. The exact number of parts is not known in advance and may vary; furthermore, these parts may be either purchased or manufactured. For this calculation, there are four specific tables—in addition to an initial table that names the part and specifies whether it was purchased or manufactured: Materials, Processes, Transport, and Fasteners. If a part is purchased, it utilizes only the Transport and Fasteners tables; if it is manufactured, it uses all four. Is there a way to have the entry rows for new parts be added automatically, and then—once the user selects whether the part was purchased or manufactured—have the necessary corresponding tables appear? I have looked online but I couldnt ffind anything. Many thanks for considering my request. submitted by /u/Traditional-Gas-1355 [link] [comments]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- Exporting just one sheet?Looking for a clean way to do this. I've got a spreadsheet with multiple sheets that refence eachother for preparing data for a customer. Obviously I can just print one sheet but what I would really like to do is export the "customer" sheet as a new excel document. Ideally with some of the values becoming their data on the new sheet, but other cells keeping their formulas Example, first box would be what the cells on the export sheet output, next being their formulas. the second set would be how I would like to export, Hard coding the values as regular numbers that are referenced from a different sheet, but keeping the formulas that do math on the same sheet. Is this possible? https://preview.redd.it/cstcpxl78vqg1.png?width=181&format=png&auto=webp&s=f85a19322898ac8a3556d059ba1c5ad6dba7b867 =DifferentSheet!P7 =A1*10 =DifferentSheet!P8 =A2*10 =DifferentSheet!P9 =A3*10 https://preview.redd.it/s4xpp55h8vqg1.png?width=181&format=png&auto=webp&s=962737308118022dbc6a060481514fdc07c1e261 11.5 =A1*10 12 =A2*10 14 =A3*10 submitted by /u/223specialist [link] [comments]
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