beginvbaanalyst
Board Regular
- Joined
- Jan 28, 2020
- Messages
- 141
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I'm having issues trying to pull information between two sheets in a workbook. Basically I want to check multiple criteria "800 005", "100" in one sheet to see if my new sheet contains the same data, and if it doesn't pull the balance from the old sheet. How would I go about doing this? I'll post two screen shots of small data for an example:
This is last month
This is current month
So it looks like 0000218122-0062 & 000209623-0062 is in my last month but not current month. How do I pull the balance?
I'm having issues trying to pull information between two sheets in a workbook. Basically I want to check multiple criteria "800 005", "100" in one sheet to see if my new sheet contains the same data, and if it doesn't pull the balance from the old sheet. How would I go about doing this? I'll post two screen shots of small data for an example:
This is last month
This is current month
So it looks like 0000218122-0062 & 000209623-0062 is in my last month but not current month. How do I pull the balance?