Screenshot Dec11.jpgYou are Excel sleuths, ye three. and you all make valid points.

Yes, using 365 here, and requiring my users to do so also. Right now they have Microsoft on the Web, but that program will not allow VBA, so it causes problems with what I am trying to accomplish for the company with this program.

My reason for having the data viewed by the user is that someone could have added a question in MSForms or changed the wording.. All my fancy footwork of using code to put those questions into either Clients_Tbl or Booking_Tbl would then unravel. Downloading and viewing allows the user to drag drop Field names (named cells) to line them up with the questions in MSForms. It's kind of old school, but not sure if there is another way. The field names are organized and understood at the company level. Questions on the form are organized and understood at the client level. So wording and order should be changeable. The only reason they would require more programming would be if they wanted to add a question.

So this whole Filter thing, which could be replaced by PQ, is rather temporary. What would be the benefit of the PQ since my Filter function is now coded in and works?

Hmm... Just thinking here. I could get the dispatch to write all the questions from the MSForm into a sheet on column A, exactly as worded in the forms, then to put the matching field names, exactly as used in Booking and Clients in Columns B and C, respectively. Order shouldn't matter. Then I could take the length of the Column A, and use that to iterate through the items in Column C to create a new row in Clients, and then do the same for Booking, by using for each item in Column B. Maybe this would be a better code approach anyway, and it would save the user from having to match fields. The download would not need to be opened. And the sheet only updated if changes are made to field names or form questions.

Here is a view of my sheet.