VBA - filtering multiple criteria from two workbooks

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.


  • 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.


 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top