Need help on how to compare data over twp workbooks and delete matching data from one.

I have a workbook that has all the data that I use and also workbooks that have all the data that I have used and im trying to delete data that I have used from the workbook that has all the data.


I have a workbook called TABLEAU that contains all the data also various other workbooks
Im trying to get a macro that does the following.

1) What I'm trying to do is first of all in the workbook called TABLEAU filter out in column G "CHEQUES AND CASH BANKED 95140" .

2) I then need the macro to open the File called "CASH LIST PREVIOUS MONTH" Link to workbook below:-

"https://sharepoint.com/teams/O365GRP-StationAccounts/Shared%20Documents/General/GLENN/CASH%20LISTS/CASHLISTPREVIOUS%20MONTH%20.xlsm"

3) It then needs to looks at the data from each row in columns A-E and if there an exact match across all rows in workbook called "TABLEAU" then I need that line deleted from the workbook called "TABLEAU" Once that is done I need the workbook called CASHLIST PREVIOUS MONTH" closed.

4) I then need it to open file called "CURRENT" Link to workbook below:-

"https://sharepoint.com/teams/O365GRP-StationAccounts/Shared%20Documents/General/GLENN/CASH%20LISTS/CASH%20LIST%20CURRENT%20MONTH.xlsm"

5) It then needs to looks at the data from each row in columns A-E and if an exact match across all rows in workbook called "TABLEAU" then I need that line deleted from the workbook called "TABLEAU" Once that is done I need the workbook called CASHLIST CURRENT MONTH" closed.

What should of happened is all the data that's in cash list previous & current month would of been deleted from workbook called TABLEAU as already been used.


6) I then need the workbook called TABLEAU to filter out in column I the number 48 and do exactly the same again,

but opening this workbook

Workbooks.Open Filename:= _

"https://.sharepoint.com/teams/O365GRP-StationAccounts/Shared%20Documents/General/SHERE%20CURRENT%20MONTH.xlsm"

7) It then needs to looks at the data from each row in columns A-D and if an exact match across all rows in workbook called "TABLEAU" then I need that line deleted from the workbook called "TABLEAU" Once that is done I need the workbook called SHERE CURRENT MONTH" closed



The data in the workbooks that tableau comparing against are NOT in the same rows in both workbooks so I need each entry in the workbooks to look all the way down the workbook called tableau to find a match .



Any Ideas?

Many Thanks

you have some brilliant Ideas. Can you get power query in normal excel program or is it an add on you havr to pay for?

Ive only ever known macro's and still rusty on that. Is there any website or something that gives an idiot proof guide on how to do powerpoint?

I believe Power Query is included (for free) in Excel 2016 or later (also available as a free download for Excel 2010 and 2013)

These ones look promising:

https://www.simplilearn.com/tutorial...query-in-excel
https://www.howtoexcel.org/the-compl...o-power-query/