Linking two sheets in different workbooks takes a long time even with only 500 rows of data. Is there a quicker, more efficient way to do this?

chazrab

Well-known Member
Joined
Oct 21, 2006
Messages
918
Office Version
  1. 365
Platform
  1. Windows
As stated. All I'm doing is highlighting and copying only 500 rows of data across 10 columns of an address book, which is in two different workbooks.
When the source userform is changed /updated, the other should update automatically because of the link. It's not instantaneous. I have to save the destination
file, close the destination workbook reopen it to see the updated changes. Very inefficient and slow. Am I doing something wrong and not uderstadning
linking capabilities correctly? The simple code for the source workbook is:
Code:
Private Sub PutData()
Dim ws As Worksheet, l As Long
Set ws = Worksheets("NEW")
With ws
ws.Cells(Me.Row, 1).Value = TextBox3.Text
ws.Cells(Me.Row, 2).Value = TextBox8.Text
ws.Cells(Me.Row, 3).Value = TextBox9.Text
ws.Cells(Me.Row, 4).Value = TextBox2.Text
ws.Cells(Me.Row, 5).Value = TextBox1.Text
ws.Cells(Me.Row, 6).Value = TextBox4.Text
ws.Cells(Me.Row, 7).Value = TextBox5.Text
ws.Cells(Me.Row, 8).Value = TextBox6.Text
ws.Cells(Me.Row, 9).Value = TextBox7.Text
ws.Cells(Me.Row, 10).Value = TextBox10.Text
ws.Cells(Me.Row, 11).Value = TextBox11.Text
ws.Cells(Me.Row, 13).Value = Website2.Text
ws.Cells(Me.Row, 14).Value = Itemfield.Text
ws.Cells(Me.Row, 15).Value = NDEBIGVIEWMOREINFO.TextBox2.Text
DisableSave
End With
End Sub
PutData just adds and saves changes to the Source sheet which is named NEW. For clarity, the source and destination userform is the image below
Thanks for anyone's help.
cr
 
Last edited by a moderator:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,224,595
Messages
6,179,798
Members
452,943
Latest member
Newbie4296

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top