I'm trying to create a VERY basic CRM tool. I want to create a running list of customer names. Once I enter a name in Column A I'd like a new Sheet automatically created with pre-set columns I can enter values and information into. The columns I'd like are:
1. Name 2. Address 3. Phone Number 4. Email Address 5. Quote 6. Sold
Also, I'd like to be able to click on the name and be taken directly to the corresponding sheet that has been created.