K
KLassman
I have a workbook with 4 tabs. The first tab has all the dat
beginning with row 9. Each row has one of 4 Status codes in Column B
I need to have all the Status "CO" items be copied automatically t
the tab for CO items. I have the Status Code that the data shoul
match in B2 of the CO tab.
Right now I'm using an IF function . . .on the CO tab in field A9
have used "if B9 on the Detail page equals B2 on the CO tab then
copy A9 from the Detail page to the CO page OR enter "--".
I use this same formula slightly modified for all fields in the row.
This is working fine . . . except now I don't like having all the row
with "--" when the Status does not equal CO.
Is there another function that would just ignore the field if it doe
not match the criteria of CO Status? I tried using Index/Match an
it didn't work for me.
I have considered just using the Auto-Filter feature and copy/paste th
CO items to the CO tab. But wondered if there was another way.
Thanks
beginning with row 9. Each row has one of 4 Status codes in Column B
I need to have all the Status "CO" items be copied automatically t
the tab for CO items. I have the Status Code that the data shoul
match in B2 of the CO tab.
Right now I'm using an IF function . . .on the CO tab in field A9
have used "if B9 on the Detail page equals B2 on the CO tab then
copy A9 from the Detail page to the CO page OR enter "--".
I use this same formula slightly modified for all fields in the row.
This is working fine . . . except now I don't like having all the row
with "--" when the Status does not equal CO.
Is there another function that would just ignore the field if it doe
not match the criteria of CO Status? I tried using Index/Match an
it didn't work for me.
I have considered just using the Auto-Filter feature and copy/paste th
CO items to the CO tab. But wondered if there was another way.
Thanks