I would appreciate any suggestions as to what look out for and where we might find some performance gains, please. others will help you out but to begin with make sure the database is thoroughly normailzed and tables adequately indexed.Ensure the app and data are in separate files (split front end and back end) Ensure that the data sits on the server and that the app sits on each of the user's PC and is linked to the data file on the server. I want the user to update this sheet in A and click update button which should run my macro.
In the Project Window you will add modules and create forms. Paste Special Paste:=xl Paste Formulas And Number Formats, Operation:= _ xl None, Skip Blanks:=False, Transpose:=False Dim wkb1 As Workbook Dim sht1 As Worksheet Dim wkb2 As Workbook Dim sht2 As Worksheet Application. Screen Updating = True Sub Get Data() Dim l Row As Long Dim l Col As Long l Row = This Workbook. I usually give my users a compiled mde file for security.With only 8 users mostly read only Access should work fine (until you want to expand your user numbers and usage).To these userforms you will add controls (command buttons, text boxes, list boxes and others) and program them.