Hi All,
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.
Thankyou,
Justin R
Hi Justin,
For a search form, you can find multiple versions on our site:
https://www.myonlinetraininghub.com/excel-forum/vba-macros/search-and-display
https://www.myonlinetraininghub.com/searching-for-data-with-user-form
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.
Hi Catalin,
Thankyou for your answer. i will try your advice.
Kind Regard,
Justin R
