Log In
Register
Home
February 18, 2022
Offline
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.
https://www.dropbox.com/scl/fi.....c76dcn409s
Thankyou,
Justin R
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Justin,
For a search form, you can find multiple versions on our site:
https://www.myonlinetraininghu.....nd-display
https://www.myonlinetraininghu.....-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.
Answers Post
1 Guest(s)
