Bringing in rows from multiple sheets in a report

User251

Hi,

How can I bring in specific rows from multiple sheets in a report?

Thanks.

Andrée Starå

@User251

Are all the sheets named with Sheet 2 or similar? If yes, you could use that to only include the sheet that you need.

Make sense?

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

Andrée Starå

Hi @User251

I hope you're well and safe!

• You'd need to define what should be included in the Report Builder. Is there something in common between all the rows you want to have?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

User251

Thanks, @Andrée Starå . Both sheets have the same columns. They also have some common rows (rows in sheet 1 feed the same rows in sheet 2). I would like to be able to pull just the rows in sheet 1.

Andrée Starå

@User251

Are all the sheets named with Sheet 2 or similar? If yes, you could use that to only include the sheet that you need.

Make sense?

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

User251

Thanks @Andrée Starå . Let me reword my issue. is it possible in a report to have different rows coming from different sheets?