Multiple Data Entry

Good Afternoon

I would like if several people were connected, you can enter the information at the same time as the other people without finding any problem in the data.

After that i'll Share the Workbook.

Thank you in advance.

It seems that what I'm asking is a little complicated.

Not as complicated as mine LOL

*Search "hi i need help looping this index match in vba", this stupid site won't let me post links yet ugh

No one has a solution yet :l

Hi, Collin

You have to have patience I saw your request and you have the best they helped me before Mikerickson and FDibbins, by the way try to do something with those Workbooks.

Put this Hyperlink in the Google wep
https://www.excelforum.com/tips-and-...mitations.html


Attached Files Attached Files
Good Luck

Why don't you just have your workbooks in the Cloud, SharePoint, or even Google sheets?

Because VBA does not work online, you have to open it in Excel and if you open it when you save it, create another Work book. That's why that does not work for me.

Ahh forgot you're using Macros

Take a look at what I send you maybe you will find what you need there.

I did, does not help with what I need at all.

I need a looping index match between 2 workbooks.

Sorry, you have to upload some examples using (go advance) and then (Manage Attachments)

'Open
Dim O As Variant
Set O = Cells(3, 69)
Dim R79 As Workbook
Set R79 = Workbooks.Open(O)

'PO#
Dim rw As Integer
rw = 7
Dim PO As Range
Set PO = Cells(rw, 82)

'Loop Check
Dim LC As Integer
LC = 7
Dim LoopCheck As Range
Set LoopCheck = Cells(LC, 79)

'PO Anchor
Dim PO_LkUp As Integer
PO_LkUp = 7
Dim PO_Anchor As Range
Set PO_Anchor = Cells(PO_LkUp, 80)

'PO# Level

Do Until LoopCheck = ""

Sheets("Non-Labor OPEX Budget").Range(PO) = Application.Index(R79.Sheets("sheet1").Range("Y:Y"), Application.Match(Sheets("Non-Labor OPEX Budget").Range(PO_Anchor), R79.Sheets("sheet1").Range("AN:AN"), 0))

rw = rw + 1
LC = LC + 1
PO_LkUp = PO_LkUp + 1

Loop

R79.Close

End Sub

I'm sorry I don't quite understand?