Hi,
Would anyone be able to help me set up a second and third tab for the master spreadsheet listed below?
I want the second tab to only list the parishes in Store Category 'A' and the third tab to only list parishes in Store Category 'B'.
I tried using a formula like the one listed below, but it's kind of a manual process.
This formula is also flawed because I want excel to skip all of the rows related to Holly and Greg's Donut Shop (Category A) on the third tab (listing Category B stores).
I don't want excel to return blank rows on the third tab (I just want it not to show any Category A fields at all).
=IF(MASTER!D:D="A",MASTER!G3," ")
Because of the format of the master spreadsheet (some rows have been merged and I have to keep this format), I created columns B through D to get a unique action item returned for each field on the second tab.
I'm using Excel 2007.
Does anyone have any suggestions on a better formula or a macro I could use to get the second and third tabs to appear correctly?
Thank You,
CJH
<tbody>
</tbody>
Would anyone be able to help me set up a second and third tab for the master spreadsheet listed below?
I want the second tab to only list the parishes in Store Category 'A' and the third tab to only list parishes in Store Category 'B'.
I tried using a formula like the one listed below, but it's kind of a manual process.
This formula is also flawed because I want excel to skip all of the rows related to Holly and Greg's Donut Shop (Category A) on the third tab (listing Category B stores).
I don't want excel to return blank rows on the third tab (I just want it not to show any Category A fields at all).
=IF(MASTER!D:D="A",MASTER!G3," ")
Because of the format of the master spreadsheet (some rows have been merged and I have to keep this format), I created columns B through D to get a unique action item returned for each field on the second tab.
I'm using Excel 2007.
Does anyone have any suggestions on a better formula or a macro I could use to get the second and third tabs to appear correctly?
Thank You,
CJH
STORE ID NUMBER | STORE NAME | STORE CATEGORY | ORIGINAL ACTION ITEM LIST | |||||||
ACTION ITEMS | DEPARTMENT | ASSIGNED TO | STATUS | DATE COMPLETED | ||||||
123 | 1 | 1231 | A | Holly and Greg's Donut Shop | A | 1) POWDER DONUTS | RE | |||
123 | 3 | 1233 | A | 2) SUGAR DONUTS | DS | COMPLETED | ||||
123 | 4 | 1234 | A | 3) SPRINKLE DONUTS | DS | Holly | COMPLETED | 11/29/2016 | ||
123 | 5 | 1235 | A | 4) BAKE DONUTS | DS | COMPLETED | ||||
123 | 6 | 1236 | A | 5) SELL DONUTS | CS | |||||
368 | 1 | 3681 | Annie and Fatty's Donut Shop | B | 1) CLEAN COUNTER | CS | ||||
368 | 2 | 3682 | 2) CHANGE REGISTER | CS | ||||||
<tbody>
</tbody>