VBA to lookup content, copy entire row containing data, insert copied rows into different workbook

[jwillisatl]

Hi! We have multiple workbooks that we work in:
1) Master Expenses. This is where every transaction from the bank account is put into. Each transaction is then labeled with he corresponding "project" or "property".
2) Property Specific Expenses. Each project/property has its own spreadsheet with expenses from the Master Expenses workbook.

We are currently taking the time to filter on the Master by each property, go to the property specific workbook, copy the rows from Master and insert them into the property specific workbook. Theres gotta be a more efficient way to do this. I am thinking a macro where excel looks for the address in the Master Expenses and then copies/inserts into the corresponding workbook. Possible? Is there another way this could be done?

MASTER EXPENSES:

Master Expenses - External.xlsm
	A	B	C		E		G	H	I
1	Date	Check Number	Description		Amount		Comments	Property	Uploaded
2	10/7/21		Roc Cabinetry 3468		Cabinets		Yes	410 Bayfront Place	Yes
3	10/5/21		Bagwell Insuran 3468		Insurance - 3 Months		Yes
4	10/4/21		City of Cumming 3468		Utility Set Up		Statement	410 Bayfront Place	Yes
5	10/1/21		Wire Transfer		Purchase Proceeds?		Statement	13206 Front Beach	Yes
6	9/30/21	9224	PiaMaherasRealtor, LLC		Final Pay - Purchase		Yes	410 Bayfront Place	Yes
7	9/29/21	9208	Keller Williams Community Partners		Earnest Money		Yes	2482 Collins Port Cove	Yes
8	10/8/21		Apartments.com Taylor		$1,075.00		Rent (OCT21)	5635 Quail Trail	Statement
9	10/8/21		State Farm Ins 3468		-$398.01		6 Months Insurance	2835 Browne Circle	Yes
10	10/8/21		The Home Depot 5200		$36.60		Material Refund	410 Bayfront Place	Yes
11	10/8/21		State Farm Ins 3468		-$446.95		6 Months Insurance	80 Oakmont Drive	Yes
12	10/7/21	9218	Dillon Martin		-$400.00		Yard Clean Up	2482 Collins Port Cove	Yes
13	10/7/21	10001	NG Key Works		-$149.00		Rekey	4617 Forest Place	Yes
14	10/7/21	9231	Quality Window Service		-$145.00		Window	410 Bayfront Place	Yes
15	10/7/21		Apartments.com Sullivan		$1,700.00		Rent (OCT21)	103 Crain Drive	Statement
16	10/7/21		Apartments.com Davis		$1,515.00		Rent (OCT21)	9145 Pine Tree Circle	Statement
17	10/7/21		Roc Cabinetry 3468		-$1,064.17		Cabinets	1590 Hughes Drive	Yes
18	10/7/21		Foreclosure Bid 8999		-$93.00		Fee	Business	Statement
19	10/6/21		Barnesnoble Xx 3468		-$111.21		Books	410 Bayfront Place	Yes
20	10/6/21		Caffemilanoofna 3468		-$40.64		Contractor Meal	410 Bayfront Place
21	10/6/21	9232	Michael W Davis		-$740.00		Labor	410 Bayfront Place	Yes
22	10/6/21	9230	Slider Genie		-$348.00		Sliding Door?	410 Bayfront Place	Yes
23	10/6/21		Bayfront Inn 5t 3468		-$97.24		Contractor Lodging	410 Bayfront Place
24	10/6/21		Apartments.com Dole		$1,400.00		Rent (OCT21)	6512 Millwood Road	Statement
25	10/6/21		The Home Depot 3468		-$15.66		Materials	410 Bayfront Place	Yes
26	10/6/21		Bayfront Inn 5t 3468		-$13.64		Contractor Lodging	410 Bayfront Place
27	10/6/21		Bayfront Inn 5t 3468		-$221.76		Contractor Lodging	410 Bayfront Place
28	10/5/21		Gulf Power Elec Pymts		-$270.17		Utilities (OCT21)	13206 Front Beach	Yes
29	10/5/21		Dillards 216 Co 3468		-$14.98		Bedding	410 Bayfront Place	Yes
30	10/5/21		Target X 3468		-$318.09		Rugs/Mirrors	410 Bayfront Place	Yes
31	10/5/21	10002	Cindy Vankempen		-$1,203.00		Labor	410 Bayfront Place	Yes
32	10/5/21	9217	Cindy Vankempen		-$100.00		Labor	2727 Bettis Tribble Gap	Yes
33	10/5/21	9219	Hadinger Flooring		-$7,673.46		Floor Work	410 Bayfront Place	Yes
34	10/5/21		Jcpenney x 3468		-$38.50		Cooler	410 Bayfront Place	Yes
Transactions

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E8:E11	Cell Value	=0	text	NO
E12:E1082	Cell Value	=0	text	NO

EXAMPLE PROPERTY SPECIFIC:

Proeprty Specific - External.xlsm
	A	B	C	D	E	F	G
1	Date	Check Number	Description	Amount	Comments	Property	Uploaded
2	10/7/21		Roc Cabinetry 3468	-$1,064.17	Cabinets	1590 Hughes Drive	Yes
3	10/5/21		Bagwell Insuran 3468	-$628.00	Insurance - 3 Months	1590 Hughes Drive	Yes
4	10/4/21		City of Cumming 3468	-$125.00	Utility Set Up	1590 Hughes Drive	Statement
5	10/1/21		Wire Transfer	-$5,000.00	Purchase Proceeds?	1590 Hughes Drive	Statement
6	9/30/21	9224	PiaMaherasRealtor, LLC	-$200.00	Final Pay - Purchase	1590 Hughes Drive	Yes
7	9/29/21	9208	Keller Williams Community Partners	-$5,000.00	Earnest Money	1590 Hughes Drive	Yes
8
9
10
11
12
13
14
Transactions

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:D7	Cell Value	=0	text	NO