February 18, 2022
I'm using Microsoft 365 and using Windows. I have form like this. each style have different range size. how to make the report more user friendly when adding new data. because there is a lot of size. it's possible using Macro ? and it's possible to update by multi user in the same time ?
1. its there any easier way using macro to entry new data ?
2. and how to used search feature using macro. user can search 2 or more PO's
below is the example file.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
For a search form, you can find multiple versions on our site:
Adding new data with a form (using a vba code) is not difficult, but in a multiuser environment there are a few challenges: conflicts are common, when more than 1 user is editing the same range, therefore the design of the entire process is complex.
You could store the data in Access, each user should send updates to access - this will solve the concurrent changes problem, but your data structure is not fit for access, the structure is not tabular, there are many changes needed. I suggest you hire a consultant to organize the system, if you're not comfortable with macros.