Can I suggest that you create a regular normalised 2 dimensional database. i.e. insert a new column A to hold the Supplier Name and then column B:G will be your current columns A:F
This will give you a lot more flexibility for reporting and at the same time you'll be able to use the Powerful Pivot Table functionality
Then in the Click event of the Input Data button on your form use code like the following
It would be prudent to build in a check as the first stage in the macro to ensure all 7 entries have been completed and if not put up a warning message and exit the sub.
I'd also consider creating a separate record for every named person. i.e. where you have 7 names on row 17 create 7 identical records apart from the names. The number of similar rows to create for each record will be the maximum number of names in either the Firm Attendance field or the Counter Party Attendance column.
You might think this is unnecessarily adding rows to the database but believe me your ability to report information relating to people will be much enhanced.
Bookmarks