azmat
Member
Hello,
I am in real estate property management business, I have created a Google sheet (Let's name it an "Availability Sheet") of the available apartments for rent with our company.
We send email updates to the owners of the apartments about the condition of the apartment every month, so I have a sheet (Let's name it an "Monthly Inspection Report") from where email goes to the owners in the "Availability Sheet".
I have to enter the same data in both sheets twice like "Owner's Name", "Apartment No.", "Email Id.", etc.
I want to auto-sync data from both of the above sheets.
Please assist how I can do it.
I am in real estate property management business, I have created a Google sheet (Let's name it an "Availability Sheet") of the available apartments for rent with our company.
We send email updates to the owners of the apartments about the condition of the apartment every month, so I have a sheet (Let's name it an "Monthly Inspection Report") from where email goes to the owners in the "Availability Sheet".
I have to enter the same data in both sheets twice like "Owner's Name", "Apartment No.", "Email Id.", etc.
I want to auto-sync data from both of the above sheets.
Please assist how I can do it.
