Update cell after update from userform

[Patriot2879]

hi Dave would it be easy to amend the link to the 'Data' sheet? to C:\Users\s21375\Desktop\Book1.xlsm and sheet in book1 is called 'data'

 

[dmt32]

hi Dave would it be easy to amend the link to the 'Data' sheet? to C:\Users\s21375\Desktop\Book1.xlsm and sheet in book1 is called 'data'

Is this question related to your latest thread: https://www.mrexcel.com/forum/excel-questions/1110236-if-userform-already-open-then-msg-box-open-saying-userform-use.html

Short answer not easy especially if you are thinking of creating template copies of your workbook for multiple users where they read / write data to central workbook (database) over a corporate network but is doable.

This is a much better solution than sharing a workbook (which is best avoided) but does require some extensive coding to manage.


Dave

 

[Patriot2879]

Hi Dave yes related to my other thread, just another idea thought that this might be doable if the data is in another workbook and userforms are separate?

 

[Patriot2879]

Please could you advise how I could make template copies of m workbook for multiple users where they read / write data to central workbook (database) over a corporate network. this would be amazing.

 

[dmt32]

Hi Dave yes related to my other thread, just another idea thought that this might be doable if the data is in another workbook and userforms are separate?

You are not really meant to ask same question in two threads (I think)

With multi users, having template copies of a workbook connected to a database (Access ideal or another workbook will work) is the sensible approach but it does involve much more coding to manage. Also, data copied to master workbook from one user, other users with their templates open will not get real time updates but will have to refresh each time to see changes.

Worth noting that whilst users need read / write access, you cannot have the master workbook open in read / write mode.

Dave

 

[Patriot2879]

Hi Dave, what would you recommend? and how would I do this? sorry I thought my other thread was separate to this thread as different to the original subject.

 

[dmt32]

Hi Dave, what would you recommend? and how would I do this? sorry I thought my other thread was separate to this thread as different to the original subject.

Its a similar subject line which a MOD may (or may not) have a view on.

It it was a project I was doing I would connect template copies to a central database (Access ) but you can use another workbook as a simple database.
I have done many of these in past & it can be a lot of work.

If this is an approach you want to take you may do well to head to the Access forum & see if people there can assist. Or if want to use another workbook then create copy of your data tab & save it as separate file on shared network.

You then need to develop code for the template copies to

Open workbook read only to extract data to your table & close it

Open workbook read / write to write data to it save & close

Included in code you would need functions to manage errors & conflicts from other users amongst other things

And repeat what I said last time, you cannot have a master workbook open read / write whilst others need to write data to it also, they will not see real time updates.

Dave

 

[Patriot2879]

Hi Dave, ok thank you for the update what I would probably need is simple database in another workbook an make templates of the userform. but I don't have any idea on how to do that way over my had , also would it be possible o say when someone else is in another userform?

 

[dmt32]

Hi Dave, ok thank you for the update what I would probably need is simple database in another workbook an make templates of the userform. but I don't have any idea on how to do that way over my had , also would it be possible o say when someone else is in another userform?

Search the net, examples are out there

With template workbook you would not need to know if user(s) had their copies open if fact, they can leave them ope all day if want.
The one you cannot have open is the database workbook read / write mode. Only the code in template copies should do this.

Dave

 

[dmt32]

Please could you advise how I could make template copies of m workbook for multiple users where they read / write data to central workbook (database) over a corporate network. this would be amazing.

I found some spare time & decided to have a further look at your project & this request to share across network & think that as you a are using a fixed matrix for your data it mau be a little easier to manage with multi users than I first thought.

A possible solution would be to link the users template workbooks to a master (database) which when they update, changes should be reflected on other users copies. This process would all be managed by VBA code but idea would need further development & tested over your network.

Dave