Forum Discussion
How to take inputs from one table, plug them into a different table, and save a copy of outputs
- May 12, 2023If 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.
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.
- Antonino2023May 11, 2023Brass Contributor
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
- mathetesMay 11, 2023Silver Contributor
I can get (have gotten) Full_Analysis and Desired_Summaries, but the Analysis_Inputs link yields a screen which remains totally blank.
- Antonino2023May 11, 2023Brass ContributorMy apologies, please try this one:
https://1drv.ms/x/s!AhR2YhuTZhdXgmZ9PCN49yCSxlxs