Forum Discussion
Solved
How to take inputs from one table, plug them into a different table, and save a copy of outputs
Hello, I have a question regarding how to take a row of inputs from one sheet, plug them into a table from another sheet, and save a copy of the results from the second sheet. That is the end res...
- If it takes too long to get another nibble, you might consider starting a new thread, making sure you include the files with your first post. I would also consider adding a bit more complete description (maybe with an example) of that first "iteration" routine you want, in bringing the data over from the inputs sheet to the analysis sheet.
mathetes Hello Mathetes,
Try these files:
https://1drv.ms/x/s!AhR2YhuTZhdXgmYj0QJSedhi_bdL
https://1drv.ms/x/s!AhR2YhuTZhdXgmp2LBYDhqnMe41J
https://1drv.ms/x/s!AhR2YhuTZhdXgm2kSJt6XugEZGWH
I can get (have gotten) Full_Analysis and Desired_Summaries, but the Analysis_Inputs link yields a screen which remains totally blank.
- My apologies, please try this one:
https://1drv.ms/x/s!AhR2YhuTZhdXgmZ9PCN49yCSxlxsSomehow, I suspect that I'm not fully understanding the full scope of what you want done. What I have been able to do is
- convert the Table in the Analysis tab into a range, which is what was needed
- in order for this FILTER formula to bring in the data from the Analysis_Inputs sheet. =FILTER(Analysis_Inputs.xlsx!All_Inputs[#Data],Analysis_Inputs.xlsx!All_Inputs[Model]<>"")
- Created a manual process (which could be recorded into a macro) for saving the data in the Desired Summaries sheet.
But I think you have some formulas that are not present in these sample sheets.....
And it also appears that you really do know how to use FILTER to take data from one workbook to another.....
So I'm a bit mystified as to what help you're actually seeking here.
- 1. I need the table on the Analysis tab to remain a Table, not a Range. This is because I use extensive formulas to import or derive values into the Green and Yellow colored columns.
2. To further elaborate, I am looking for a program or existing excel functionality that would allow me to iterate through each row of the Table in Analysis_Inputs. By iterate, I mean having each row be treated as its own set. This set is then to be pasted into its respective columns in the first sheet of Full_Analysis. The Table in Full_Analysis computes values/booleans into the Yellow columns. For each iteration, I want to save a values-only copy of these results where the summary includes the Model, Part, and all 3 Result columns.
3. To simplify, please ignore the Summary sheet. If we figure out how to iterate and save a copy of each iteration, then I can run a single Filter(Filter()) function on the merged Summaries to extract only those that meet a condition. This part I know how to do so.