Jul 22 2018
11:31 PM
- last edited on
Jul 25 2018
10:09 AM
by
TechCommunityAP
Jul 22 2018
11:31 PM
- last edited on
Jul 25 2018
10:09 AM
by
TechCommunityAP
Jul 23 2018 04:28 AM
Jul 23 2018 04:29 AM
Jul 23 2018 01:30 PM
Hey, Wyn. Thank you so much for volunteering your support. It's much appreciated.
I'm an advanced beginner in the dark art of Excel so haven't yet discovered the wonders of Power Query.
To expand on my requirement:
I imagine this process will be repeated hundreds of times, which means I do not want a new tab created every time someone clicks a link to see the filtered contentAudit spreadsheet.
I've attached a couple of screengrabs to show what I mean.
Does this help?
Thanks for giving this a shot for me. Much appreciated!
Jul 23 2018 03:00 PM
Check out the attached file
I'll also attach a video to show how I built it
Jul 23 2018 03:02 PM
Video attached
Jul 24 2018 01:22 AM
Wyn - first of all, thank you so much for all the effort. It's hugely prized. Appreciated.
I think I might have miscommunicated. There was a part of the video where I thought it was dead on, then it seemed to go awry.
What I wanted was an index spreadsheet (your 'topTasks' tab) containing rows of tasks with IDs, from, say, 1 to 60.
The 'master' spreadsheet (in your file, the 'Content' tab) comprises of many, many more URLs (with multiple columns of information) each labelled with an ID relating to the tasks.
I wanted to be able to click a link alongside one of the tasks, that would subsequently show a filtered list of the URLs appended with the corresponding ID.
So if I clicked a link or button for task 18 in the 'topTasks' tab, another tab would show all the rows of URLs appended with the ID of 18.
You may have already done it - but I couldn't figure out where the link was in the 'topTasks' tab that would filter the master ('Content') spreadsheet to only show rows of URLs corresponding to the task ID that had been selected/clicked.
Make sense?
Thanks again!