Forum Discussion

Antonino2023's avatar
Antonino2023
Brass Contributor
May 11, 2023
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...
BI & Data Analysis
excel
Formulas and Functions
Macros and VBA
  • mathetes's avatar
    mathetes
    May 12, 2023
    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's avatar
mathetes
Silver Contributor
May 11, 2023

Antonino2023 

 

Those sample files seem to be on your own company's server (or behind some kind of wall)...I was prompted by Microsoft for a password, but the one for my own Microsoft account didn't work.....

 

So if you can put them on a public OneDrive area, or a copy on GoogleDrive, then post a link here, that would be helpful.

 

What you're describing sounds potentially like a process I follow in tracking some investments, taking data from one sheet, importing it to another, then building a summary of several of the intermediate sheets...... I'm eager to see if the process I use might be helpful to you.

Antonino2023's avatar
Antonino2023
Brass Contributor
May 11, 2023

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 

 

 

  • mathetes's avatar
    mathetes
    Silver Contributor
    May 11, 2023

    Antonino2023 

     

    I can get (have gotten) Full_Analysis and Desired_Summaries, but the Analysis_Inputs link yields a screen which remains totally blank.

    • Antonino2023's avatar
      Antonino2023
      Brass Contributor
      May 11, 2023
      My apologies, please try this one:
      https://1drv.ms/x/s!AhR2YhuTZhdXgmZ9PCN49yCSxlxs
      • mathetes's avatar
        mathetes
        Silver Contributor
        May 12, 2023

        Antonino2023 

         

        Somehow, I suspect that I'm not fully understanding the full scope of what you want done. What I have been able to do is

        1. convert the Table in the Analysis tab into a range, which is what was needed
        2. 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]<>"")
        3. 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. 

Resources