Depending on the number of distributors, make a table for each one with identical fields and auto-enter specific to the distributor?
Thanks for this.
I also just discovered from something that PhilModJunk wrote in another post on Creating a rolling twelve month report, that I can set values in a global field before the import, then simply set auto enter fields with the look up. A custom dialogue will do this nicely. And I can clear the globals at the end. So I think I have this solved for now.
Or change the original Excel sheets at source to have the standing data already in it, and then every import is the same, and no user interaction (and chance for mistakes). It only needs the distributor to enter two cells, max., and make them part of the template.