summaries from different sheets

**dafnamat** · 12-02-2018, 08:39 PM

hi.

i have an excel file with 20 different sheets
each sheet contains a number of row items(procedures)
each item gets a priority(before or after)
i can not have all procedures items in one sheet
i also have 2 sheets for each priority 1 sheet "before" 1 sheet "after"
what formula can i use to send all procedures items(by name and not count them) to each of their priority sheets?
for example
if sheet number 20 has 3 procedures items rows
2 item with before priority, 1 item with after priority
the 2 items names will appear on the before sheet and the 1 item name will appear on the after sheet
i hope my explanation is clear...
thanks
Dafna

**alansidman** · 12-02-2018, 08:46 PM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**dafnamat** · 12-02-2018, 09:05 PM

attached
the first column of each sheet is the criteria to the before or after sheet
but i need the name cell on each sheet to appear on either the before or after sheet based on the criteria