I'm trying to accomplish 2 things at once. I have 2 pages with customer information, one page being contact info and another being CRM information based on those customers.
I'm trying to populate customer information like name and phone number from one page to another using for example:
=ContactDetails!A5 Very simple.
I can drag that formula down the desired rows to populate the entire column, but when I insert a new row at the bottom of the column that formula doesn't populate in the new row.
Information originally from the Contact Details page to the CRM page.
Is it possible to accomplish both?
Here is my example sheet:
My reading suggests using an array formula, but my knowledge is limited and I don't understand how to combine both functions.