I never knew this was possible, but i came across a dashboard where input is magically simplified because other tables when refreshed, "fetch" specific data wich was inserted on the main table.
It's not formulas or anything, lemme tell how it works so someone can explain me how to reproduce it:
First worksheet is called "Report" and there are a list of different questions with quantitative and qualitative answers.
Hidden, there are more worksheets where all the "Report" data is split into (no work is needed at all, just clickicng "refresh-all" a couple times do the job):the lines with qualitative questions "get copyed" to a hidden worksheet, and same is made with quantitative questions.
It doesnt matter if you add more data on main worksheet: as long as you resize the table afterward, everything goes to its place automatically.
What tool did this wizard used? How can excel know how to split data and where to send it? I need this kind of power!!! lol
It's not formulas or anything, lemme tell how it works so someone can explain me how to reproduce it:
First worksheet is called "Report" and there are a list of different questions with quantitative and qualitative answers.
Hidden, there are more worksheets where all the "Report" data is split into (no work is needed at all, just clickicng "refresh-all" a couple times do the job):the lines with qualitative questions "get copyed" to a hidden worksheet, and same is made with quantitative questions.
It doesnt matter if you add more data on main worksheet: as long as you resize the table afterward, everything goes to its place automatically.
What tool did this wizard used? How can excel know how to split data and where to send it? I need this kind of power!!! lol
Last edited:
