Forum Discussion

Dave Thackeray's avatar
Dave Thackeray
Copper Contributor
Jul 23, 2018

Show filtered data in one spreadsheet clicking buttons in another

Morning, champions! Two spreadsheets in one workbook. In one spreadsheet I have thousands of rows. I have identified about 350 groupings of these rows and by clicking one of 350 corresponding li...
Macros & VBA
VBA
Dave Thackeray's avatar
Dave Thackeray
Copper Contributor
Jul 23, 2018

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'm identifying a huge number of tasks our website visitors need to accomplish online.
  • Each task comprises a series of URLs and 'auditor comments' (two separate columns) displayed in the contentAudit spreadsheet
  • There's a second spreadsheet called topTasks that serves as an index of all the tasks (there will be hundreds)
  • Each of the tasks will have an identifier which will be used in a column on the contentAudit spreadsheet to group all the corresponding URLs for each task
  • Both spreadsheets are in the same workbook.
  • People will use the topTasks spreadsheet to identify which tasks require immediate attention (based on cells showing the priority of each task)
  • A link or button on each row of the topTasks spreadsheet will display the contentAudit spreadsheet with only the URLs corresponding to that task, shown. 

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.

 

This is contentAudit showing the URLs filtered according to the ID of 1. I hope we can achieve this automatically when the user clicks a link in the topTasks row for task 1.This is topTasks - the index - showing IDs and tasks

 

Does this help?

 

Thanks for giving this a shot for me. Much appreciated!

  • Dave Thackeray's avatar
    Dave Thackeray
    Copper Contributor
    Jul 24, 2018

    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!

Resources