Here's the sheet: https://docs.google.com/spreadsheets...gid=1700639938
Now that we have THAT covered, here's what I'm hoping for.
- Currently, if A2 if filled with a reconizible name, "Crew Car Prefill" fills with information which autopopulates from B4:B27, pulling from "Customer Database."
- If B2 is filled, everything below that's known, autopopulates, also from "Customer Databse"
- What I'd like is if B2 if filled, and B4 has a "name" then G1:G3 autofills as if A2 was used, using the value in B2 to autofill E1:E6.
Any suggestions with the forumals already used?
Michael
Bookmarks