Hi Barry,
I've been searching the web and looking at different ways to do it. I already have the form created to send the responses and store the responses in sharepoint in Excel. What I"m trying to do is take those responses ( every customer)
1. Create a seperate workbook for each customer with the question in Row A and Response in Row B( 16 Questions)
- Each workbook would be the customer Name (Example: Customer A) with a sheet with ROW A as the Question in the Form and Row B as the Response to the Question for that customer.
2. Take the responses from the Customer A workbook and populate another workbook where we have 68 question and 16 questions from the form are asked again so we don't ask the customer the same question again. I could just do a vlookup but I don't want the team to have to do that.
The idea is we have 3 sets of questions that get asked to the customer throughout the sales cycle and first set of questions is asked via a form. The 2nd is in an excel spreadsheet(68 questions) and the 3rd(180 Questions) Excel spreadsheet. Each excel spreadsheet has the questions asked again from the form or the previous spreadsheet because we are getting a little bit more detail throughout the cycle.
Thanks
