sheets overview with filter function

Christine Menke

Dear Expert,

I have 3 sheets filled out by external partners ( same columns set up). They add rows and change the cell status.

Based on the 3 sheets, I would like to create one sheet with all the content on it for our headquarter overview.

I tried a Report which works, but I don't have a filter function here, to create a personal view.

Is there another better way to combine the 3 sheets in one and use filters?

Thanks for your help!

Christine

Andrée Starå

Hi @Christine Menke

I hope you're well and safe!

You could either use cell-linking or cross-sheet formulas to collect it all together in one sheet.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Christine Menke

thanks for you fast answer Andrée,

does cell-linking also work if rows are added on the 3 base sheets?

Thanks

Christine

Andrée Starå

@Christine Menke

Happy to help!

Unfortunately, no, they don't. You'd need to use the cross-sheet formula structure to be able to add new rows.

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Christine Menke

HI Andrée,

thanks you mean something with vlookup and If error?

Would be great if you could help me on the formular. Below are my 3 sheets and the Masterfile where I have the art. Nr but need to get the date from the 3 sheets.

Thanks in advanced

Christine

Sheet 1

article Nr Date 1

1233 12.4.21

Sheet 2

article Nr Date 1

2345 13.4.21

Sheet 3

article Nr Date 1

2346 15.4.21

Master sheet

article Nr Date 1

1233

2345

2346