Have delved a bit into linking sheets and writing functions etc. in the past but I am starting to get out of my depth - Is there a way to intersperse the two, so something like:
If X then LINK
So IF Sheet1, column X is ticked, then LINK the contents of those rows in Sheet 1 to Sheet 2
=IF(sheet1columA), "1", LINK (Linked sheet colum A - column G) ?
The only alternative I can think of is a 'waterfall' of helper sheets
Has anyone come across this?
Help Article Resources
Check out the Formula Handbook template!