Cut Data Once It Has Been Selected

[Steve Belsch]

Hi all,

I have a long nested set of formulas that look into a worksheet data table and return data that matches specific reference points. Once I get that data with the formula below, is there a way to delete that data from the original table using a formula or some other method?

=IF(ROWS($B$3:G43)<=$BY$2,IF(AND($BZ$2=INDEX('Accrual & PO Data'!$J$2:$J$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),$BX$2=INDEX('Accrual & PO Data'!$L$2:$L$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43)))),INDEX('Accrual & PO Data'!I$2:I$1048576,AGGREGATE(15,3,('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)/('Accrual & PO Data'!$L$2:$L$1048576=$BX$2)*ROW('Accrual & PO Data'!$I:$I),ROWS($B$3:J43))),""),"")

Thanks for the help!

Steve

[Logit]

.
Deleting data requires VBA macro.

[Steve Belsch]

Logit,

Thanks for the reply. Is there a way to do this formula in a macro?

Thanks.
Steve

[Logit]

.
I admit that FORMULAS are not my strong point. The result is I don't fully understand what the formula is doing.

If you can post a sample of your workbook with just enough data to demonstrate what it is you want, I might be able to assist. Or
there are lots of folks here with a stronger understanding of formulas, etc. They will be happy to assist.