Synchronise 2 worksheets , VBA code to update in both files.

**stevnb** · 12-18-2012, 06:24 AM

Hello dear readers!

As in the past this forum has helped me allot. I'm beginner at vba coding myself so sometimes i don't know if things can be done.

The problem

I have 2 or more persons who need add data to 1 specific sheet. ( ill post it in attachments)

Person #1 adds new rows and data to columns BCDEG. ( in the attachtment)
Person #2 enters data to through a userform he/she selects a value of Column D(combobox) this will get the coresponding Row number. Next is the other combobox he/she selects the coresponding column head. To get the coresponding column number. In this way the text is added at the right place.

Problem: i dont want people to be working in the same file , read only and maybe errors if you do.
So i want 1 equal worksheet which updates at both sides in 2 different files.

Problems i expect to happen when people do work in 1 file:Person #1 adds a new row, this is not updated yet. Person #2 at the same time enters a value of column D in combobox and gets the coresponding row (old). Person #1 saves the file. So there is a new row. Person #2 presses OK and the data will enter in row for example 9. But there is a new row entered at between 5 and 6 so now the right position would be 10 not 9. And the data ends up at the wrong place. ( i gues this will happen very rarely but this is a problem)

How can i solve this?

( the sheet i need to synch is sheet " MAIN " )

**stevnb** · 12-18-2012, 06:58 AM

Forgot something that might be important. I would like to let this synch happen everytime it opens. In this way the sheet of person #2 won't change in the time he is entering the rownumber. Then saves. Then opens again and both files are changed.