I'm looking for a formula that will help autofill data. I have a main summary tab where I input all the data and I want it to recognize the names of homes and then autopopulate another tab.
Here is an image of how my main summary tab looks:
Capture1.PNG
So then a second tab would be, for example, "Homes A" which includes Home 1, Home 2, and Home 3 ("Homes B" would be Homes 4, 5, and6, and so on). So if I put "Home 1" in the summary tracking tab, I want the "Homes A" tab to to then be autofilled with the rest of the information that I've put in (Date, person's name, and then the numbers which is the data).
Basically I'm trying to avoid having to manually copy and paste the information over into the "Homes A" tab each time.
Not sure if this makes sense, can anyone help?
Bookmarks