Answered

Split an Excel file into several sheets

(1) Share

Report

Posted on by Hila21

I created a contact form for my department. Each employee handles a different issue with unique questions.
At the beginning of the form, the respondents choose a topic and are directed to questions relevant to that topic.

I want to create a separation in the answer sheet so that only the answers to the relevant questions will appear on each topic and each employee could track his inquiries only.

I'm pretty new here and have not found anything relevant, do you have any idea how to do that?

I have the same question (0)

All responses (2)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Split an Excel file into several sheets

Hi @Hila21

Is this one Excel Workbook for the whole team? But multiple sheets? The easiest method is probably to setup the excel workbook with the multiple sheets and in each sheet, create a table, naming them after each sheet. Then you can write the rows to the table of your choice, based on the form responses.

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Split an Excel file into several sheets

Hi @Hila21 :

Do you want to get something like this:

Before:

After:

If so,I've made a test for your reference:

Best Regards,

Bof

Was this reply helpful? Yes No