HomePro
Board Regular
- Joined
- Aug 3, 2021
- Messages
- 157
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Prefer Not To Say
- Platform
- Windows
- MacOS
- Mobile
- Web
So I cant figure out how to do this.
I want to search thru a worksheet in column "A" for any instance of the entry "Returned". If found then get the data from columns "C" [name] and "D" [amount].
Now search thru the entire worksheet for any row that matches the data from columns C&D and copy them to another worksheet.
The result should be worksheet with a complete list of returned checks and any other instance from that client for the same amount [this would be the original deposit and any redeposit.]
I cannot get my head around how to do this.
Can anyone help?
Tks.
I want to search thru a worksheet in column "A" for any instance of the entry "Returned". If found then get the data from columns "C" [name] and "D" [amount].
Now search thru the entire worksheet for any row that matches the data from columns C&D and copy them to another worksheet.
The result should be worksheet with a complete list of returned checks and any other instance from that client for the same amount [this would be the original deposit and any redeposit.]
I cannot get my head around how to do this.
Can anyone help?
Tks.