tanyaleblanc
Board Regular
- Joined
- Mar 16, 2019
- Messages
- 145
I'm not sure this is even possible, but here goes, is there a way to put the below instructions into a macro.
1. I have an NCR report, that I need to filter by Takeover and copy account #'s and Takeover from Acct# (2 columns) into the Adj Rpt, anywhere on the sheet.
2. Then I need to filter the acct#'s under column D2 that are already listed on the Adj Rpt using a customer filter below using the acct#'s and T/O from Acct #'s that I copied over from the NCR report.
3. if data populates, I need to total the column H (Gross amt) (debits and credits should 0 each other out) and delete the contents from column H, only if they 0 each other out. If they do not total 0.00, do not delete contents.
4. Once all accounts have been reviewed, I can filter gross amt by blank cells and delete those line items as they are not needed in my report.
- Use the takeover lists for rental from NRC to delete adjustments which $0.00 each other out. – filter on Takeover under Agreement field, copy Acct# and T/O from acct# (column C & P) to the ADJ sheet, (anywhere)
- Filter on ADJ Account # - custom – Acct # equals (Acct# from NRC) OR equals (T/O from Acct#). Sum Gross Amt should total $0.00 (typically an offsetting debit and credit). Delete amts from Gross amt field, repeat filter for all take over accts and once both takeover lists have been vetted, delete all accts by filtering by blanks in Gross Amounts field.
1. I have an NCR report, that I need to filter by Takeover and copy account #'s and Takeover from Acct# (2 columns) into the Adj Rpt, anywhere on the sheet.
2. Then I need to filter the acct#'s under column D2 that are already listed on the Adj Rpt using a customer filter below using the acct#'s and T/O from Acct #'s that I copied over from the NCR report.
3. if data populates, I need to total the column H (Gross amt) (debits and credits should 0 each other out) and delete the contents from column H, only if they 0 each other out. If they do not total 0.00, do not delete contents.
4. Once all accounts have been reviewed, I can filter gross amt by blank cells and delete those line items as they are not needed in my report.